Fedora Users — Re: Mysql

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@xxxxxxxxxxxxx
http://www.lightlink.com/mc2