Thanks for that information. But I think I want to purchase a software application, due to my lack of knowledge for mySQL. In addition to this, my ISP doesn't allow that much control over the operating system.
Can anyone recommend a software app. I could buy to be able to dump data and table structures to a text file. Ideally as mentioned before I need to run this on a hourly basis.
Rgds,
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 14:17:52 -0600
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
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
---------------------------------------------------------------------
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
