[rt-users] backing rt up

[Sheeri Kritzer]

you want to use mysqldump.  Depending on the version/platform you have, 
mysqldump -a > file.sql will dump all the tables.  Otherwise you can use 
mysqlshow to get table names and use mysqldump <tablename> to dump them 
into files. 

To put the tables back in, I'd suggest:  mysql < file.sql.

Although,  Alesh Mustar <alesh at sportina.si> very recently posted the 
following:

mysqldump -c -t -uroot -ppassword rt2 > rt2.sqldump
mysqldump -d -uroot -ppassword rt2 > rt2.sqlschema

which might work better.

-- 
Sheeri Kritzer
Systems Administrator
University Systems Group
Tufts University
617-627-3925
sheeri.kritzer at tufts.edu

On Wed, 21 Nov 2001 darrellb at hhcl.com wrote:

> what's the 'official' script for dumping the tables before backup?
> 
> thx
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>