[rt-users] Help moving DB to a new server.

[steverieger]

If its an inodb then mysqldump -u root -p name_of_db >> name_of file.sql

If its isam, I would try shutting down the mysql server and moving thee
data, but it probably wont work.



On 3/11/05 4:57 PM, "Oscar Gonzalez" <oscarg at webreachinc.com> wrote:

> Hello, we have RT running (v. 3.2.2) this is our production.
> 
>  
> 
> We have now built up a development server, but we want to export the db
> from the production one and import it into the dev so we have some real
> data to play with.  Can you point me in the right direction on how to do
> this? Or if you've done it, can you tell me what and how you did it?
> 
>  
> 
> We are using mysql as the db.
> 
>  
> 
> Thank you.
> 
>  
> 
> Oscar 
> 
>  
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! (Boston,
> San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com