WordPress.org

Ready to get started?Download WordPress

Forums

WP 2.1.3 to WP 2.5. Problem to migrate database (6 posts)

  1. ubie79
    Member
    Posted 6 years ago #

    Actually i have a WP 2.1.3. The reaseon why i didnt upgrade is waiting, stable version (2.5).

    When i try to upgrade to 2.5, a lot of problem occurs, especially on database side.

    Tired to resolve the problem (for 2 weeks based on internet guide), i try the second option. Reinstall 2.1.3.

    But failed.

    So, i decide to copy my sql database, and import post and comments into new installed WP 2.5.

    The question is

    1. Which table should i save? I try to save the original wp- table (wp_comments , wp_links ,wp_options , wp_postmeta ,wp_posts , wp_terms ,wp_term_relationships ,wp_term_taxonomy ,wp_usermeta ,
    wp_users) , but it is huge. Around 30 MB. Any guide to make this sql file smaller.

    2. Then, i got a new idea. Converting sql into xml. But 2.5 accept WXR file. Anyone can help me? Or, anyone knows, what should i change in sql database if i want to migrate from 2.1.3 to 2.5?

  2. moshu
    Member
    Posted 6 years ago #

    a) If you don't have a database backup made prior to upgrade, you can NOT go back to 2.1.3.
    b) the database tables you named above are post-2.1.3 (i.e. those tables were introduced in 2.3!) so it will not work with 2.1.x WP files.
    If you have run the upgrade script (and no backup has been made) there is no way to roll back. You need to figure out how to make 2.5 to work.
    c) How many posts did you have before trying the upgrade? The 30 MB is extremely huge for an average blog...

  3. ubie79
    Member
    Posted 6 years ago #

    a) i've backup all database in sql, but only the original wp database (wp-comments, etc etc). Thats mean the only chice i have is convert to xml... But the strcuture is different...

    b) Hummm, Gosh, only XML version will work

    c) Around 1500 post with 10000++ comments, starting 2002... it is exactly 30.4 MB.

    Anybody can figure out what should i do, i mean the best solution. I've try almost everything, from SQL migration, database copy, sql transfer, and lastly is XML.

  4. moshu
    Member
    Posted 6 years ago #

    There is no such thing that "migrating" database - at least I can't figure out what that means.

    If you have a backup copy of the database made BEFORE the upgrade - that should NOT have tables like terms, term_taxonomy etc.
    Also, if you really have a database of 2.3.1 then just follow the instructions for restoring a database:
    1. re-upload the 2.3.1 files
    2. import the .sql file into the database

    (I backed up a database on the weekend with 17,000 posts and it is just above 20 MB...)

    If your host's settings won;t let you import such a big DB, try to use this script:
    http://www.ozerov.de/bigdump.php

  5. ubie79
    Member
    Posted 6 years ago #

    Migrating means, you migrate the database from one wordpress to the other.

    I've try to copy old database excluding plugins uses, into a new database, as moshu said (after reinstall 2.3.1).

    But an errors (i thought) occur when i try to access wp-admin.

    There doesn't seem to be a wp-config.php file. I need this before we can get started. Need more help? We got it. You can create a wp-config.php file through a web interface, but this doesn't work for all server setups. The safest way is to manually create the file.

    I dont know what happen, because, after reinstall 2.3.1, my blog smoothly run.

    After, paste the sql file (via bigdump), above error occur.

    Anyone know ho to resolve it?

    Or, if i want to transfer all comments and post, i just copy, the wp_comments and wp_posts.

    I dont care anymore about plugins and theme. I just want to save my wp data. Please help me...

  6. moshu
    Member
    Posted 6 years ago #

    Usually, you can NOT selectively copy over DB tables. Posts are in categories, so you need those tables, too, and the relation between posts and categories is in the post2cat table... furthermore all your settings are in the wp-options table - basically, you need all the tables.

    A backup of the database means ALL the wp_ tables.

Topic Closed

This topic has been closed to new replies.

About this Topic