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:rt-users-
[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
_______________________________________________
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
