CREATE VIEW appears before CREATE TABLE it references (databacker/mysql-backup:1.2.2 | mysql:8.0.34)

[ChobotX]

Hi,

In a legacy project, we upgraded your package from version 0.12.0 to 1.2.2. During this process, we encountered an issue: the SQL dump contained a CREATE VIEW statement placed before the CREATE TABLE statement it referenced. This occurred while using mysql:8.0.34.

We resolved the issue by switching to mysqldump, which correctly orders the statements. Since that meets our current needs, we're not blocked by the issue anymore.

Just wanted to let you know.

[deitch]

Hi. Can you share a scrubbed dump file? Don't need all of the data, or real table names, just a simple output?

We resolved the issue by switching to mysqldump

Yeah, mysqldump definitely hits the basic needs. As a matter of fact, the original versions of mysql-backup were created as a wrapper around mysqldump, just to add things like reporting, uploads, scheduling. Over time it grew (and grew and grew), and eventually became its own program.

If mysqldump gives you what you need, by all means, I am glad it works. If you need more of what mysql-backup has, then happy to have you back.

[deitch]

Actually, I do find it interesting that you are having this issue (and thanks again for raising it). The code clearly dumps tables, then dummy views, then actual views. It would help if you can show how to replicate it.