Thanks, Gerald, for your response. From the documentation I thought I'd be in good shape. I've set up the test server with OTRS 3.1, stopped services and copied over my config files from the 3.0.11 server: /opt/otrs/Kernel/Config.pm /opt/otrs/Kernel/Config/GenericAgent.pm /opt/otrs/Kernel/Config/Files/ZZZAuto.pm
The database from 3.0.11 is restored to a database called otrs3, and although I could use any username I added a user to the otrs3 database with the same name and password as the production server and granted all privileges to otrs3. I've logged onto MySQL using the new credentials and made some table queries to make sure I can see the database properly with the credentials that match the restored Config.pm file. Obviously root works as well. When I ran the command cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs3 The script ran but yielded the following errors: ERROR 1005 (HY000) at line 225: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 226: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 227: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 229: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 230: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 234: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 235: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 237: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 238: Can't create table 'otrs3.#sql-e40_45' (errno: 150) ERROR 1005 (HY000) at line 239: Can't create table 'otrs3.#sql-e40_45' (errno: 150) MySQL documentation says this error (1005 with errno 150) results when a foreign key constraint is not correctly formed. I can see in the script that these line numbers are adding constraints, but I'm afraid I don't understand what's supposed to happen that didn't happen. Can you shed any light on what went awry with the FK constraint creations? Thanks much, Rob in Memphis
--------------------------------------------------------------------- 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
