error at restoring dumped sql

windstory · 08-17-2010, 01:12 AM

error at restoring dumped sql

I have backuped sql by mysqldump on mysql version 5.1.41.
But when I restore this sql by command "mysql -uroot --default-character-set=utf8" my-db < my-sql.sql" I've got this error message.

Quote:

#1064 - 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 'barunarum',1,1,1,1,1,1,1,1,1,1,3,3,-1,5,1,-20,0,'','script|iframe',0,0,0,0,0,0,0' at line 1

What is this error and how to solve?

Thanks in advance.

dr_agon · 08-17-2010, 06:54 AM

Probably your my-sql.sql file schould contain proper SQL statements, and looks like it contains only comma-separated data.
Check it, and post a few lines of this file.

I don't use mysql, but it is worth checking if the command for restoring db matches the command used for backing it up (regarding the format of saved data).

windstory · 08-17-2010, 09:31 AM

After changing option at phpmyadmin - that is to select 'mysql40' at sql compatibility mode, the error message changed.

Quote:

SQL query:

INSERT INTO `g4_visit` VALUES (272246,'66.249.68.167','2009-08-14','00:00:16','','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)'),(2...39;Mozilla/5.0 (Twiceler-0.9 http://www.cuil.com/twiceler/robot.h...39;Mozilla/5.0 (Twiceler-0.9 http://www.cuil.com/twiceler/robot.h...39;Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; http://help.yahoo.com/help/us/ysearc...39;EMPAS.ROBOT (compatible; MSIE 5.01; Windows NT 5.0)'),(272251,'66.249.68.195','2009-08-14','00:13:54','','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)'),(2...N','Mo[...]

MySQL said: Documentation
#1064 - 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 'Mozilla/4.0 (compatible' at line 1

dr_agon · 08-17-2010, 03:49 PM

The error number did not change. Just believe what it says - there is a syntax error.

Have you checked the delimiters and quoting in the SQL statement?
Can you execute this statement when entered manually (not from the file)?

PS. Wrap code segments in [CODE], not [QUOTE] marks, and post the whole statement correctly.

windstory · 08-18-2010, 01:48 AM

dr_argon/ The error message is here;

Code:

SQL query:

INSERT INTO `g4_visit` VALUES (272246,'66.249.68.167','2009-08-14','00:00:16','','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)'),(2...39;Mozilla/5.0 (Twiceler-0.9 http://www.cuil.com/twiceler/robot.h...39;Mozilla/5.0 (Twiceler-0.9 http://www.cuil.com/twiceler/robot.h...39;Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; http://help.yahoo.com/help/us/ysearc...39;EMPAS.ROBOT (compatible; MSIE 5.01; Windows NT 5.0)'),(272251,'66.249.68.195','2009-08-14','00:13:54','','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)'),(2...N','Mo[...]

MySQL said: Documentation
#1064 - 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 'Mozilla/4.0 (compatible' at line 1

Please take a look at this link.
http://rapidshare.com/files/413618750/ERROR.7z