Input [IMPORTANT] Roundcube database is not included in backups

[vaelu]

Hello Pleskians

I recently noticed that the Roundcube database with all user settings, sessions, address books etc. is not included in the Plesk backup which is created automatically via the Backup Manager. I think this is a problem and should get fixed, since when restoring a backup also the Roundcube data should get restored.

For us, it is more complex to do backups now since we had to write a script which manually backups the database every time a backup gets created.

Please vote for the idea here: add roundcube database to backup

 

[Kaspar]

Voted

 

[IgorG]

The database dump is not included because the Roundcube database format differs significantly from version to version. We can't guarantee that dump of one Roundcube installation will be successfully restored on other Plesk server or the same Plesk server with an installed update.

But I agree that the request is valid, and if it is sufficient demand, we will definitely consider it.

 

[vaelu]

Bumping this

 

[Bitpalast]

You can create a cronjob that backups the current roundcube database into a subscription, e.g. daily a short time before the full server backup is done. Then, when the full server backup is run, that .sql dump is being backed up with the Plesk backup.

# /usr/bin/mysqldump --lock-tables=false --user=admin --password=`cat /etc/psa/.psa.shadow` --add-drop-table roundcubemail >> /var/www/vhosts/<your subscription>/roundcube-backup.sql

 

[vaelu]

You can create a cronjob that backups the current roundcube database into a subscription, e.g. daily a short time before the full server backup is done. Then, when the full server backup is run, that .sql dump is being backed up with the Plesk backup.

# /usr/bin/mysqldump --lock-tables=false --user=admin --password=`cat /etc/psa/.psa.shadow` --add-drop-table roundcubemail >> /var/www/vhosts/<your subscription>/roundcube-backup.sql

Really helpful input, thanks. We already have a setup like this, but it would be cool if Plesk would do this by default.

 

[biotradmeding]

voted

 

[Alex Presland]

Voted... After suffering from a server failure and finding that all users have just lost their settings and address books. :-(

The database dump is not included because the Roundcube database format differs significantly from version to version. We can't guarantee that dump of one Roundcube installation will be successfully restored on other Plesk server or the same Plesk server with an installed update.

The simple thing here is that an incompatible backup would be better than no backup at all.

 

[scsa20]

I would suggest voting for it on Include roundcube settings in backup as this is where the development team will look at the feedback and if it's popular enough will add it

 

[Alex Presland]

I would suggest voting for it on Include roundcube settings in backup as this is where the development team will look at the feedback and if it's popular enough will add it

Voted... After suffering from a server failure and finding that all users have just lost their settings and address books. :-(

I did! First word of my post conveys this.

 

[webhostau]

Voted

 

[maurilio]

Voted

 

[Maarten]

Instead of dumping the whole Roundcube database, which can be quite large, you can skip the session table to make the backup smaller:

# /usr/bin/mysqldump --lock-tables=false --user=admin --password=`cat /etc/psa/.psa.shadow` --add-drop-table --ignore-table=roundcubemail.session roundcubemail >> /var/www/vhosts/<your subscription>/roundcube-backup.sql

 

[maurilio]

How do you know the admin@localhost password? Is it better to create a user for the roundcube DB?

 

[Alex Presland]

There's a shadow password file which it is read from. That's the bit which reads:
--password=`cat /etc/psa/.psa.shadow`