I have now updated the schema/acl/db from 3.0.10 to 3.6. The prior mysql db was running MyISAM. Updating the schema using the provided upgrade scripts did not work properly as a result.
I did a mysqldump /usr/bin/mysqldump --user=rt_user –-password=rt_pass --add-drop-table --opt --skip-lock-tables --single-transaction --default-character-set=binary --databases rt3 > /home/rt3/rt.sql dropped the database and changed all the server types from MyISam to InnoDB with a text editor and saved it. If your database is very large, the dump file may be too large to fit in your text editor. If so, you can use a batch editor like sed to make the changes. I added SET AUTOCOMMIT = 0; to the beginning of the dump file, and add the COMMIT; command to the end. "By default, autocommit is on, meaning that each and every insert command in the dump file will be treated as a separate transaction and written to disk before the next one is started. If you don't add these commands, reloading a large database into InnoDB can take many hours." I edited the /etc/my.cnf file to read default-storage-engine=innodb innodb_data_home_dir = /ibdata1 restarted mysqld then I made sure the database was gone and I imported the sql file mysql --user=rt_ser --password=rt_pass < /home/rt3/rt.sql This took longer then a normal import because of the way innodb writes the db files. by looking at ls -l /var/lib/mysl during the import I was able to determine the data was importing, I had about a 600MB attachment table, and could see it progress. Once the DB was imported, I restarted msqld for good measure. The first time it may take a while to initialize the innodb. Now I can login to RT. I'm having an issue still with any email coming in to the system not being received by RT. Sendmail is giving a "user unknown" for every message in its log files. I've tried everything I can find in the wiki. Any suggestions? _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
