how can fix error 1064 mysql

Question

Error

SQL query:

INSERT INTO `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES (2388, 60, '_count-views_day-20130726', '2'), 
(2389, 140, '_count-views_day-20130726', '61'), 
(2391, 82, '_count-views_day-20130726', '2'), 
(2392, 22, '_count-views_day-20130726', '23'), 
(2393, 78, '_count-views_day-20130726', '7'), 
(2394, 35, '_count-views_day-20130726', '2'), 
(2395, 32, '_count-views_day-20130726', '2'), 
(2396, 13, '_count-views_day-20130726', '1'), 
(2397, 83, '_count-views_day-20130726', '9'), 
(2398, 137, '_count-views_day-20130726', '8'), 
(2399, 90, '_count-views_day-20130726', '6'), 
(2400, 68, '_count-views_day-20130726', '1'), 
(2401, 6, '_count-views_day-20130726', '1'), 
(2402, 79, '_count-views_day-20130726', '5'), 
(2403, 33, '_count-views_day-20130726', '2'), 
(2404, 33, '_count-views_week-201330', '6'), 
(2405, 61, '_count-views_day-20130726', '8'), 
(2406, 141, '_count-views_day-20130726', '5'), 
(2408, 49, '_count-views_day-20130726', '8'), 
(2409, 22, '_count-views_day-20130727', [...]

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 ''_count' at line 1045

How can I fix that error? I was going import by MySQL!

@developerwjk, it's a mysqldump file for a Wordpress database. — Bill Karwin, Oct 15 '14 at 23:46
How are you using the query? Pasting it into the console? or running a .sql file? (Hint: you should run the .sql script) — developerwjk, Oct 15 '14 at 23:48

turutosiya · Accepted Answer · 2014-10-16T00:39:40.977

0

~~It seems that your INSERT statement is too long.~~

Try increasing max_allowed_packet at my.cnf. For instance, max_allowed_packet=512MB

Try following commmand :

mysql your_wordpress_db < your_dumped_file.sql

edited Oct 16 '14 at 00:39

answered Oct 15 '14 at 23:45

turutosiya

1,051
10
17

can you write more details? – Saeb Khanzadeh Oct 15 '14 at 23:47
Wouldn't that throw a [different error](http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes)? – showdev Oct 15 '14 at 23:48
This is wrong. Probably he's pasting it in the console rather than running the .sql file which is the right way to do it. – developerwjk Oct 15 '14 at 23:49
@showdev thanks. maybe 1153 ? – turutosiya Oct 16 '14 at 00:29
@SaebKhanzadeh ok. but first, let me know. How did you run that sql statement? via phpadmin? via command line? – turutosiya Oct 16 '14 at 13:26
by phpadmin @turutosiya – Saeb Khanzadeh Oct 16 '14 at 14:27
@SaebKhanzadeh then, you upload .sql file? Or paste the sql statement? – turutosiya Oct 16 '14 at 14:30
i upload @turutosiya – Saeb Khanzadeh Oct 16 '14 at 14:38
@SaebKhanzadeh thanks. Can you confirm that your .sql file is not trimmed? I mean that I doubt that your .sql file doesn't contain full dump of the db. – turutosiya Oct 16 '14 at 14:57
@turutosiya wow, but i have only that!!! if your thought be correct how can i fix it? – Saeb Khanzadeh Oct 17 '14 at 20:07
@SaebKhanzadeh In case your .sql doesn't contain complete statement, we have no option to fix the issue. You can open .sql with text editor. Please check. – turutosiya Oct 18 '14 at 09:21

how can fix error 1064 mysql

1 Answers1