Thanks! This is the first time that I've had to upgrade the DB before.
All of the other updates just applied after using the RPM.
-Jeff
Nils Breunese (Lemonbit) wrote:
Jeff Shepherd wrote:
What script is that you're supposed to run in /opt/otrs/scripts?
Read the UPGRADING file. When coming from OTRS 2.1.x you need to use
the DBUpdate-to-2.2.mysql.sql script to upgrade the database to the
2.2.x schema. If you're upgrading from 2.0.x, you'll first need to use
the DBUpdate-to-2.1.mysql.sql script and then the
DBUpdate-to-2.2.mysql.sql script.
You can apply an SQL update script like this (as mentioned in the
UPGRADING file):
# cat /opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql | mysql -p -f -u
<db-user> <otrs-db-name>
(Or without cat:
# mysql -p -f -u <db-user> <otrs-db-name> <
/opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql
if that's your thing.)
Don't forget to replace <db-user> with an actual database user that
has access to your OTRS database (probably otrs, root or admin or
something), and <otrs-db-name> with the name of your OTRS database
(probably otrs).
Nils Breunese.
------------------------------------------------------------------------
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/