November 23, 2012 by aubreykloppers
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.
The file dbname.sql now holds a backup of your database and is ready for download to your computer.
Import A MySQL Database
The file must be in .sql format. It can not be compressed in a .zip or .tar.gz file.
- Start by uploading the .sql file onto the server
- Using SSH, navigate to the directory where your .sql file is.
- Next run this command:
mysql -p -u username database_name < file.sql
Note: The -p will prompt for your account’s password.
Note: username is the user with rights to the database. If you are unsure what the username is you can use the same username and password used to sign into SSH.