Re: Backing up Mysql

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