How to Backup and or Restore your MySQL Database Using SSH

Backup MySQL Database

Connect via SSH and run MySQL

1. Connect to the server via SSH
2. Type PWD, this will let you know what the directory you are working in
3. To restore the SQL file the was uploaded you can run the below command:

   mysqldump -u DATABASE_USERNAME -p DATABASE_NAME > FILENAME.SQL

   Please note: The -p will prompt a user to enter the database password after the command is ran
4. Once the MySQL dump has been completed the SQL file will be stored in the working directory
5. Once this is completed without errors the command line will return to the below:

   username@domain.com [~]#

6. If you require a local copy of your database you can download it via FTP. Below is a KB article on how to connect via FTP:
   How to Use FTP

Restore MySQL Database

There a two steps to restore a SQL backup via command line:

• Upload SQL file via FTP to server
• Connect via SSH and run MySQL

Upload SQL file via FTP to server

1. Connect to the server via FTP
2. Locate the SQL file on your local machine
3. Upload the file to the home directory
   
   cPanel:
   
   
   Plesk 12.x
   

Connect via SSH and run MySQL

1. Connect to the server via SSH
2. Type PWD, this will let you know what the directory you are working in
3. To restore the SQL file the was uploaded you can run the below command:

   mysql -uDATABASE_USERNAME -p DATABASE_NAME < FILENAME.SQL

   Please note: The -p will prompt a user to enter the database password after the command is ran
4. Once this is completed without errors the command line will return to the below:

   username@domain.com [~]#