Version 12.7 MySQL Backup DUMP - Create TABLE if not EXIST

Application issues
1

For some reason the SQL generated ej:MyBackup.SQL
where ever we have inside the table/field this: CREATE TABLE IF NO EXISTS …

the Backup SQL is replaced by CREATE TABLE IF NO EXISTS IF NOT EXISTS …

2

Hi Juan_Cosme,

To resolve the issue, we need more details. Could you please let us know what version of MySQL Server do you use?

SQLBackupAndFTP
SQLBackupAndFTP720×359 18.3 KB

Also, could you please send us a screenshot of the advanced settings of your backup job?

Thank you and sorry for the inconvenience.

3

Behavior is Happening in MySQL 8 and 7
2 different Server

like 10 Database Total Each Server.

Image attached from my PC also MySQL 8 (same Behavior)

image
image852×529 40.9 KB

4

Hi Juan_Cosme,

Thank you for the details.

Please give us some time to check the issue, we’ll keep you updated.

Thank you and sorry for the inconvenience.

5

Hi Juan_Cosme,

Thank you for your waiting. We tried to reproduce the issue, but without any luck. For further investigation, we need more details. Could you please provide us with a part of your *.sql file (with the issue) and Advanced Log with the Trace level. Here are more details on how to do it How to send Log to developers – SQLBackupAndFTP's blog

SQLBackupAndFTP Trace
SQLBackupAndFTP Trace940×566 42.2 KB

Note! With the “Trace” level, a log can contain your passwords. Before sending a log to dev team please open it using any text editor and remove the information you prefer to keep in secret. You can find them by clicking the “Open folder” link at the “Advanced Log” window (“Tools” > “Advanced Log…”).

To make your *.sql file and logs private, please send them directly to support@sqlbackupandftp.com

Sorry for the inconvenience.

6

DONE!!!

  • Backup Sample (just 1 Table)
  • Log FIle
  • SQL Sample to Create that Table (To do a Backup Test)

To Avoid Email Lost because of spam/block pls confirm if you can that was received

7

Hi Juan_Cosme,

Thank you for the details. We are working on the issue.

Once we have any news, we’ll notify you.

Thank you and sorry for the inconvenience.

8

Thanks…
Will wait for it…

9

Hi Juan_Cosme,

Thank you for your waiting.

We have fixed the issue in the Alpha edition https://sqlbackupandftp.com/download/alpha Could you please install it and check if it works for you?

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.

10

Thanks,
Teams will test today!!

11

Hi Juan_Cosme,

Sure, please feel free to contact us on any issues or concerns.