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_ID
bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name
varchar( 55 ) NOT NULL default ”,
category_nicename
varchar( 200 ) NOT NULL default ”,
category_description
longtext NOT NULL ,
category_parent
bigint( 20 ) NOT NULL default ‘0’,
category_count
bigint( 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_categories
CREATE 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.