Warning Flag on Database Drop

finbar's profile image finbar posted 1 month ago in Feature discussion Permalink

Hi

Great product I have been using for well over 10 years ( I just made a small donation of £100 )

Is there any chance/thought of a warning flag on the Export Database as SQL Drop Database tick box.

The reason I ask is I accidentally ticked it and dropped a live database ( queue major panic ) luckily I had a sufficient backup. First time I have done it in over 10 years but it might be nice to have an extra Are You Sure ! I looked at changing privileges on the user to stop it at the db level ( MySQL) but its not possible without disabling Table Drops

Open to an alternate process for avoiding this mistake/ your thoughts

Regards

Finbar

ansgar's profile image ansgar posted 1 month ago Permalink

You are not the first one if I recall right. That's why there is already some logic behind the Drop checkboxes:

  • checking them formats them in bold font and adds two exclamation marks at the end
  • even if you active one of them, they don't get auto-checked the next time

So you checked the "Database(s): Drop!!" checkbox and exported the whole thing directly to a live database?

1 attachment(s):
  • sql-export-drop-warn
finbar's profile image finbar posted 1 month ago Permalink

yes I did :( I use the Export function to sync the View and Procs across our systems but in this case it dropped the database first ! It was something I could mostly recover but it made me think what if I did it in a circumstance where I couldn't recover (which should not be the case) ...

Won't stop me using the product just need to be careful , we use DbSchema to synch database tables ( but I find it is a little buggy when it updates views/procs)

Please login to leave a reply, or register at first.