Merging Databases

  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Merging Databases

« posted: Aug 20, 2015, 10:59 PM »
Ok, does any1 know how to merge databases? If so can you explain what to do?

Reason, I am switching from extdb to extdb2 and v1.2 but I don't want my players to lose everything.

Please Post walkthrough link or walkthrough.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Merging Databases

« Reply #1 posted: Aug 21, 2015, 02:17 AM »
You don't need to merge, should work 100%
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Merging Databases

« Reply #2 posted: Aug 21, 2015, 03:21 AM »
just swap out the 2.03 db with 2.04? and all will work? obviously with all the other files.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline CREAMPIE
  • Armaholic
  • Veteran
  • ******
  • Posts: 1077
  • ^_^;;

Re: Merging Databases

« Reply #3 posted: Aug 21, 2015, 06:00 AM »
I did the following ...

Export MySQL db to sql file
Create new database using 2.04 schema
Make custom sql changes
Update the exported sql file with any issues ( case sensitive table names and remove drop / create table statements )
Use a tool like navicat to import the sql into the new database
Make sure all dlls, ini and extDB connection configs are updated.
Make sure your main_config.sqf is updated

Enjoy the benefits of 1.2 !


Edit: you may need to run that jpgtopaa.sql which changes all your saved texture names to .paa as they were all converted in 1.2

- from the grassy knoll -
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Merging Databases

« Reply #4 posted: Aug 21, 2015, 03:14 PM »
Never used Navicat, I use wampserver and phpmyadmin.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline LouD
  • Silent but deadly ;)
  • Moderator
  • Veteran
  • ******
  • Posts: 1415

Re: Merging Databases

« Reply #5 posted: Aug 22, 2015, 10:47 AM »
Why? Just backup your DB. Upgrade to 2.04, run the extra sql file for jpg > paa and youre done.
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Merging Databases

« Reply #6 posted: Aug 22, 2015, 06:07 PM »
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!