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

What to check on export to .sql

User, date Message
Written by waynub
3 years ago
Category: Import/Export
2 posts since Thu, 05 May 11
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
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
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.
Written by waynub
3 years ago
2 posts since Thu, 05 May 11
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?
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
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.