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.