upgrading MySQL server

  • hey does anyone know if tables/data from old versions of WP (think 1.5.2) currently running on MySQL 3.23.51 will be importable into a newer MySQL server? will there be any compatibility issues?

    (i am trying to upgrade to the newest version of WP and it means a MySQL server move.)

    i don’t know anything about this kind of thing and my host has expressed concerns that the data might not be importable. does anyone know? experiences?

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

    (@tankgreen)

    okay, apparently this does not work. my host said it did not import cleanly.

    can anyone help? how can i get the info (the posts are all i care about) out and back up again?

    My host offers phpMyAdmin so that when I export the MySQL database I can specify SQL compatibility mode of MYSQL40. Then when doing the import you can specify again, SQL compatible mode of MYSQL40.

    Thread Starter tankgreen

    (@tankgreen)

    okay… i still haven’t figured out how to get my old posts / data out from the one DB and into a new one…

    can anyone help?

    the old posts are located here:

    WP version: 1.5.2
    MySQL version: 3.23.51
    phpMyAdmin: 2.2.6

    and i need them to get onto a new server with a new installation of WP. that server has:

    MySQL client version: 5.0.51b
    phpMyAdmin: 2.11.9.2

    any ideas / step-by-step help would be GREATLY appreciated. i just don’t want to lose 5 years worth of journal entries. :/

    1. Follow Backing_Up_Your_Database and change SQL compatibility mode to MYSQL40.

    2. Follow Restoring_Your_Database_From_Backup and change SQL compatibility mode to MYSQL40.

    Thread Starter tankgreen

    (@tankgreen)

    thanks for your post michael, but the problem is that i have a different version of phpMyAdmin on the old server that i am trying to get the info off. the instructions for backing up my DB don’t completely apply since i don’t have some of the options available to me.

    the only options i have are:

    View dump (schema) of database:
    Structure only
    Structure and data
    Data only

    and i would assume at that point i would choose ‘structure and data’, yes?

    Then I have:

    Add ‘drop table’
    Complete inserts
    Extended inserts
    Enclose table and field names with backquotes
    Save as file ( “zipped” “gzipped” )

    and here i would choose ‘Add ‘drop table”, ‘Enclose table and field names with backquotes’ and then save as a zipped. right?

    that seems to be the closest to the instructions given. is that correct? will the back up still work when i can’t add the auto increment?

    thanks again for your help.

    The ‘add auto increment ‘backs up the auto increment value, but if your version of phpMyAdmin doesn’t offer the ‘add auto increment’ in the export then you have no choice but to proceed without that.

    I believe that the auto increment values, where used, will be reset when you import to the new database.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘upgrading MySQL server’ is closed to new replies.