MySQL Forums
Forum List  »  Data Recovery

Advanced Search
New Topic

Re: Mysqldump not creating tables in the correct sequence, giving errors.
Posted by: Peter Brawley
Date: October 04, 2021 03:01PM

Usual causes of that error are ...

- InnoDB tablespace or .frm files e=were diorectly manipulated

- Permission issues on table files

- table corruption

In the mysql client program, is the table visible to the Show Tables command?

In the dump script, has the non-visible table been previously referenced?

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


Subject
Views
Written By
Posted
Mysqldump not creating tables in the correct sequence, giving errors.
194
Michael delos Reyes
October 04, 2021 01:28PM
Re: Mysqldump not creating tables in the correct sequence, giving errors.
86
Peter Brawley
October 04, 2021 03:01PM
Re: Mysqldump not creating tables in the correct sequence, giving errors.
68
Michael delos Reyes
October 04, 2021 03:57PM


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.