Backing Up MySQL databases

[rsthomas]

Is there a way to backup just the databases within Sentora, separate from the daily Admin backup of all of the domains' public_html files and their databases?

Alternatively, can a PHP script be written that can do the job from the adminstration (zadmin) level? Or, even a script to run with SSH?

[Me.B]

modify this script to backup only db's.

https://github.com/MBlagui/Sentora-tools...erfiles.sh


M B

[rsthomas]

modify this script to backup only db's.

https://github.com/MBlagui/Sentora-tools...erfiles.sh


M B

Perfect!!

Had to change "zpanel_core" to "sentora_core," and it flew right through all the databases very quickly.

Thank you very much!

Follow-up:
To store the backup files in one common location:
#backupfolder="$5/backups"
backupfolder="/var/zpanel/hostdata/zadmin/backups"

You can quickly verify they are all there:
ls -l /var/zpanel/hostdata/zadmin/backups/

Login to the zadmin account and check the backups folder to view and/or download, or use your FTP program.