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.
210
October 04, 2021 03:57PM


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.