Hi everyone
I just have a quick question about creating a db backup.
I have MySQL Workbench 6.2 installed and I know how to go about exporting data. I am exporting to a self-contained SQL file solely for the purpose of being able to restore the website if something terrible goes wrong. I regularly save a copy of the SQL file plus a zip of the file system.
What I want to know is whether I need to select any of these options on the export page:
Dump Structure and Data << I always choose this option
Dump Stored Procedures and Functions << Should I also take this?
Dump Events << prob not?
Dump Triggers << maybe?
Include create Schema << don't know?
I've done some research but it's not clear what is best for the purpose.
Thanks for any advice on this.
Rob
Bookmarks