Backing up Mysql

Peter Nixon listuser at peternixon.net
Mon Mar 13 08:54:09 CET 2006


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..

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060313/02f65b02/attachment.pgp>


More information about the Freeradius-Users mailing list