Mitch Wiedemann mc2 at
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?
Mitch Wiedemann
mc² Computer Consulting
mc2 at

More information about the users mailing list