Importing and Exporting Your MySQL Databases via SSH

[Mobo]

Import via SSH:

1. Upload the .sql file to your home directory (where public_html, public_ftp, and mail reside.)
2. Login via SSH (I recommend PuTTY for windows and Mac OS X has it's Terminal application, and linux has it's own also.)
3. In SSH type:
4. mysql -uPutYourUserHere -pPutYourPasswordHere PutYourUserHere_databaseName < database.sql
   
   NOTE: That is a one line command.

Export/dump The Database
Export/dump via SSH:

1. Login via SSH (I recommend PuTTY for windows and Mac OS X has it's Terminal application, and Linux has it's own also.)
2. In SSH type in the following command:
   mysqldump -uPutYourUserHERE -pPutYourPasswordHERE PutYourUserHERE_databasename > database.sql

[Mobo]

Please Note:
The name database.sql can be named to anything you wish, but make it so that you can tell which is the latest dump in the event you find the day you need to restore a backup.