SSH-Restoring Your Sql

Restoring your sql database with ssh is the easiest way.If your tried “big dump” or “mysql dumper and didnt work, this will get it done. After you have your sql database made in Cpanel, you upload your sql backup to a new folder in your home folder named “SQL” and name your backup “backup.sql”and unpack/unzip it. Open your putty program

Putty

and log in as “root” and enter your password.Next you type in this;

mysql -u user -p dbname < /home/SQL/backup.sql except, where it says "user" you change to your sql data base user name, and where it says "dbname" your change to your sql database name ,then change last part to your info, /home/"if I named folder "SQL", Id just put SQL here/backup.sql When you get command right, it will ask for sql user password, enter it and click enter and it will restore your backup. Depending on size , this will take some time,but, when a new line comes up in putty, your done and sql is restored.

Leave a Reply

Your email address will not be published. Required fields are marked *

If you are human, count objects:
Enable this image please
I see:
- +
- +
- +
Ironclad CAPTCHA (Security Stronghold)