Adriano Martins
Adriano Martins

Reputation: 1

error 1066 - Generate backup by mysqldump in mariaDb, name of duplicate views

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

Answers (0)

Related Questions