[rt-users] backing up / moving rt db ?

[Feargal Reilly]

mysqldump will dump the database then mysqlimport can be used to put it into 
the new one.

I've never done a dump with mysql, RT is the only software I use that requires 
mysql, usually I use postgres. I imagine it's fairly clean. run the commands 
for the full list of options.

-Feargal.
--
Feargal Reilly,
Systems Administrator,
The CIA.
+353-86-8157621

Have a look at the 
> 
> Hi all,
> 
> Another quick question: 
> 
> Say I want to be able to move the rt database in mysql to a new
> installtion of mysql, is there a simple way to do this? It'll stay on the
> same machine, just a new directory structure.
> 
> Also for backup purposes do I just need to backup the various files
> in /var/<queue-name> ?
> 
> Thanks
> 
> Paul
> 
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>