Requirements and Recommendations

Regarding MySQL, the following requirements must be fulfilled:

• The Backup Agent must be installed on the MySQL server.
• A temporary directory must be created on the server, therefore we recommend to create it on the local disk after checking there’s enough free space left for the required activities.
• MySQL user must have "ALL PRIVILEGES" in order to allow the Agent to perform the backup procedure.

• For instance:
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
  
  GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost.localdomain' IDENTIFIED BY 'password';
  
  mysql> FLUSH PRIVILEGES;

Note: the database "information_schema" is a virtual database of the system that contains the information regarding the databases hosted in the MySQL instance. This DB is in read-only mode and, therefore, cannot be saved.