Import database from 2.4.4 to 3.1.1

[DBeckers]

Hi everyone,
I have some kind of issue whit MySQL on Otrs 3.1.1 (CentOs) . I want to import a Otrs Database dump file from otrs 2.4.4. with command:
$ mysql -u user -p mydb < dump.sql
That Just worked.. but I got to rebuild the database with some kind of command but I don’t know how. Can somebody help me?

Thanks in Advanced,
Duncan Beckers.

[std]

Hello Duncan ,

As I understood , what you need is to restore your DB .

Here you r the steps that I followed for backup & restore the MY SQL ( OTRS ) DB :

1.Backup :
i. Go to Run > cmd .
ii. Changing the path to : c:/program files (x86)/otrs/mysql/bin .
iii. Enter this command :
mysqldump –uroot otrs > sql.otrs
copy otrs.sql c:\
2. Restore :

i. Go to Run > cmd .
ii. Changing the path to : c:/program files (x86)/otrs/mysql/bin .
iii. Copy otrs.sql to c:/program files (x86)/otrs/mysql/bin .
iv. Enter this command :
Mysql –uroot otrs < otrs.sql .

I hope that i help you in Achiving your needs ,

Regards ,

L

[DBeckers]

Dear L,

It is a Database from otrs 2.4.4 to 3.1.1 so I’ve got to import a 2.4.4 database in to 3.1.1 (on Linux CentOS)
It is already imported but I need to rebuild it and I don’t know how…


with kind regards,
Duncan Beckers

[jojo]

read the UPGRADING file

you also need first to do the upgrading to 3.0

[DBeckers]

but I'f got only a dump file from 2.4.4, is it possible to import it in 3.1.1 and rebuilt it or do i need to config a 2.4.4. and update ?
(I am a noob I know )
T.I.A.
D.B.

[jojo]

you will also need the Config files.

as 2.4 and 3.1 are different the database needs to be migrated