Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Apr 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #1064 - You have an error in your SQL syntax;

    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.

    Code:
    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
    Code:
    -- 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?

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,861
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    What happens when you execute just the query, after removing all other lines?

    Code:
    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 ;
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •