Latest Announcemnent
New thread

Having Problem With Mysql Database Upload

Status
Not open for further replies.
M

maverick79

Active Member
179
2011
14
0
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
 
12 comments
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.
 
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.
 
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.
 
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
 
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.
 
As i said before, re-upload your Database and try again.

feronso said:
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.
Click to expand...
 
Status
Not open for further replies.
Back
Top