Database Tools
Database Backup Utility
Control Panel Location: Tools > Utilities > Back Up Database
Tip: Two ways to back up your ExpressionEngine Database
This utility allows you to make simple SQL dump backups of your ExpressionEngine database. For file backups, or more robust and automated database backup options, please refer to Back-up your ExpressionEngine database and files.
When you click “Back Up Database”, a SQL dump will be created and stored in your system/user/cache/ folder, named based on the date and time of the backup, e.g.: my_database_2017-10-20_09h20mPDT.sql
SQL Manager
Control Panel Location: Tools > Utilities > SQL Manager
This section of the Control Panel allows you to manage your database. The main SQL Manager screen shows a table of your basic database information and a list of tables.
By selecting the checkbox next to a table and picking an option from the dropdown at the bottom a table can be optimized or repaired, if necessary.
Click the “eye” icon to browse the table. From there, you can search the table for the content you are interested in viewing.
SQL Query Form
Control Panel Location: Tools > Utilities > Query Form
This section presents a form that you can use to submit any standard database query. This feature is intended for advanced users since any changes you may make with a query are permanent.
Buttons at the bottom of the form can be used to provide you with a base query for many commonly used queries.
By default MySQL query errors are displayed.
