Legacy Documentation
You are using the documentation for version 4.3.8. Go here for the latest version.
SQL Manager¶
Control Panel Location:
This section of the Control Panel allows you to manage your database. You can view information about the database, run queries, optimize your tables, and more.
The main SQL Manager screen shows a table of your basic database information.
Permission Restrictions¶
- Access Tools sections: Utilities
- Access Tools sections: SQL Management
Actions¶
Bulk Actions¶
The checkbox in the right-most column of the table selects a button for a bulk action. When at least one checkbox is checked the bulk action dropdown menu and submit button will be made available in the lower righthand corner of the table.
Repair¶
This performs a standard SQL “repair” on your selected tables. Tables can occasionally become corrupted, which is typically repairable using this option.
Optimize¶
This will perform an optimization on your selected tables, which you are encouraged to run occasionally to eliminate database fragmentation.