The database manager component, is a very useful component for administrators, as it helps them to view important information about Elxis database from Back-End without needing an extra application, like phpMyAdmin.
Administrators can:
All files are UTF-8 Encoded.
Manage Backups: Opens the 'Database Manager: Backups' page, described in another help screen, from where you create new database backups or delete older.
Help: This Help Screen.
Page is divided in two areas. The left where you can see existing tables and the right from where you can perform operations on the database.
The left area shows all the database tables. Each row has two icons. The "Browse" and "Structure".
Click the "Browse" icon to view table's data. Below the data table, there are two links. Click "Table Structure" to view a detailed view of table's structure. Click "Back to Database" to return to this screen.
Clicking the table name or the "Structure" icon, you can view a detailed view of table's structure. Below table's structure table, there are two links. Click "Browse table" to browse table's data. Click "Back to Database" to return to this screen.
The right area has three tabs: "Information", "Dump Database" and "Maintenance".
The information tab shows information for the database.
Using the controls on this tab, you can backup database data and structure in XML or SQL format.
How to backup in XML formatHow to backup in SQL format:
You can use these two functions to optimize and repair the database used by Elxis.
Optimize: Optimizes database and increases performance.
Repairs: Repairs any existing errors in database tables.