Title: #1064 – error SQL syntax – line 1 – phpMyadmin Last modified: August 21, 2016 --- # #1064 – error SQL syntax – line 1 – phpMyadmin * [80grit](https://wordpress.org/support/users/80grit/) * (@80grit) * [12 years, 3 months ago](https://wordpress.org/support/topic/1064-error-sql-syntax-line-1-phpmyadmin/) * Hi, It’s 3 sleeps before Christmas and this greenhorn is FREAKIN’! I REALLY needs some help. * My story in a nutshell. a.) Backed up an existing WordPress site to my computer with MAMP (the WPsite was designed by someone else over a year ago). b.) Upgraded to WP 3.7.1 from WP 3.5, and changed the Revolution Slider. c.) Then uploaded files from localhost to live server by ftp, then placed WordPress folder in ‘ public’ folder. d.) Logged into C panel and created a database – I kept the databases’ name the same as the original. I, then, deleted the old database*. e.) Next, I went into phpMyadmin to import the WordPress database. Clicked on the database I created earlier, ‘Imported’ the gzipped database and pressed the ‘Go’ button a the bottom of the page. f.) At the bottom of a garbled pink error message, I got the following message: * MySQL said: #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 ‘‹’ at line 1 * *Because step ‘e’ didn’t work, now there’s no database connection to the WP site. As a newbie, I didn’t anticipate this error. By the way, I do have original version of the SQL. I tried importing that and got a longer error message. * Thanks everyone. Viewing 2 replies - 1 through 2 (of 2 total) * [popper](https://wordpress.org/support/users/julialasarte/) * (@julialasarte) * [12 years, 3 months ago](https://wordpress.org/support/topic/1064-error-sql-syntax-line-1-phpmyadmin/#post-4439784) * What’s the longer error with the sql database? * Thread Starter [80grit](https://wordpress.org/support/users/80grit/) * (@80grit) * [12 years, 3 months ago](https://wordpress.org/support/topic/1064-error-sql-syntax-line-1-phpmyadmin/#post-4439817) * Hey popper! BTW, the first error message is still there too. But, here is the longer error – a bug in the SQL parser. * ``` Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNpzDQryD7JScDZUcDZS8HH1s1IwUDBUMDEw4AoOAYrLc3H5VgYH+lgpmOoZ6pmZ6ibn5HCFBgcp +AfrKDi6u/qF6CiEuQIV+iYmKwQ7ujkGeQJVGuiZGptzBfg6WikY65noGRrqGXIFeASAVOr4B4PM MtIzU/DJzCut4PJx9HO3UkjN4wLbIt/NwQAGzG/+Rk+/7bbJgEstvcT6/T/Rm6/uTvuz8sShqQqn dW8vnR2bd3fbqpT3/7Z9v+CpVliaX2LteYiVKYdhjdDe7elfL6+ptNd/fmbO5rD9Z9aYfhZ/trbe y/5M1Gd9tcTcAmuIeiNhcyYVDe9Xk27t83CBCAnOlAQCQUnJi683Xk36WlL8Sr+5Y+7/28LfCvbG /F12PTkcalWzRZLf/Rf8GxImpq6e/Pjx69evQa6s2XSn4M8S+U6euEe/1z82sU5MVMspsX76kKku 6SJUpxDneYEzrhtE1N8snGF02ippWuKtnvQzEnMlnL890gwDGSLOuWXlbdvEvPtvb5vtq/z4lftb 7tIf5vst60sa78ra1/77ILj7eJ5tNUgpCNeWfqz58/bl5PD+Y+fn9/5/vnj6+fxat69GGdV/gmU4 11RcN/DjYb7355n58f+Pt/clSoED4LBXPEhv/aeCPw9eX56+nF9Pbq+M88UfBydvdj+v9672Z2qw 4W/54/Pftn74dPHnanXx59EKIZXSPc/9582Jm3NQQQ7kr/pvby4y/+lUkOrargjiW9f+ejFn7eab E+6tPFl5whhkwUNNn4P8k1We/TO93/NYZUb/+nD+9/11B6Ii1n5v+/8iTe+HiojO2UlfTaLVm84+ akkN+Xb466n5Pccuz3zuH/awSs7lcYltJFuklnQ90BkvjyqXFVb9P7k4durNufcNvjXXSD0+8u9A jSHXNJDte5L5+ub439z8vKE53H+eTKJtRr1ln8W1XY9OlhycbL3sae2pTzcVpghukgO5q6qGqzjo l5nAwv+nQdx9jx5K7eN7nDGv83rk4elLTxU+6n7CLuZyU/byny2cKSsSfA9VNLnW13xZzqV1rPG/ lEDIwXPLK4/KiO+KapwTtLTmQuVaJq75/54Ff3txMzz9vNzd6l2W1gDvkY3h ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 0 1 400 STR:  MySQL: 5.1.65-cll USR OS, AGENT, VER: Mac SAFARI 5.0.537 PMA: 3.4.11.1 PHP VER,OS: 5.2.6 Linux LANG: en SQL: ���[��F�0 >����ݖ���• �-ۥ�]nݶ�d�����I"I�l���g�Ӭy?/�̜�V�̬5���J?�Z�/&"27$(K��ھHD"�����b�ts�/������p�\���cW"I�8bN��� ``` * �e�������>|��p��� ^����4;aa<��~b�W” ��E�’졘2�:b�aڌg��C��)V> ���=an��� 6�y�� �m��7�9t��?}����n={>>}u�|����W��ϟ��磗�o}F�2h{�S �x�0N ���7��㷎a&� J_>�p���ӗ�.�C�����G�.�}�eS1�ǟ�������’�[ Ty��O��^�� <����� ��!<;}�蜭 �ِީ�y�3>�)L��$��5ߌ�$���W��~�ZX�����f.�$,͒�4[‘����eT���ʟ��ә�OV�zD�t=YY* �����#vqz�ɣ]�ٝ�0��|����|1 �<�c��Oٳ瀃WO�a=h9�8ֺ��t��;��}��� ��>z| sR�6 ���>�����h���Y×��q���D���� d�`M�x�E|�� *Ɓ�T�Χy��Z��R�|�y� ���S���Wg ��{�9; —-END RAW—-` * Thanks for your insight. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘#1064 – error SQL syntax – line 1 – phpMyadmin’ is closed to new replies. ## Tags * [line 1](https://wordpress.org/support/topic-tag/line-1/) * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) * 2 replies * 2 participants * Last reply from: [80grit](https://wordpress.org/support/users/80grit/) * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/1064-error-sql-syntax-line-1-phpmyadmin/#post-4439817) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics