Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleDatabases(Mariadb, Mysql)

  III.Databases       

You just need to Enable the MySQL schedule option, select the Storage server and set the partition where to backup the databases.

This will save all your databases from the server with mysqldump directly to the remote storage server.

  • Storage Server - the storage server on which you want to back up will be selected.
  • - the desired number of increments will be chosen for backup: i.e 7 (meaning 7 different backup points retained)
  • Storage Partition - the partition will be added/the folder where the backup files will be found. i.e /hdd1/custom/Folder1
  • Exclude databases from backup - will be completed if you want to exclude database from backup. ie. information_schema, performance_schema

OPTIONAL - MySQL admin/root username and password. Only if the MySQL server requires admin credentials to connect from the scheduled server :

INFO - cPanel and Plesk server does NOT require MySQL login credentials. The credentials are already stored in the root folder.

MANUAL TEST - You can manually test the MySQL connection on the production server with the following command:

Code Block
# mysql -h HOSTNAME -u USERNAME -pPASSWORD -P 3306

Image Added