Restoring a Single Database via SSH
This article will explain how you can restore a single database via SSH.
- 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
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.