Working With Data
How do I save the table structure/table contents as an *.sql file
To export an SQL dump file of the table structure or contents you must first be connected a mysql host and have a database selected. Next, choose Export > MySQL Dump... from the File menu. This will bring up a dialog box where you can choose what tables you would like to export.
How do I open an *.sql file for use with my database?
To import an SQL dump file using the most recent version of Sequel Pro, connect to your MySQL host and select a database, then choose 'Import...' from the File menu. This will bring up a dialog box, select the file on your file system that you would like to import, then choose SQL from the "Format:" drop down menu and click "Open". Your database will now be updated. Click the Table refresh button if needed. Careful: Importing a *.sql file may overwrite your existing data!
Hosting Donated