Mailinglist Archive: opensuse (1473 mails)

[G T Smith <grahamsmith@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

-----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@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx