Re: FN-FORUM: mySQL backup

date posted 25th January 2006 14:26

On Wed, Jan 18, 2006 at 08:29:02AM -0000, Andrew Larcombe wrote:
> Sam Morgan wrote:
> >I have an classic ASP application that uses a mySQL DB and I would like to
> >be able to allow my users to backup there parts of the database tables so
> >they can restore only there bits if they need too.
> mysqldump, supplied with the mysql distribution, is the preffered way of
> backing up simple databases.

I'd second this and also recommend that you setup the inbuilt MySQL
replication to duplicate this data onto a server that can be dedicated
to backups.

This allows you also to take image backups of the database files in case
of a more sinister outage. It also gives you a second online
environment that you can 'flip' your application over to using, in the
event of a terrible failure on your master db. It also will provide a
useful platform for running ad-hoc reports on that would normally slow
up access to the database for your application.

Everyone's a winner !

-a