[SOLVED] Some advice needed please on migration of TL

[Rab]

Hello all

I have searched the forums and online already to see if anyone has tried similar, but I think because this is rather new there isnt much about it online. I am trying to get some advice on migrating my testlink from my laptop (temp test solution) to a more meaty machine.

My laptop is running windows 7 with testlink 1.9.8 Lobizon. I would like to move to the new Bitnami virtual machine running on Linux. I have installed the VM fine, but I am not sure about porting my Db across. Does anyone have any hints and tips for this?

What I have done so far is use Windows MySQL server management interface to make a *.sql dump of my db. I then moved this over to the VM. I have installed the Webmin function and activated MySQL control on it. I then executed the sql file to recreate my Db there. The Bitnami stack uses a Db called bitnami_testlink and mine is called testlink. So I dropped my db and the bitnami db, modified my sql script and re-ran it so it created my migrated Db called "bitnami_testlink". However, testlink is expecting a 1.9.9 Db and I have a 1.9.8 Db, so when I run up testlink interface it says my Db is wrong and has a list of other errors.

So my question: Should I continue on my course and try manually upgrade my db to 1.9.9? Will my old 1.9.8 Db be missing things the new Bitnami stack Db requires?. OR is there a better way to do this?

Many thanks
Rab

P.S. The errors I get on testlink web login page are:
==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query() called at [/opt/bitnami/apps/testlink/htdocs/lib/functions/database.class.php:555]
#1 database->fetchFirstRow() called at [/opt/bitnami/apps/testlink/htdocs/lib/functions/tlUser.class.php:274]
#2 tlUser->readFromDB() called at [/opt/bitnami/apps/testlink/htdocs/lib/functions/configCheck.php:228]
#3 checkForAdminDefaultPwd() called at [/opt/bitnami/apps/testlink/htdocs/lib/functions/configCheck.php:276]
#4 getSecurityNotes() called at [/opt/bitnami/apps/testlink/htdocs/login.php:131]
#5 init_gui() called at [/opt/bitnami/apps/testlink/htdocs/login.php:30]

==============================================================================

[fman]

make thing simpler

1. backup your 1.9.8 DB
2. create ON YOUR LAPTOP a new DB
3. restore the backup done on (1)
4. go to mantis and give a look to ALL TICKET with Product Version 1.9.8, that can be related to your problem
(this has already reported, there is a column missing on your 1.9.8 DB)
you can compare the sql scripts for 1.9.8 and 1.9.9 that creates a FRESH DB to find differences
5. install 1.9.9 on your laptop
6. make things work there
7. now with your DB UPDGRADED correctly to 1.9.9 and running, then is time to backup it and go to do restore on Bitnami

[Rab]

thanks, I have got it working very nicely now. It runs SOOO much faster on a server using the Bitnami VM linux distro in comparison to my WinXP laptop