MySQL Backup Error In Logs
Symptom
MySQL backup error in logs.
Cause
Dots in database names are not allowed by MySQL. The reason the dot is not allowed is because a dot is valid SQL syntax to mean DATABASE.TABLE. If you have a dot in your database name it can cause problems for SQL statements.
Resolution
Although dots in database names are not technically valid in MySQL, MySQL can be forced to make them. We have seen clients do this by making a directory manually outside of MySQL in the MySQL data directory such as:
# mkdir MyBad.Name
Although not easy, one workaround is to rename the database to not have the dot.
We have an open bug (LIN-7) to investigate if we can possibly support malformed database names with dots in them. You are not the first person to have this issue and we would like to make it work with the dots in the database name.