Clarification...
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 -pfiriona 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 -pfiriona peq > l:\peq_backup.sql -R ???
I'm an SQL NEWB! Thanks!
|