Page 1 of 1

How to migrate DB from TL 1.8.4 Windows to TL 1.9.2 Linux?

Posted: Tue Jun 28, 2011 3:03 pm
by jenny
I've been searching all over the web for an exact step by step "how to" migrate DB, both are running on MySql.

Is it possible to:
-Upgrade TL 1.8.4 Windows to TL 1.9.2 Windows,
-then export (mysqldump) database from Windows,
-to import it to TL 1.9.2 Linux?

If so, can anyone help me how to do this step by step, if there is anything that I should look at for, any scripts needed to be run before doing anything.

It would be much appreciated. Thank you.

Re: How to migrate DB from TL 1.8.4 Windows to TL 1.9.2 Linu

Posted: Tue Jun 28, 2011 6:10 pm
by fman
procedure you have proposed is OK.

Re: How to migrate DB from TL 1.8.4 Windows to TL 1.9.2 Linu

Posted: Wed Jun 29, 2011 8:22 am
by jenny
Is there no extra scripts to run? or anything that I needed to do first before exporting/importing?

I've been searching and the code for exporting DB in windows is:
mysqldump -u root -p testlink >d:\filename.sql

and to import to linux:
mysql -u root -p testlink <filename.sql

just wondering if that is right? I just need an experts point of view.

Much appreciated.

Re: How to migrate DB from TL 1.8.4 Windows to TL 1.9.2 Linu

Posted: Wed Jun 29, 2011 12:07 pm
by TurboPT
Yes, the syntax of the mysql commands is correct.

The only minor 'snag' that you might find, is if the database is not created by the script for the Linux side, then the database would need to be created first, and then load the script.
[this will be immediately be clear if the mysql command complains that database 'testlink' is not found]

Other than that, sounds like you're ready to roll!

Re: How to migrate DB from TL 1.8.4 Windows to TL 1.9.2 Linu

Posted: Wed Jun 29, 2011 2:34 pm
by jenny
Thank you! :D I got it working.

It's just that I'm an intern at the moment and I don't want to make a mess with my company's TestLink. :oops: