Question:
How to back-up and upload MySQL databases on the command line?
To back-up use the mysqldump command. For example:
mysqldump -Qq -hdb28.pair.com -uzrtch_2 -p zrtch_mykb > my-dump-mykb.sql
To upload use the mysql command. For example:
mysql -hDBSERVER -uzrtch_26 -p zrtch-espanaviva dump-espanaviva-13OCT07.sql