mysqldump: Got error: 1066: Not unique table/alias: 'foo' when using LOCK TABLES when lower_case_table_names=1

Solution 1:

Rename one of the conflicting relations.