Error, can’t move sql database into new host (same domain)
-
Hello – I’ve been trying to move my wordpress blog into a new host, but same domain name. I am getting the following error:
Error
SQL query:TABLE structure FOR TABLE
wp_categories—
CREATE TABLEwp_categories(cat_IDbigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_namevarchar( 55 ) NOT NULL default ”,
category_nicenamevarchar( 200 ) NOT NULL default ”,
category_descriptionlongtext NOT NULL ,
category_parentbigint( 20 ) NOT NULL default ‘0’,
category_countbigint( 20 ) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID) ,
KEYcategory_nicename(category_nicename)
) ENGINE = MYISAM AUTO_INCREMENT =17;MySQL said:
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Table structure for table
wp_categoriesCREATE TABLE
wp_categories(
`’ at line 1when I try and copy the contents of the file criscol2_wrdp1 into the sql window of phpmyadmin.
I have read many posts on here about how to move the wordpress blog database, and several errors encountered and what to do. I have gone in and taken out the charset=latin one as was instructed to many people. I also downgraded my wordpress blog from 2.0 (whatever the latest one is) to a 1.5 as someone was instructed that maybe they were having errors because their file backup was an older version than the blog (I am sure that was the case with me) That did not help either.
I have had a support ticket in at my new host since Sunday to transfer my site, but nothing has yet happened. I would like to do myself if possible to go faster but have had no luck.
I know I can manually import all my blog entries from Qumana [thank God I have that at least!] but that will take a long time and will still not give me back all my comments. I also had a lot of formatting to several pages outside of comments.
Any additional help will be greatly appreciated!
The topic ‘Error, can’t move sql database into new host (same domain)’ is closed to new replies.