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