No announcement yet.

Moving the database from Mysql 5.0.81 to 5.1.

  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving the database from Mysql 5.0.81 to 5.1.

    Is there anything I need to do, or run, to prepare the database for import into the Mysql 5.1 engine?

    Thanks all!

  • #2
    ussually i'm doing it like this:

    0. stop forum
    1. mysqldump database_name > file.sql
    2. install mysql 5.1
    3. mysql database_name < file.sql

    In plain translation means:

    0. stop the forums so no new updates to the database will be done
    1. make a backup of the database
    2. install mysql 5.1, stop 5.0, start 5.1
    3. restore the backup of the database in 5.1 format

    As i know you can also just copy&paste the DB files from 5.0 to 5.1... but i don't recommand it.


    • #3
      Thanks for the help, yea that's what I did on a test platform, seemed to import ok, but the VB forum wouldn't load (something about a long key name), so I had to switch on "Force sql mode" in the config file, which seemed to work.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.