Re: Mysql

[Mitch Wiedemann <mc2@xxxxxxxxxxxxx>]

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