Windows to Linux DB issue

Openfire Openfire Support
1

I am moving all of my servers from a Windows based system to a Linux based system. I have moved everything but Wildfire with no major issues. I installed Wildfire and exported the database from the old system and imported it into the new system. Both systems are running the same versions of MySQL and Wildfire, just Linux now instead of Windows. When I try to connect to the database it says it isn’'t formatted in a form that Wildfire can read. I can delete the database and let Wildfire create it again and it works fine, but of course all of the info is gone from the orginial databse. I did this to just be sure that the database privalages were all correct. So I tried it again, importing the old database, and I get the same error. Not to be to discouraged I then used the Linux server and connected to the Windows database and everything worked and is working fine. So what do I need to do to move the database from the old system to the new system?

Geek

2

Shot in the dark:

  1. Dump the old database to a file (mysqldump)

  2. Let the new server create a clean Wildfire database structure

  3. Stop Wildfire

  4. Edit the mysql dump file to remove all CREATE statements and only leave the INSERT statements.

  5. Run the modified dump script on the new mysql instance

  6. Cross your fingers

  7. Start Wildfire

3

if the first example doesn’‘t work, try this. It’'s a little labor intensive though! If you are not a database admin, you might want to find one.

in the old DB, create a table using the values from the tables that you need (username, jid’'s, etc)

insert into all of the data from the multiple tables into the one new table.

db_dump the table out and put it on the Linux based server.

after creating the wildfire db, import the table into that database

then do insert into statements to pull the data into the different tables.

Last thing you have to do is update the counters in jiveid to reflect the largest fk value.

As I said it is labor intensive, and best done by a dbadmin, as they know all the tricks.

Jeff

4

Finally got time to get back around to this. I ended up upgrading to the 3.0.1 on both servers then using the user import/export plugin in just exported from one server to the other. It just said the admin user already existed and asked what I wanted to do. So far it appears to be working as expected. I will find out tomorrow when all of my users start to call me.

ItsNewToYou