After moving from MySQL 5.6 to 5.7, we had to move on from using mysqlhotcopy for backups due to 1) it being removed from the distribution and 2) some innodb tables now being present by default. After looking around, I settled on xtrabackup as it seemed like it would handle the innodb stuff and copy our myisam databases just like mysqlhotcopy used to. However, after running it for the first time last night, I notice that it didn’t back up any of our databases that contain a dollar sign in their name.
I used the --databases-file parameter and my file looks something like this:
It successfully backed up the first two databases but did nothing on the last two. We had a similar issue with mysqlhotcopy, but there was a patch available for it that made it possible to backup any such schemas. Is there anything that I can do to get xtrabackup to work with these databases?