restoring a backup to a new OTRS install

A couple of weeks ago, my OTRS 2.0.4 installation crashed, and became completely unrecoverable. Luckily I had a backup from 3 days prior to it. It is a mysqldump. I was wondering if it was possible to restore this into mysql and then upgrade the database to 2.2.5 spec, do another mysql dump and restore to the new 2.2.5 install. If anyone can help me, can you give me the commands I will need to do? I am not very good at mysql. BTW - the new install is on a totally different server. I'm not sure if they are using the same name for the databases though. Andrew Meyer Unix Systems Administrator 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139

Andrew Meyer wrote:
A couple of weeks ago, my OTRS 2.0.4 installation crashed, and became completely unrecoverable. Luckily I had a backup from 3 days prior to it. It is a mysqldump. I was wondering if it was possible to restore this into mysql and then upgrade the database to 2.2.5 spec, do another mysql dump and restore to the new 2.2.5 install.
If anyone can help me, can you give me the commands I will need to do? I am not very good at mysql.
It's all right in the MySQL docs: http://dev.mysql.com/doc/en/mysqldump.html Nils Breunese.
participants (2)
-
Andrew Meyer
-
Nils Breunese (Lemonbit)