I won't be able to answer that honestly :) we just moved up to MySQL 5. I did
however have issues with my backups (attachments) until I saw that note in the
wiki.
________________________________
From: Tom Smith
To: Helmuth Ramirez
Cc: RT Users
Sent: Thu Aug 28 09:26:52 2008
Subject: Re: [rt-users] DB import
On MySQL 5, I used this command: mysqldump --add-drop-table -u rt_user -p rt3 >
rt3.sql .
The conversion seemed to go fine and I haven't noticed any problems.
By not using the command listed below, is there a chance that something didn't
make it across in my migration?
On Aug 28, 2008, at 6:54 AM, Helmuth Ramirez 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://www.windowslive.com/explore/photogallery/posts?ocid=TXT_TAGLM_WL_Photo_Gallery_082008>
_______________________________________________
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
_______________________________________________
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
