guru, I want to my box to auto backup the database what I can do? or how to write the script to have the system auto run the backup command "mysqldupm --opt database > backup.sql" please help me thanks John

hi I want to know how to backup database in mysql. I am using Red Hat 7.1 as operating system. thanx

#!/bin/ksh DATE=`date +%Y%m%d` if [ ! -d /var/dumpfiles ] ; then mkdir /var/dumpfiles fi cd /var/dumpfiles/ find . -type f -mtime +5 -exec rm -f {} \; mysqldump --opt test \ > /var/dumpfiles/backup$DATE.sql save the above as /usr/bin/dump.sh chmod 775 /usr/bin/dump.sh add an entry to your crontab to execute this script when ever it pleases you. You might choose to include these dump file

can you show me how to add to crontab... I'm just new to linux please thanks John

echo "1 1 * * * root /usr/bin/dump.sh" \ >> /etc/crontab The '/etc/crontab' file is a system level file for recurring jobs. man crontab will tell you more 7 fields minute hour day_of_month month day_of_week user command Rather than the above echo statement, you could edit /etc/crontab with your favorite editor You could also use "crontab -e"

Now that mysql db is backup (using mysqldump.exe win32), can all the db be restore with mysqlimport.exe? Is it necessary to create the db name first in order to use mysqlimport or is there another command to do this? Thank you

You can use backupsmanager from indexsoft.com. May be crontab will be add to it...