Having Problem With Mysql Database Upload

[NewEraCracker]

mysql -u hack -p hacker < backup.sql

'hack' is the user-name
'hacker' is the database name

password is asked interactively.

NewEraCracker Reviewed by NewEraCracker on 8th Dec 2011. Having Problem With Mysql Database Upload Hi when iam trying to upload my old mysql database on to my new vps through ssh using the command: mysql -u hack -p hacker <backup.sql its returning me the following error: ERROR 1064 (42000) at line 195527: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Adobe Premiere Pro CS4 and Adobe After Effects CS4 to Adobe CS5 Rating: 5

[maverick79]

mysql -u hack -p hacker < backup.sql

'hack' is the user-name
'hacker' is the database name

password is asked interactively.

yes
used this method but i can restore only 106 tables out of the 217 tables i have in my database

[Lock Down]

That is very strange as it should never be stopped as an ssh command.

What happens to cause it to stop or abort?

I have a 6 gig db on a vps I restore that way and it takes about 4-5 minutes. Your host must having something set wrong.

Unless you are on a shared host.