Having Problem With Mysql Database Upload

[maverick79]

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 [ENGLISH-32 Bi' at line 2

It is an Vbulletin forum and i dont really have any idea about this

maverick79 Reviewed by maverick79 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]

bump

[BlaZe]

Maybe upgrade your MySQL to the latest stable release.

Check it out on www.mysql.com

[maverick79]

Maybe upgrade your MySQL to the latest stable release.

Check it out on www.mysql.com

well its the latest version and up to date.
Also my database is working on the other server which is of same grade and software.

[Tele]

try with phpmyadmin

[KingOfDCP]

Try using Bigdump. It's simple and easy to use.

If it does not work, try mysqldumper. It's very useful when import big database.

[feronso]

There is no issue with MySQL. its the fault of Database file not uploaded completely.

Upload the file again. not through the FTP. through HTTP. and try again.

the same issue i fix myself tomorrow. its exactly same issue was that.

[XSLTel]

could you please paste the first 3 lines of that .sql file here pastebin.com

and provide us with link and we will examine it.

looks like there is something wrong in line 2.

[Lock Down]

Where is the database name in this statement

mysql -u hack -p hacker <backup.sql


Should be

mysql -u hack -p hacker DatabaseNameGoesHere < backup.sql

[NewEraCracker]

mysql -u hack -p hacker < backup.sql

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

password is asked interactively.