Hi, i got as far as:
cd /path/to/where/you/uploaded/backupsql/
mysql -uUSERNAME -pPASSWORD DB_NAME < backup.sql
I'm in SSH in the directory where my backup sql file is in and i'm logged into mysql as root and have the prompt:
mysql>
my db name is links, that i had created using phpmyadmin, so i entered:
mysql> use links;
mysql> links < backup.sql;
and i got the error 1064 (42000): you have an error in your sql syntax..
Can you provide some help on what i'm typing wrong here? thanks
cd /path/to/where/you/uploaded/backupsql/
mysql -uUSERNAME -pPASSWORD DB_NAME < backup.sql
I'm in SSH in the directory where my backup sql file is in and i'm logged into mysql as root and have the prompt:
mysql>
my db name is links, that i had created using phpmyadmin, so i entered:
mysql> use links;
mysql> links < backup.sql;
and i got the error 1064 (42000): you have an error in your sql syntax..
Can you provide some help on what i'm typing wrong here? thanks