MySQL database import / Export / Dump via SSH

1. Exporting a MySQL database

To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:
mysqldump -uUSERNAME -pPASSWORD DATABASE > backup.sql
Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. The MySQL database will be exported to a file named “backup.sql” in your current directory. The name of the MySQL dump you are exporting to can be whatever you want.

2. Importing a MySQL database

To import a MySQl database, you need to use the mysql command. Here is the full command for importing a MySQL dump into a database:
mysql -uUSERNAME -pPASSWORD DATABASE < backup.sql
Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. For DATABASE you must use an existing database.

Tags: ,

Nemanja Radevic

Wordpress expert Joomla expert Front end development expert Warp Framework expert Responsive design

Donate to help us continue and write posts to help people out there