see-my-pic.com - MySQL Import and Export (.sql file) via SSH

see-my-pic.com - MySQL Import and Export (.sql file) via SSH: "MySQL Tutorial - Import or Export A Database
This tutorial outlines the steps for importing and exporting MySQL databases via command line (SSH). Click Here for information about getting SSH access.

1. Export A MySQL Database

This example shows you how to export a database. It is a good idea to export your data often as a backup.
Using SSH, execute the following command:
mysqldump -u username -p database_name > dbname.sql
You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name.
File dbname.sql now holds a backup of your database and is ready for download to your computer."

'via Blog this'