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
2243
Peter Hon
March 18, 2021 01:19AM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
922
Peter Brawley
March 18, 2021 09:17AM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
1023
Peter Hon
March 18, 2021 07:50PM
Re: mysqldump always prompt Got error: 1066: Not unique table/alias: 'temp1' when using LOCK TABLES
722
Peter Brawley
March 19, 2021 10:13AM


Sorry, you can't reply to this topic. It has been closed.

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.