[rt-users] DB import

[Ruslan Zakirov]

"--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 at compupay.com> 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
>



-- 
Best regards, Ruslan.