@JaredBusch said:

@tonyshowoff said:

Using anything but UTF-8 is a crime!

True, and even old WP installs used it without the actually making sure the DB was configured that way. So odd.

That kind of ineptitude seems par for the course for WordPress. UTF-8 issues can't be blamed just on them though, consider the absolutely bizarre issue of utf8 vs utf8mb4 for MySQL, why the hell wasn't it implemented completely the first time?

@Ambarishrh said:

@JaredBusch Nice! was not aware of that, so CentOs already switched to MariaDB? 🙂

Yes. RHEL = CentOS.

I tried adding open-files-limit=4096 in /etc/my.cnf and restart mysql. Then executed automysqlbackup again, this time got something else.

Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

Checking for fixes