How would I use a cron job to backup my MySQL database(s)?
Please explain this would be helpful.
Please explain this would be helpful.
Cron Job to Backup MySQL Database
Look. Instant support. This host is great eh?
| Code: |
| mysqldump --add-drop-table -u <user> -p <pass> <dbname> > phpbb_sql_backup-$(date +1m1d1Y).sql |
Yes you are so great.
I replaced the user, pass, and dbname with their real stuff and now I just gonna test and make sure its doing it. Oh and Im a little confused, was I supposed to also remove the < > marks when inputting the names?
Where is the .sql file saved to?
I replaced the user, pass, and dbname with their real stuff and now I just gonna test and make sure its doing it. Oh and Im a little confused, was I supposed to also remove the < > marks when inputting the names?
Where is the .sql file saved to?
I'm not n0obie4life, but I think I can answer your questions.
First, yes, I believe that you should remove the <> characters in the cron job command.
And if I'm not mistaking, unless you specify otherwise the file will probably get saved to your root directory. Obviously, you can change this by editing the command as such:
I hope I can be so great too. Just joking.
First, yes, I believe that you should remove the <> characters in the cron job command.
And if I'm not mistaking, unless you specify otherwise the file will probably get saved to your root directory. Obviously, you can change this by editing the command as such:
| Code: |
| mysqldump --add-drop-table -u <user> -p <pass> <dbname> > /mysqlbackups/phpbb_sql_backup-$(date +1m1d1Y).sql |
I hope I can be so great too. Just joking.
Okay thank you.
Please close this topic.
Please close this topic.
 |