On 09.02.2001 11:35:27 T. Stephen Dachtera wrote:
> I am wondering, if it is possible to use MySQL and create a shell script to
> backup tables from a database on a cron? If anyone has an idea if this is
> possible, and how I might go about it, it would be much appreciated!
Create a cron job
My script backuping up alla databases which is in my datadir.
It's works for me.
#!/bin/sh
USER=root
PASSWORD=somepassword
BACKUPTYPE=daily
if [ -x $BACKUPTYPE ]
then
echo "$0 "
exit 0
fi
for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do
DB=$i ; DATE=$BACKUPTYPE ; r
I am wondering, if it is possible to use MySQL and create a shell script to
backup tables from a database on a cron? If anyone has an idea if this is
possible, and how I might go about it, it would be much appreciated!
Thank You - Tim
--
Tim Dachtera - [EMAIL
