G T Smith wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Duaine & Laura Hechler wrote:
So I can stop worrying about wiping out my db data, what would be the best way to move the db's from /var to /home ?
(I'm already kicking off the apps from a script to backup the data after I close the app - but if the backup doesn't work than I'm back to square one)
Or instead of backing up the data - do an rsync from the directories of /var to /home ? (would this be better ?)
For MySQL I would not copy/move the physical files...
[snip]
BTW I personally prefer using mysqldump in any data backup operations....(file based MySQL backups can give nasty surprises)...
I used to run mysqldump, but with large databases it just takes much too long. I have long ago switched to mysqlhotcopy - I hope it doesn't provide any nasty surprises for me: http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html /Per -- Per Jessen, Zürich (25.8°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org