Tag Archives: backups

How to MySQL Dump and Recovery

How to MySQL Dump and Recovery | MySQL has the ability to dump or backup an entire database to a single recoverable file. I’ll show you how to dump and also recover! Dump a MySQL database To dump a mysql database, the command is: $ mysqldump -u mysqlusername -p databasename > mybackup.sql Enter password: (enter your mysqlusername’s mysql password) For example if

Rotate MySQL Backups With Logrotate

Rotate MySQL Backups With Logrotate | logrotate can be used to rotate and auto-purge any file, including mysql backups. This very server (scottlinux.com) backs up a mysql dump daily, keeping the previous 8 with this method. I’ll show you how: 1. Create the following file, editing as desired. This example backs up all mysql databases in one dump. Of course you