[rt-users] DB import

Tom Smith aliase573201 at mac.com
Thu Aug 28 10:26:52 EDT 2008


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://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/28398a01/attachment.htm>


More information about the rt-users mailing list