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 tablewp_commentmeta
—
CREATE TABLE IF NOT EXISTSwp_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 keyI 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.