WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WordPress mySQL error on phpMyAdmin 2.5.6 (4 posts)

  1. iKaspars
    Member
    Posted 3 years ago #

    Hello, guys.

    I am trying to import a wordpress database to other server, but that server have old phpMyAdmin 2.5.6 version.

    When I am importing that database I am getting error :#1064 - You have an error in your SQL syntax near 'SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1

    When I comment that line out, I get another error.

    Is there any way to get it work on this server?

  2. 123milliseconds
    Member
    Posted 3 years ago #

    >>>I get another error.

    and it is ...

    Your host SQL version is lower than the SQL version at the host where you did the export

    try exporting is csv format; NOT as sql statements

  3. iKaspars
    Member
    Posted 3 years ago #

    When I comment out that firs line I get this error :

    SQL-query : 
    
    CREATE TABLE  <code>wp_commentmeta</code> (
    
     <code>meta_id</code> BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
     <code>comment_id</code> BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT  '0',
     <code>meta_key</code> VARCHAR( 255 ) DEFAULT NULL ,
     <code>meta_value</code> LONGTEXT,
    PRIMARY KEY (  <code>meta_id</code> ) ,
    KEY  <code>comment_id</code> (  <code>comment_id</code> ) ,
    KEY  <code>meta_key</code> (  <code>meta_key</code> )
    )ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1
    MySQL said:
    #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ' at line 9

    I tried to save as CSV and i got this error -

    MySQL said:
    #1064 - You have an error in your SQL syntax near '"1"' at line 1
  4. iKaspars
    Member
    Posted 3 years ago #

    Thanks, I fixed it.

    I used a SQL compatibility mode - MYSQL323

Topic Closed

This topic has been closed to new replies.

About this Topic