Title: WordPress mySQL error on phpMyAdmin 2.5.6
Last modified: August 19, 2016

---

# WordPress mySQL error on phpMyAdmin 2.5.6

 *  Resolved [Smith](https://wordpress.org/support/users/ikaspars/)
 * (@ikaspars)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/wordpress-mysql-error-on-phpmyadmin-256/)
 * 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?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Alwyn Botha](https://wordpress.org/support/users/123milliseconds/)
 * (@123milliseconds)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/wordpress-mysql-error-on-phpmyadmin-256/#post-1938826)
 * >>>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
 *  Thread Starter [Smith](https://wordpress.org/support/users/ikaspars/)
 * (@ikaspars)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/wordpress-mysql-error-on-phpmyadmin-256/#post-1938971)
 * 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
       ```
   
 *  Thread Starter [Smith](https://wordpress.org/support/users/ikaspars/)
 * (@ikaspars)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/wordpress-mysql-error-on-phpmyadmin-256/#post-1938990)
 * Thanks, I fixed it.
 * I used a SQL compatibility mode – MYSQL323

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress mySQL error on phpMyAdmin 2.5.6’ is closed to new replies.

## Tags

 * [mysql-error](https://wordpress.org/support/topic-tag/mysql-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Smith](https://wordpress.org/support/users/ikaspars/)
 * Last activity: [15 years, 3 months ago](https://wordpress.org/support/topic/wordpress-mysql-error-on-phpmyadmin-256/#post-1938990)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics