Plain R1soft-Idera backup does not directly support mySQL database backup.

But with this workaround you can backup your mySQL database too.

 

Run crontab in unix shell and create the rule to launch process for creating database backup:

 

0 0 * * * /usr/local/bin/mysqldump -uLOGIN -PPORT -hHOST -pPASS DBNAME | gzip -c > `date “+\%Y-\%m-\%d”`.gz

 

You can modify the script as needed to get a different schedule.

This script will create a .gz file with the backup of your database. It's an ordinary .gz file, and it will be normally backupped as any other files of your server.

Another way to do it is using MySQLDumper: a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and - if needed - restore it. It is especially suited for shared hosting webspaces, where you don't have shell access. MySQLDumper is an open source project and released under the GNU-license.

 

Found this article interesting?
Subscribe to DomainRegister´s newsletter!

You can unsubscribe at any time by simply clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp s privacy practices here.

  • MySQL, R1soft, backup
  • 0 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

 How to Backup Your MySQL Database Using PHP

This simple PHP script will provide a full dump of your MySQL database.You need to provide...

 Come effettuare il backup di un database per mezzo di phpMyAdmin

PhpMyAdmin permette di effettuare il backup ("dump") di un database MySQL in maniera molto...

 How to repair tables in MySQL

Table corruption in MySQL is a very frequent issue, which primarily happens due to failed/forced...

 How to import a db dump in a database with different name

 How to generate random string in MySQL

If you need to create random string (i.e., to be used as password) in MySQL, you can easily do it...