If you are doing whole database backup & restore use mysql dump rather than mysql Admin tool, it will run *much* faster.

mysqldump --verbose --compress --host  -u USERNAME  -pPASSWORD
 --databases DATABASE > ~/dumps/dump.sql

If dragging data through network, use –compress flag.
Also check the man pages of mysqldump, you might find interesting hints for different needs.

Tags: database dump, mysql admin, mysqldump

Posted in MySQL
No Comments Yet Posted by akiko