Restoring a Single Database via SSH

This article will explain how you can restore a single database via SSH.

Note:

• For security reasons, only the accounts have passed our verification will be granted permission to the Shell / SSH service. If you would like to enable it, please update your billing information. Our staff will finish verifying your information within 2 hours.

1. Import files

Import the file from your local machine to the MySQL Server using FTPS. For details, please take a look at the documentation.

2. Navigate to the Shell / SSH page

Click the "Manage" button on the Home page or the My Applications page to go to the Shell / SSH page.

3. Connect to the database

Click the “Connect” icon on the Shell / SSH page to launch the command-line interface.

Input the command “mysql -u <user_name> -p”, followed by entering the password of the user.

<db_user>：a user name of the database

Switch to the database that needs to be restored by typing in the command: use <db_name>

4. Restore the database

Enter the command: source /cloudclusters/<file_name> to restore the backup file.

<file_name>: the name of the backup file you would like to restore from.

E.g. source /cloudclusters/wp.sql

That's it! You've restore the database successfully.