Blog Documentation Book a Demo

Database migration

martin28martin28 New
in Vanilla 2.0 - 2.8

Hi Team, just wondering if we have database migration tool. Just installed fresh vanilla forum 2.6 & I want to migrate data from vanilla 2.2 database. TIA

Comments

  • whu606whu606 MVP

    If you have installed it on the same server, then the steps are:

    back up your database and config.php file

    change the details in your 2.6 config.php file to point to your production database

    run yourforum.com/utility/update

    clear files from cache folder

    That should do it.

    If you have moved to a different server, you will need to export your DB using something like phpMyAdmin.

  • martin28martin28 New

    I'm working on it local first, so that's same server. There are tables that on the db2.6 which is not present on db2.2 (like GDN_AccessToken) and vice-versa. How about columnconflict on same table, Will the utility update take care of it?

  • martin28martin28 New

    I'm working on it local first, so that's same server. Thanks to utility/upgrade & clear cache, it works like charm. I'm good now, thanks @whu606

Sign In or Register to comment.