[rt-users] DB import

[Helmuth Ramirez]

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: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Nick
Price
Sent: Thursday, August 28, 2008 5:11 AM
To: rt-users at lists.bestpractical.com
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> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080828/70f41d09/attachment.htm>