Reputation: 1
Command to generate the backup
*mysqldump.exe --host=10.10.10.1 --protocol=tcp --user=user --password=****** --column-statistics=0 --port=3300 --default-character-set=utf8 database > c:/Temp/backup.SQL*
Generate the error:
Got error: 1066: Not unique table/alias: 'apuracao_survey' when using LOCK TABLES
In MariaDb, CASE-SENSITIVE=ON, which creates duplicate views: ** apuracao_survey * APURACAO_SURVEY*
If you delete a VIEW, the two are removed, and when you create VIEW again, the database creates the two.
Upvotes: 0
Views: 267