[opensuse] Moving the database directories
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 ?) -- Duaine Hechler Piano, Player Piano, Pump Organ Tuning, Servicing & Rebuilding Reed Organ Society Member Florissant, MO 63034 (314) 838-5587 dahechler@att.net www.hechlerpianoandorgan.com -- Home & Business user of Linux - 10 years -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 2009-06-17 at 03:44 -0500, 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 ?
What dbs?
(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 ?)
How isn't that a backup? As for "better" I think the results are probably exactly the same. How are you performing your "backup" now? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
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 ?
Assuming we're talking about your mysql databases, any method will do - cp for instance.
(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)
If your backup method is not reliable, maybe you need a replicated database? /Per -- Per Jessen, Zürich (19.6°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----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
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
participants (4)
-
Adam Tauno WIlliams -
Duaine & Laura Hechler -
G T Smith -
Per Jessen