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_idbigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
comment_idbigint( 20 ) unsigned NOT NULL default ‘0’,
meta_keyvarchar( 255 ) default NULL ,
meta_valuelongtext
) 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.