Upload database through PuTTy SSH
Instructions & comand lines
1. First of all you need to upload your database.sql file to your root directory (public_html)
2. Create a new database or clear the one you plan to import into
3. Download SSH Putty from here: [ Ссылка ]
4. Enable & activate your SSH status on your Cpanel
5. Connect to your hosting account via SSH (You will find the IP, Port, Username & password on your Cpanel dashboard)
6. Once connect: insert your username & password and click enter
7. Find your "Home root" It looks like this:
/home/u123456789/domains/vccmaroc.com/public_html
8. Then insert the first following command line:
cd /home/u123456789/domains/vccmaroc.com/public_html
Note: please replace "Home root" with yours
9. Insert the second command line:
See here [ Ссылка ]
Note: please replace database_username & database_name with yours as well as the file.sql with the database file name that you uploaded previously to your public_html
10. Click enter
11. After that you will need to enter the database password - the importing process will start immediately. When it is completed, a new line will appear:
-bash-4.2$
12. Keep in mind that the import will take some time depending on the size of your database.
That’s it! Now you know how to import your MySQL database 😊

свернуть