Mysql
Mitch Wiedemann
mc2 at lightlink.com
Sat Feb 7 18:07:10 UTC 2004
I put the data in /home/mysql so that I can use rsync to move all
/home/* to a backup server each night.
I suppose, now that you mention it, running a mysqldump to /home/mysql
and THEN running my rsync would be better since I realize the data table
copy isn't the best idea in the world, although it hasn't caused me any
trouble so far...
Sometimes I do things because I don't know any better... :) Which is
just the sort of reason I joined this list!
Thanks for the input.
Alexander Dalloz wrote:
>Am Sa, den 07.02.2004 schrieb Mitch Wiedemann um 17:59:
>
>
>>Just out of curiosity, does anyone know why they're put in
>>/var/lib/mysql/ by default? I always store them in /home/mysql (using a
>>symlink from /var/lib/mysql) to make backups easier...
>>
>>
>
>You set mysql's home to /home/mysql in /etc/passwd and datadir in
>/etc/my.cnf to /home/mysql too? Why is that better/easier for backups?
>Don't you run mysqldump to backup the databases?
>
>Alexander
>
>
--
Mitch Wiedemann
mc² Computer Consulting
mc2 at lightlink.com
http://www.lightlink.com/mc2
More information about the fedora-list
mailing list