from 2.2.3 to a new 3.0.2

[Ni-Cola]

I'm trying to subsitute my old slackware 2.2.3 OTRS+FAQ server to a new Debian 5.0.6 with last release of OTRS on another computer.

Which is the correct procedure?

I would conserve only the historical database, I'll make the configuration ex-novo

Best regards,

TIA

[Wolfgangf]

Well, the UPGRADE document from the source tree explains what to do

[Ni-Cola]

Thanks to the quick answer.

I red that,
but when I did it I already have tried backup/restore procedure that fails.

I asked the question because I don't know the correct procedure to backup database, that UPGRADING doesn't explain at all.
The db is MYSQL.
Can I use mysqldump for example?

TIA

[Wolfgangf]

sure! mysqldump otrs > /somepath/somefile
then run the UPGRADE procedure and if anything fails restore

another way is to run the <OTRSHOME>/bin/backup.pl before upgrading, which saves everything
also it would be a good idea to my mind to export the config via the Admin area

[Ni-Cola]

I already created new db ver 3.
Btw I'm not so confident in MySQL so I dumped this one also and dropped it:

mysqladmin drop otrs -p

So in the old server:

mysqldump --opt --database otrs > /backups/otrs2_dump_db.sql -u root -p

(--database is for inserting instructions to create the db)

In the new I wil do:

mysql < otrs -u root -p


Then I will run the UPGRADE procedure.

Is that correct?


TIA

[Ni-Cola]

In the new I wil do:

mysql < otrs -u root -p


Then I will run the UPGRADE procedure.

I had to write:

mysql < /pathto/backup/otrs2_dump_db.sql -u root -p

[Wolfgangf]

Is that correct?

actually: no

backup is correct
then UPGRADE
no need to restore if everything goes well

[Ni-Cola]

Sorry if I wasn't so clear.

I'm passing from a physical server to another physical server!

So how I pass the db from the old one to the newest?

TIA

[Wolfgangf]

in this case i would do it as follows
- <OTRS_HOME>/scripts/backup.pl
bring this file to new machine
- <OTRS_HOME>/scripts/restore.pl

(run both commands with -h to get parameter options for outfile, ....)

after restore, you will endup with an "old" OTRS on the new machine
run the fully UPGRADE procedure and you will end up with new OTRS and data from old system

Hope this helps

[Ni-Cola]

In the new one in which otrs database was already present I'm doing

mysqladmin -u root -p drop otrs
mysqladmin -u root -p create otrs

/opt/otrs/scripts/restore.pl -b /pathto/date/ -d /opt/otrs

I'm searching to restore db only.

Then upgrade