Moving Site to New Domain and Server….

  • Ok, I have WordPress set up on a new site, and new server location, but now what I want to do is suck in the database from the old location, I have read some stuff on it and have tried it but keep having errors occur while trying to do it, is there anywhere that I can get good rock solid instructions on how to do this??
    Even better, why is it that WordPress can import items from other blog programs but it can’t import from one WordPress blog to another, something that should be added I think, to make these types of moves far easier.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter liftnw8sblog

    (@liftnw8sblog)

    SQL query:

    #
    # Table structure of 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 =23DEFAULT CHARSET = latin1;

    MySQL said: Documentation
    #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 ‘DEFAULT CHARSET=latin1’ at line 10

    Above is the information that I am getting in reference to the type of error while trying to import the DB, not sure if that helps but figured it might.

    What did you use to make the db backup? WordPress database backup plugin?

    You mentioned you read some stuff. What stuff? Was it at Moving_WordPress?

    Best tutorial there is: https://tamba2.org.uk/wordpress/move/

    Thread Starter liftnw8sblog

    (@liftnw8sblog)

    I read the Moving WordPress stuff and the Tamba2 stuff, as for the WordPress database backup, I used the plugin that comes with wordpress to do that.

    Thread Starter liftnw8sblog

    (@liftnw8sblog)

    so anyone, any suggestions, I am next going to try just using portions of the old DB, rather than the whole thing, i.e. just taking my posts and the like only.

    Have a look at: https://www.technosailor.com/wordpress-to-wordpress-import/

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Moving Site to New Domain and Server….’ is closed to new replies.