[thelist] MySQL Backup

[Hans Zaunere]

In the contrib/support/share dirs of the MySQL binary/source distros
there are some perl scripts that do "hot" backups of tables/DBs.  There
are quite a few ways to do this, depending on your needs:

http://mysql.com/doc/D/i/Disaster_Prevention.html

Also consider replication.. very nice, reliable, and easy to setup,
again, depending on your needs.

If you'd like to do a script in PHP to run from cron, basically all the
perl script does is lock the table at hand, backsup, unlocks, etc.
It's really straightforward, and making a slick script would probably
improve upon the existing perl script.

Hans Z.
New York PHP
http://nyphp.org




--- Chris <axe at suburbia.com.au> wrote:
> Hey,
>
> I am currently working on a project that has a requirement for
> automated
> backups of a MySQL database. I figured the best way to do this was
> via a
> crontab which executes a script (php or other) that backs up the
> database.
>
> I could more than likely code this myself, but the phrase 'why
> reinvent the
> wheel' comes to mind. So I was wondering if anyone has come across a
> script
> that can accomplish what I am after.
>
> Thanks,
> Chris
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com