Re: [opensuse] Moving the database directories

-----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

Relevant Pages

  • Re: Are "eSATA drives + enclosures" the ONLY way to get fast ext drives?
    ... It is both apps and data in my case, plus the darn Vista OS itself. ... drives and an empty Firewire external ... put one of the 1TBs in it, run a backup of your system. ...
    (comp.sys.mac.system)
  • Re: SuperDuper And A Damaged Directory
    ... and reinstalling can be a bother if you have lots of apps. ... > the disk (and thus of any backup) is of concern, ... > corruption are. ... it seems that a complete reinstall of everything except the docs ...
    (comp.sys.mac.system)
  • Re: Partition Ideas - Your Advice, Please?
    ... A dedicated partition would be useful only on a second drive ... to reinstall the apps anyway. ... puts the system back to where it was at the time of the backup. ... rich, n9dko ...
    (alt.sys.pc-clone.dell)
  • Re: How to create my own VB backup program for a remote MySQL DB
    ... MySQL has an OLEDB driver, ... Both data and schema are stored in the output file. ... the recordset to an open connection, call UpdateBatch and ADO and the server ... > I understand that the basic principles to create a TCP/IP backup program ...
    (microsoft.public.vb.database)
  • Re: Trouble restoring data on Palm T5
    ... my laptop to save the data I need, then did a hard reset on the T5, then ... bunch of other files related to various apps that I added in the past. ... Search in your desktop's Palm folder for your Backup folder. ...
    (comp.sys.palmtops.pilot)