Thanks to everyone for directing me to the import tool. I’m newbie so I apologize for the follow-up question, but I’m stuck.
I am having a permissions problem when running rt-2.0-to-dumpfile.
./rt-2.0-to-dumpfile: bad interpreter: Permission denied
I am running the script as root and have also tried to chown the file to the owner of the database, su to that user, but get the same error. Any ideas? Thanks.-----Original Message-----
From: Cassily, Ryan
Sent: Tuesday, May 27, 2003 6:07 PM
To: Rt-Users@Lists. Fsck. Com (E-mail)
Subject: [rt-users] import from rt2
I am trying to import the database from an rt2 machine to an rt3 machine. I used the following commands:
./mysqldump -Fl --opt -u root rt2 > rt2-backup-file.sql
./mysql -u root rt3 < rt2-backup-file.sql
Now when I logon to the rt3 website as root, I do not get any priviledged options and cannot even change my password. I can log into rt3 as a regular user also, but there are no queues, etc. All the tables seemed to have imported successfully when I do a shell>mysqlshow rt3. Thanks in advance for your help.
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm