Title: Errors importing SQL database for manual transfer
Last modified: August 31, 2016

---

# Errors importing SQL database for manual transfer

 *  [saltpeb16](https://wordpress.org/support/users/saltpeb16/)
 * (@saltpeb16)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/errors-importing-sql-database-for-manual-transfer/)
 * Hi,
    I am re-assembling a hacked site, in pieces. I have managed to login to 
   the MyPhp admin on the server that hosts the hacked site and managed to Export
   a SQL database of the site. No problems. I then have set up a dev site on my 
   own server in order to put the site back together on a clean install of WordPress.
   But when I try in import the SQL file I get the following error:
 * Error
 * SQL query:
 * —
    — Database: `sarpam_sarpam_wp` — — ——————————————————– — — Table structure
   for table `wp_commentmeta` — CREATE TABLE IF NOT EXISTS `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)
   ENGINE = MYISAM DEFAULT CHARSET = utf8;
 * MySQL said: Documentation
    #1075 – Incorrect table definition; there can be only
   one auto column and it must be defined as a key
 * I just need to clarify, will the process of exporting/importing the SQL DB give
   me a copy of pages and posts etc from the old site? I have a copy which I acquired
   via FTP of the content files from the site. I also can re-install the theme files.
   My main concern with the above process is to restore page and post content.
    
   Thank you for your assistance.

The topic ‘Errors importing SQL database for manual transfer’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [troubleshooting](https://wordpress.org/support/topic-tag/troubleshooting/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [saltpeb16](https://wordpress.org/support/users/saltpeb16/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/errors-importing-sql-database-for-manual-transfer/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics