...

View Full Version : #1064 - You have an error in your SQL syntax;



Kinal
04-19-2013, 01:46 PM
I am moving a friends site from a free web host to my VPS. But when I download her database and try to upload it I get this error.


SQL query:

����vG�& _w?E��ʖv �i�.�d�e�I[U��\dH1� �� T�z��~����{ _���&�${~sF�)�,ɐ��r��SddČ���Z͙O�'�#w��ٟ�9������jΕ�b/ �V�٬wpf�$󃽽�bQ�gfK�g��N�"��Ɂ��#�O�'N}����{3}��#�����Ͷ��18h5���|�#z�}��ӭ7��>��~}�����.���y�c�������T�f��kt/�j��O\� �7�?��s5��'Q:J�H;�0r>�����(��t��t�䍏�rt��9?z�쉳S�cǹ�_g?/<w�z/H����4��I�]��w����=s�~8����9�w����.4M����O���������n��K��q�T4���^�۽�݆g��������`���N�?>9��/ηO������p�Ա{ţ��� ���������|�w>Ϧ�(� &�KS��a?~~���s����wk78?=���ٽ���l�:�]��$R���;'*I��v1Z�?�SK��-%D�h���u;�F�ۻk��X��V�֡�zo�%�O��VZ�mn�0\�Vc����{[��� 66��R���7_�sb��o`u�ڧU�L�h�I�`��=��� =S���s���7�a� .Ҩ�`�ƒǧ_H+�8 � l����4��z �Y��Z�ABiho�K͈qc֚�M_�:Y�y^i�8��k�<6�~����F1Y���^S~b�"~M%2LcU�r�;Fa �o�⸷vj�f;���>���t��Ԧn�ݎݽ�36�֠�.ߺ�ť]�I�����/Օ7���3{�ǥ��a��邰6T�D�������p�߬�{�V�D�}C �5��V�d����Asp����;��r&�&1n���Vw��� \83,������i�@Fs���"��#�\��X8���vT�:A�8���΋���ҹ���Yhb��0 &$;���ِ~��p�C�Q��G��.���ۋCb �/�[...]

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


-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 19, 2013 at 08:29 AM
-- Server version: 5.1.57
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `a1100605_baby`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `comment_id` (`comment_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `wp_commentmeta`
--

Anyone know what the issue is?

abduraooft
04-20-2013, 12:43 PM
What happens when you execute just the query, after removing all other lines?


CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `comment_id` (`comment_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum