Quote:
Originally Posted by Grebbin
I Have a batch file that reads like this timed to run every 24 hours. I also have bots enabled.
@echo off
Echo Please wait while the peq database is backed up as 'L:\peq_backup.sql' ...
mysqldump -uroot -p******* peq > l:\peq_backup.sql
You said...
"Your mysqldump command needs the -R switch to pick up the methods."
So what would the full context be? I'd like to have an auto db backup to my memory stick so I can roll back the server in case of emergency. Would it be:
mysqldump -uroot -p****** peq > l:\peq_backup.sql -R ???
I'm an SQL NEWB! Thanks!
|
It may not matter, but your password is showing. Maybe you already changed it when you posted, but I thought I'd alert you just in case.
