OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path:
################################################################# #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename>/dbbakup/databasename.sql ################################################################# Add the following to your crontab: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh ----- Original Message ----- From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil >From: "Gerald R. Jensen" <[EMAIL PROTECTED]> >Reply-To: "Gerald R. Jensen" <[EMAIL PROTECTED]> >To: "Neil Tompkins" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: backing up mySQL database ? >Date: Sat, 30 Nov 2002 10:23:22 -0600 > >You don't have to develop or buy anything. You can use mysqldump in >conjunction with a shell script to do what you want, and automate it with >either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). >----- Original Message ----- >From: "Neil Tompkins" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, November 30, 2002 9:33 AM >Subject: backing up mySQL database ? > > >Hello, > >I'm looking to either development a software application that will allow me >to automatically at scheduled intervals backup my mySQL databases. I would >like to save the table structures and data. I;ve used mySQL Front that >allows you to backup these, but I need it to be automated e.g every 2 >hours... > >Can someone point me in the right direction. I will look to develop the >software is Delphi 6 or C++ Builder 5. > >The other option I have is to purchase some software that will allow me to >do this. Any suggestions or recommendations ? > >Thanks for any help and advice. > >Neil > > > >_________________________________________________________________ >The new MSN 8: advanced junk mail protection and 2 months FREE* >http://join.msn.com/?page=features/junkmail > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
