Search code examples
mysqlsequelpro

Local Backup of MySQL DB with Sequel Pro


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.


Solution

  • 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.