What to check on export to .sql

[expired user #5694]'s profile image [expired user #5694] posted 13 years ago in Import/Export Permalink
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's profile image ansgar posted 13 years ago Permalink
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.
[expired user #5694]'s profile image [expired user #5694] posted 13 years ago Permalink
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's profile image ansgar posted 13 years ago Permalink
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.