nerbonne.net

Dump all MySQL databases to a file:
mysqldump -u admin --password=rootpass -x --all-databases > /root/all-databases.sql
Dump one MySQL database to a file:
mysqldump -u admin --password=rootpass database >/root/database.sql
Drop a database:
mysqladmin drop database -u admin --password=rootpass
Import a sql backup file:
mysql -u admin --password=rootpass database < database.sql
Check open tables:
show open tables; (when logged into mysql)