Creating a read-only backup user for mysqldump

1 · Benjamin Cane · Dec. 12, 2011, 11:08 p.m.
Mysqldump is a great utility for backing up or exporting a database to a flat file. This flat file can then be used to import the database or databases into another mysql database or even another database server like postgre depending on the options you use. To perform a very simple backup of the mysql database you can simply just setup a cronjob that runs mysqldump at whatever interval you want....