MySQL Forums
Forum List  »  Data Recovery

Re: Mysqldump not creating tables in the correct sequence, giving errors.
Posted by: Michael delos Reyes
Date: October 04, 2021 03:57PM

Thanks.
My original error was unable to lock a table when importing because of an "add constraint ... reference" in an alter table.
I added the table_name in the lock table statement that sqldump produced.
And thats when I got the table doesnt exist error.
The table is in the dumpfile but it comes 200 lines after this alter table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysqldump not creating tables in the correct sequence, giving errors.
66
October 04, 2021 03:57PM


Sorry, only registered users may post in this forum.

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.