I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
Random image from the web:
My favourite way ofcourse is command line and I found a backup script on UF.
#!/bin/bash #Script to make a regular copy of a mysql database and gzip it into the SAVEDIR. USER="authorized_user" PASSWORD="the_password" DATABASE="database_name" SAVEDIR="/backup" /usr/bin/nice -n 19 /usr/bin/mysqldump -u $USER --password=$PASSWORD --default-character-set=utf8 $DATABASE -c | /usr/bin/nice -n 19 /bin/gzip -9 > $SAVEDIR/$DATABASE-$(date '+%Y%m%d-%H').sql.gz
If you're on a server without a GUI, here's a package that will backup and rotate all of your MySQL databases daily by default.
That's it. The default configuration is sane so you're done unless you need something special. The backup files will be placed in
protected by Community♦ Jun 12 at 15:37
Thank you for your interest in this question.
Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.
Would you like to answer one of these unanswered questions instead?