MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
Posted by: Peter Hon
Date: March 18, 2021 01:19AM

When I mysqldump a database, it prompts the following message and cannot dump. I have try to restore the database from backup. But the message still exist. I have no problem in dumping other database.

mysqldump: Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
886
Peter Hon
March 18, 2021 01:19AM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
341
Peter Brawley
March 18, 2021 09:17AM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
345
Peter Hon
March 18, 2021 07:50PM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
257
Peter Brawley
March 19, 2021 10:13AM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.