[SOLVED]Migrate database from v2.4.6 to 3.0.5

[nlundell]

Hi

We have OTRS 2.4.6 installed on Win2003 server and I have now installed OTRS 3.0.5 on another Win2003 server and want to

1) Restore the database that I've made a backup of from v2.4.6 using MySQL Administrator
2) Migrate the database to v 3.0.5

but I'm missing the necessary steps on how to do this.
I've already tried to just try making a restore inside MySQL on the new server but that one fails, also just tried to copy the whole \\MySQL\Data folder to the new server but that also fails.

Any advice/help is much appriciated.

Thanks and regards
nlundell

[crythias]

There is a backup and restore script in OTRS, but you will need to upgrade the restore.

mysqldump -uroot otrs > otrs.sql makes a database back up.

However, it may fail to restore because the schema has changed from 2.4.6 to 3.0.5.

Best practice is to be at the same revision level to backup/restore, then apply the upgrade.

[nlundell]

Hi

Now I'm confused, even though if I restore to the same level I must dump the database at 2.4.6 then uninstall OTRS and install the new version OTRS 3.0.5 and then import the database.
Or what is it that I'm not understanding ?

[crythias]

I apologize that I wasn't clear.

1) run the backup script on 2.4.6 source and copy result to destination
2) install 2.4.x on destination
3) run the restore script on destination
4) install 3.0.x on destination and upgrade

OR
1) run the backup script on 2.4.6 source
2) install 3.0.x on source and upgrade
3) run the backup script on source and copy result to destination
4) install 3.0.x on destination
5) run the restore script on destination

[nlundell]

Hi
Ok, just so that I'm clear on certain things. When you say 'install 3.0.x on destination and upgrade', do you mean DBUpdate ?

And just a dumb question but can I run mysqldump at the same time as the database is still running and people logged onto the OTRS system and working in it ?

[crythias]

can I run mysqldump at the same time as the database is still running and people logged onto the OTRS system and working in it ?

Yes, with the standard caveat that it will only dump currently committed transactions. If someone is editing a ticket, and they click submit at the same time as a dump, that ticket may not have its change reflected in the dump. The backup will be usable for restore purposes.

I'm saying that you *can* run mysqldump at the same time. It's a good idea to back it up when it's least likely to be used, but that's your call. Nothing will break (the data won't error-out on restore), but it's all about your tolerance of what you didn't catch when backing up. That's not unique to MySQL, though.

When you say 'install 3.0.x on destination and upgrade', do you mean DBUpdate ?

http://doc.otrs.org/3.0/en/html/upgrade ... aller.html
I think the answer is "Yes".
http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=351
but also read the UPGRADING file http://source.otrs.org/viewvc.cgi/otrs/ ... iew=markup

[nlundell]

Hi
Ok I will dump the database when no one uses the system and follow the instructions at http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=351. Let you know the outcome tomorrow or the next day.

Thanks for the help so far.

[nlundell]

Hi
Welll, tried to dump the database and even that failed, error message

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump - uroot otrs > otrs_dump.sql' at line 1

My MySQL version is 5.0.67, is it to old to run the mysqldump command or what is the error about ?

[crythias]

mysqldump isn't run from within mysql, it's run from the shell/command prompt.

[nlundell]

Hi

I didn't run the command from within mysql. I've started CMD and went to C:\Program Files\OTRS\mysql\bin, wrote mysql and that took me to the shell/ command prompt, I hope.
Or was this incorrect ?

[crythias]

Yes. When you typed the word mysql, you are in mysql. If you are not familiar with these tasks, it is recommended that you use the scripts provided in otrs. Read the docs for backup and restore procedures.