DB import

RT Users
1

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 serverkeeping all the data intact many thanks Nick Price
Get ideas on sharing photos from people like you. Find new ways to share.
http://www.windowslive.com/explore/photogallery/posts?ocid=TXT_TAGLM_WL_Photo_Gallery_082008

2

Dumping it:

mysqldump --user=rt_user --password= --opt --skip-lock-tables

–single-transaction --default-character-set=binary --databases rt3 >
/home/mysql/rt.sql

Per MigrateToNewServer - Request Tracker Wiki

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.0From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nick
Price
Sent: Thursday, August 28, 2008 5:11 AM
To: rt-users@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>

3

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= --opt --skip-lock-
tables

–single-transaction --default-character-set=binary --databases
rt3 > /home/mysql/rt.sql

Per MigrateToNewServer - Request Tracker Wiki

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@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of Nick Price
Sent: Thursday, August 28, 2008 5:11 AM
To: rt-users@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!

The rt-users Archives

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

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

4

I won’t be able to answer that honestly :slight_smile: 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?

5

“–default-character-set=binary” on mysqldump is required if you
migrate RT 3.6.x from mysql4.1+ to another 4.1+ (mysql 4.0 has no such
option). Reasons why this is required are described in
etc/upgrade/schema.mysql-4.0-4.1.pl (RT 3.8+).

Once you’ll correctly migrate to 3.8.1+ there would be no need in such
things on backups and later migrations (I hope).On Thu, Aug 28, 2008 at 5:54 PM, Helmuth Ramirez HelmuthRamirez@compupay.com wrote:

Dumping it:

mysqldump --user=rt_user –-password= --opt --skip-lock-tables

–single-transaction --default-character-set=binary --databases rt3 >
/home/mysql/rt.sql

Per MigrateToNewServer - Request Tracker Wiki

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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nick Price
Sent: Thursday, August 28, 2008 5:11 AM
To: rt-users@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!

The rt-users Archives

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

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

Best regards, Ruslan.