MySQL Forums
Forum List  »  Data Recovery

Advanced Search
New Topic

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.

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


Subject
Views
Written By
Posted
Mysqldump not creating tables in the correct sequence, giving errors.
713
Michael delos Reyes
October 04, 2021 01:28PM
Re: Mysqldump not creating tables in the correct sequence, giving errors.
368
Peter Brawley
October 04, 2021 03:01PM
Re: Mysqldump not creating tables in the correct sequence, giving errors.
335
Michael delos Reyes
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.