• 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.