[rt-users] backing rt up

[dr john halewood]

On Wednesday 21 November 2001 17:51, darrellb at hhcl.com wrote:
> what's the 'official' script for dumping the tables before backup?

There's no "official" script as such - it depends on what database you're 
using as the backend. I use mysql and have ever-so-slightly hacked the 
contributed rt-backup script (see ftp.fsck.com/pub/rt/rt1-contrib IIRC). It's 
basically just
mysqldump -c -t rt2 >   rt.sqldump
mysqldump -d rt2 >       rt.sqlschema
You can then restore the whole lot (assuming a fresh install of rt2 
thereafter) with
mysql rt  < rt.sqlschema
mysql rt  < rt.sqldump
(with whatever usernames and passwords you have specified). 

cheers
john