I have a MySQL database stored on AWS. I'm using Sequel Pro to manage it. I want to make a local copy for backup. In Sequel Pro, I see an option to File -> Export. I'm selecting SQL as the format. By default, the option to "Include Drop Table Syntax" is checked. Any ideas what this means? I want to rule out the possibility that it will drop my production AWS database after export.
It just means that the generated script will include
DROP TABLE statements in addition to
CREATE TABLE and
INSERT. The statements will be executed when you run the script to restore the database.