[rt-users] DB import

[Helmuth Ramirez]

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: 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> 

	_______________________________________________
	http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

	Community help: http://wiki.bestpractical.com
	Commercial support: sales at bestpractical.com


	Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
	Buy a copy at http://rtbook.bestpractical.com


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