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

Export Database Tables Crop/Create Question

User, date Message
Written by Sakusami
8 months ago
Category: Import/Export
2 posts since Thu, 19 Dec 13
Hi all,

I am using HeidiSQL to backup some of my production tables and also to bring them down to my dev servers for testing.

This is my first time doing this with Heidi and I want to use the "Export Database SQL" tool. When using this tool, I noticed there are 4 checkboxes in the upper right that give you the choice to "Drop/Create" Table and Database during the export.

So my question: Do these options just add drop/create blurbs to the export sql code OR do they delete/create the table fresh as the export is happening?

As I write this I feel it is the first and not the second, but I figure I would just rather ask then trial by fire and waste the time making backups the old fashioned way.

Thanks!
Written by ansgar
8 months ago
4988 posts since Fri, 07 Apr 06
All 4 options only affect the target output, never the source! This is a critical thing to know, and I guess I should note that somehow in the dialog.
Written by Sakusami
8 months ago
2 posts since Thu, 19 Dec 13
Thank you very much, I appreciate the quick response! happy
 

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