Backing up Mysql

[Sebastian Wild]

The question is in which way do u backup it? Using mysqldump in your 
cronjob?
Maybe its a better way to simply create a copy of /var/lib/mysql. All 
your databases are in there and copying tis don't affect the running 
mysqld in any way. We do that on lots of server every night...

cheers
Sebastian

Peter Nixon wrote:
> On Sun 12 Mar 2006 16:05, Sarkis Gabriel wrote:
>   
>> Hi all
>>
>> i started backing up the db using a crontab job early in the morning which
>> backs up everything, but i have had complains from users who try to logon
>> after the backup process.
>>
>> What is the best way to backup an active database with radiusd waiting for
>> connection?
>>     
>
> You could use postgresql instead of mysql. It doesn't lock the database while 
> doing a backup so everything just slows down a little while backing up, but 
> keeps on working..
>
>   
> ------------------------------------------------------------------------
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


-- 
mfg
S.Wild

Cronon AG
- Technik -
+49 941 56 71 23 95 Fon direkt
+49 941 59 57 91 64 Fax
+49 941 79 77 58 9  SIP
+49 941 58 41 03 9  Fon Technik zentral

"Die Predigt in einer Kirche macht den Blitzableiter auf der selbigen 
nicht überflüssig!"
					Georg Christoph Lichtenberg