"--default-character-set=binary" on mysqldump is required if you migrate RT 3.6.x from mysql4.1+ to another 4.1+ (mysql 4.0 has no such option). Reasons why this is required are described in etc/upgrade/schema.mysql-4.0-4.1.pl (RT 3.8+).
Once you'll correctly migrate to 3.8.1+ there would be no need in such things on backups and later migrations (I hope). On Thu, Aug 28, 2008 at 5:54 PM, Helmuth Ramirez <[EMAIL PROTECTED]> wrote: > Dumping it: > > > > mysqldump --user=rt_user –-password=<password> --opt --skip-lock-tables > > --single-transaction --default-character-set=binary --databases rt3 > > /home/mysql/rt.sql > > > > Per http://wiki.bestpractical.com/view/MigrateToNewServer > > > > Importing it > > mysql -u root -p YOURDBNAME < PATHTOYOURDB.sql > > > > Then you follow the upgrade instructions (important), and finally run the > 4.0 -> 4.1 MySQL scripts…yes..even though you're not running 4.0 > > > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick Price > Sent: Thursday, August 28, 2008 5:11 AM > To: [email protected] > Subject: [rt-users] DB import > > > > Hello > > I am running rt-3.6.3 on a fedora 7 server with mysql 5.0.45-6.fc7 > > I have a new setup on a new server fedora 9 and rt-3.8.1 also with mysql > 5.0.51a-1.fc9.i386 > > How can i import the database from the old server to the new server > keeping all the data intact > > many thanks > > Nick Price > > > > ________________________________ > > Get ideas on sharing photos from people like you. Find new ways to share. > Get Ideas Here! > > _______________________________________________ > 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 > -- Best regards, Ruslan. _______________________________________________ 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
