This approach does not guarantee you will catch all records changed -
some may still be in RAM and not yet flushed to disk. mysqldump is a
better approach.
George
Eric Katherman wrote:
>
> I have built a similar script but I don't go as far as stopping MySQL.
> I just compress the entire data directory, place it in a .htaccess
> protected directory that only will allow a local IP address (LAN file
> server) and then in the CRONTAB on the file server, I do a WGET from
> that protected directory. This happens every hour and has saved my but
> several times.
>
> On Mon, 2002-09-23 at 13:38, Phil Mattison wrote:
> > Hello Fellow PLUGers,
> > I have a Linux server running Apache/PHP/MySQL, and want to setup
> > automatic daily backups for the database. I'm planning to install a second
> > hard drive to receive the backup data, and will modify the web site to
> > exclude access while backups occur. I'm wondering if anyone has written
> > scripts to do similar tasks and would be willing to share some examples. I'm
> > thinking the script needs to do something like the following:
> > Stop MySQL
> > Copy the database files to the backup drive
> > Restart MySQL
> > It also would be nice to get a daily report of disk usage and the size of
> > the backups. If anyone has any tips or examples they would be much
> > appreciated.
> > Thanks,
> > --
> > Phil Mattison
> > Ohmikron Corp.
> > 480-722-9595
> > 602-820-9452 Mobile
> >
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change you mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)