Title: Error, can’t move sql database into new host (same domain)
Last modified: August 18, 2016

---

# Error, can’t move sql database into new host (same domain)

 *  Resolved [criscollrj](https://wordpress.org/support/users/criscollrj/)
 * (@criscollrj)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/error-cant-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 TABLE `wp_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` ) , KEY `category_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 1
 * when 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!

Viewing 1 replies (of 1 total)

 *  Thread Starter [criscollrj](https://wordpress.org/support/users/criscollrj/)
 * (@criscollrj)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/error-cant-move-sql-database-into-new-host-same-domain/#post-509582)
 * SOLVED! :happy: problem solved – I followed this tonight (with little hope) and
   it worked! [http://www.downloadsquad.com/2006/10/16/how-to-move-a-wordpress-blog-to-a-new-host-dls-recipe/](http://www.downloadsquad.com/2006/10/16/how-to-move-a-wordpress-blog-to-a-new-host-dls-recipe/)
   not quite sure why, but it worked.
 * Still need my pics, old html pages, etc., transferred but with my blog up I’m
   back in business!
 * dori

Viewing 1 replies (of 1 total)

The topic ‘Error, can’t move sql database into new host (same domain)’ is closed
to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 1 participant
 * Last reply from: [criscollrj](https://wordpress.org/support/users/criscollrj/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/error-cant-move-sql-database-into-new-host-same-domain/#post-509582)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics