Help moving DB to a new server

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

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


The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston,
San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

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.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
steverieger
Sent: Friday, March 11, 2005 2:06 PM
To: Oscar Gonzalez; rt-users@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.

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


The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@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@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.

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.

You can mysqldump any format MySQL table, so that procedure will work
for myisam tables too.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

If your moving to a newer version of RT don’t forget to run the upgrade
scripts as well (after you dump all this into mysql as mentioned
previously)…Something along the lines of: /root/rt-3.4.0/etc/upgradeFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Mai Le
Sent: Friday, March 11, 2005 6:18 PM
To: steverieger; Oscar Gonzalez; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Help moving DB to a new server.

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.

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
steverieger
Sent: Friday, March 11, 2005 2:06 PM
To: Oscar Gonzalez; rt-users@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.

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


The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact
training@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@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.