Using MySQL GUI Tools

From A2Wiki

The free MySQL tools MySQL Administrator and MySQL Query Browser are incredibly useful. They allow you to work with your MySQL database with a GUI on your local machine, using a TCP connection to our MySQL databases. MySQL Administrator has graphical traffic and health-monitoring, optimization tools, and perhaps the most useful tool of all, database backup (see below). MySQL Query Browser is a graphical database browser and SQL query builder/executor. With it you can look at your data, add/drop columns and rows, change values, etc., all from a local GUI tool.

Requirements

Using the MySQL tools requires that you be able to connect to our server remotely. See Connecting to MySQL Remotely.

Database Backup and Restore

With MySQL Administrator, you can back up your database to a local file, and restore it from a previous locally-stored backup. Particularly useful is its scheduled backup feature. You can set up one or more scheduled recurring backups and MySQL Administrator will create local backup files of your database(s) automatically.

Backing up and restoring a MySQL database using MySQL Administrator is far easier than using the MySQL tools in cPanel.