Importing from old blog to new blog (on new server)

  • owengot

    (@owengot)


    18 years, 3 months ago

    Okay I went through the backup step by step guide for the wordpress databases, which went without a hitch, then I tried to import the database to my new server (through php myadmin) and I got an error straight away:

    SQL query:

    CREATE TABLE bl_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) COLLATE latin1_general_ci NOT NULL default ”,
    category_nicename varchar( 200 ) COLLATE latin1_general_ci NOT NULL default ”,
    category_description longtext COLLATE latin1_general_ci 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 DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci

    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 ‘collate latin1_general_ci NOT NULL default ”, `category_nice

    I don’t know where I went wrong, so I really need some help here.

    I also tried to export my posts as an xml file and import the file into the new blog, a success message came up but my posts/categories aren’t there at all.

    Please help! Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • moshu

    (@moshu)

    18 years, 3 months ago

    Try this:
    http://wordpress.org/support/topic/41336?replies=4#post-232168

    Thread Starter owengot

    (@owengot)

    18 years, 3 months ago

    I replaced every “collate latin1_general” in the file, like Podz said, and now I get a different error message:

    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 ‘<?xml version=”1.0″ encoding=”utf-8″ ?>
    <!–
    –
    – phpMyAdmin XML

    Is this better/worse? Thanks for your help.

    Thread Starter owengot

    (@owengot)

    18 years, 3 months ago

    Otherwise does anyone know about importing xml files ?

    Thread Starter owengot

    (@owengot)

    18 years, 3 months ago

    I still can’t find a solution, and I really need to import my old posts, can someone explain how to import xml feeds or something? thanks

    remoinsystem

    (@remoinsystem)

    18 years ago

    Hi,

    When i import this table into PHPMYADMIN in the server, i am facing the following error message. But i can able to import it in my Localhost PHPMYADMIN. What’s the problem???

    phpMyAdmin SQL Dump
    — version 2.7.0-pl1
    — http://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Apr 24, 2006 at 06:55 PM
    — Server version: 5.0.18
    — PHP Version: 4.4.1-pl1
    —
    — Database: portal
    —
    — ——————————————————–
    —
    — Table structure for table employees
    —
    CREATE TABLE employees (

    id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
    first varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
    last varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
    address varchar( 225 ) COLLATE latin1_general_ci NOT NULL ,
    position varchar( 50 ) COLLATE latin1_general_ci NOT NULL ,
    PRIMARY KEY ( id )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =3;

    MySQL said:

    #1064 – You have an error in your SQL syntax near ‘collate latin1_general_ci NOT NULL,
    last varchar(20) collate latin1_general_’ at line 6

    This is my error, please anyone could tell me the solution.

    Thanks

    Mark (podz)

    (@podz)

    18 years ago

    DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci

    Delete that from each place in the SQL
    There will be at least 9 locations (at the start of each table where it is defined)

    …… this is a WordPress issue?………

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Importing from old blog to new blog (on new server)’ is closed to new replies.