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
