distal-attribute
distal-attribute
distal-attribute
distal-attribute

What to check on export to .sql

waynub posted 3 years ago in Import/Export
I'd like to export to .sql and get a copy of my db. I didn't check any boxes and have no data in the data box...How do I properly set up export to .sql while db is being accessed so i have a current copy?

Thanks
ansgar posted 3 years ago
Well there are 4 self explanating checkboxes and one drop down for the data processing. Normally you can just check the "Create table" checkbox, and select "INSERT" for data processing. And of course, select a file and the file output option.
waynub posted 3 years ago
Thanks for the reply. I have been indoctrinated by fire and have 0 experience with HEIDI or other db programs. So the boxes are self explaining to you and not to me. My fear is that I click the wrong button or check the wrong box and the whole db will stop working.

My question should have been: If I create (both files and db) and insert data into one big file that is saved... I won't kill anything?
ansgar posted 3 years ago
You can only kill something if you check one of the both "Drop" checkboxes. Drop is a synonym for delete.

And yes, checking both "Create" checkboxes + selecting the INSERT data option is a safe way. File output is just one option to back up your data in a local file. This .sql file can be imported afterwards on any MySQL server, using various clients including HeidiSQL, but also mysql.exe, MySQL Workbench and many other applications can handle sql files.

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