Back to Making use of Your cPanel Account

How To Use Database Management With PHPMyAdmin Tools

What do the check, optimize, and repair tools do in PHPMyAdmin?

Check: This will search for any large inconsistencies or to try and determine if a table has crashed. If you do see anything listed in Check, run Repair first to try and resolve any issues.

Optimize: This tool should be performed when you delete or modify several records from the table [or when frequent changes are made to the database in a short period]. It will reclaim the used space, defragment the data file, and remove the overhead. Since it also sorts the indexes it can help with query time in the future.

Repair: Essentially only really useful when tables have crashed, or have open connections that create issues when you try to run queries or optimize. This is also the tool to use if you suspect data corruption [either from improperly closed connections like server crashes or manually killing MySQL processes] and would like to make sure everything is running well.

Related Articles

Does WestHost Allow Remote MySQL
Does WestHost Offer Postgres MySQL
How To Backup A MySQL Database
How To Create And Download A Backup In CPanel
How To Disable All WordPress Plugins

Can’t Find what you need?

No worries, Our experts are here to help.