-- MySQL client's most useful commands II--

mysqldump

mysqldump --all-databases > all_db.sql - dump all db's

mysqldump --databases dbname > db.sql - dump a single db

mysqldump --databases db1 db2 > 12_db.sql - dump choosen db's

mysqldump -d - dump db structure only

mysqldump --host=localhost --all-databases | mysql --host=remotehost

- copy db from localhost to remotehost

mysqldump --host=localhost --all-databases |

mysql --host=remotehost --add-drop-table

- copy all db's from localhost to remotehost and overwrite existing tables

mysqlcheck

mysqlcheck -c --databases db1 db2 db3 ... - check databases

mysqlcheck -r .... - repair databases

mysqlcheck -a ... - analyze databases

mysqlcheck -o ... - optimize databases

mysqlcheck -o --database db1 - optimize only