Question SQL Backup Task so Backup all DBs

[ffischer]

Hi there,
i want to backup all the whole mysql Server . each database seperatly.
is this possible with integrated tools like plesk Backup cli?

Or does i need to script something?
Does someone has a script to backup all the databases?

best regards
Frank

 

[Bitpalast]

Plesk does not exactly offer what you are seeking, but it can surely backup the system and databases. Just not separately as required.

Maybe this script can help? http://preiswerter-webserver-de.bitpalast.net/s/sql_backup_sample.txt

 

[sfat]

Plesk can do this out of the Box. Go to "Tools & Settings" -> "Backup Manager". When you create a new backup task (scheduled or one-time) you can select to backup "Server configuration and content". Do this and all databases are backed up. You can restore them individually by selecting a previous backup task, select "Database" to restore. The individual databases are grouped by the according subscription.

 

[ffischer]

thank you for your answers.

if this is going out of the box, so it does also do with cli?
but Database only, hm need to check this out this weekend ...

actiually i backup all Databases with sqlyog by ssh tunnel.
But #1 it tooks a verry long time and #2 huge traffic

 

[sfat]

I'm afraid the backup manager can't only backup the databases.

 

[ffischer]

maybe a feature request