#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0

    #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. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Kinal
    Anyone know what the issue is?
    yes, it should be fairly obvious

    this --

    ����vG�& _w?E��ʖv �i�.�d�e�I[U��\dH1� ........

    is not valid sql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0
    What is causing it to do that?
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Kinal
    What is causing it to do that?
    sorry, no idea

    the code you posted (the phpmyadmin dump) is fine

    the error message doesn't really correspond to that code
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0
    So something is going wrong when I import it?
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Kinal
    So something is going wrong when I import it?
    not sure what you mean by "import"

    the code you posted (the phpmyadmin dump) is text consisting of sql statements, and it should be fed into the mysql engine
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    4
    Rep Power
    0
    I think I got it figured out. I opened it up in dreamweaver and imported into the new server with out compression. I also renamed it.

    Weird..
  14. #8
  15. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Kinal
    with out compression
    oh, that would explain it!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo