-----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... I would do a mysqldump of the databases required (read docs).... Shutdown MySQL. Change database location in configuration files... Start MySQL Restore the dump... Check everything is working Then delete everything you think you do not need.. BTW I personally prefer using mysqldump in any data backup operations....(file based MySQL backups can give nasty surprises)... - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iEYEARECAAYFAko6IXEACgkQasN0sSnLmgKBYwCgxf8T0MT74E/loAXznqBwyEHL lO8An3KxdANqRlJYALP4RtmvozWPb92n =T6nC -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org