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

[Mai Le]

If its an inodb,  once you made a dump (per the instruction below), 
To install on the dev server,  mysql -u root -p < name_of_file.sql  
If you just install rt on the dev server, you will need to drop the rt
database.  I'm assuming you are naming the database, user, group the
same way they are on the production machine.   

To drop the database on the dev system,
   mysqladmin -u root -p drop database_name
Then upload the production database
   mysql -u root -p < name_of_file.sql

Now you should be back in business.
-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of
steverieger
Sent: Friday, March 11, 2005 2:06 PM
To: Oscar Gonzalez; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Help moving DB to a new server.

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


_______________________________________________
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


CONFIDENTIALITY NOTICE: The information contained in this message and
or attachments is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination, copying, or other use of this
information by persons or entities other than the intended recipient is
prohibited. If you received this e-mail or its attachments in error, 
please contact the sender and delete the material from any system and 
destroy any copies.