Home → DataMate v6 → Common Support Queries → MySQL Backup Common Errors
Error:
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
OR
Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Solution:
1. Create a file named mysqldump-obm with the same path as the mysqldump application
2. Within the file add the following, updating the path to mysqldump if required.
#!/bin/bash
/usr/bin/mysqldump $* --skip-lock-tables --events
3. Change the Path To MySQL Dump in the backup configuration to the the mysqldump-obm file