Hello,
I’m using Toad Edge to export my MySQL database, but I’m running into a limitation with the SQL export options.
When I try to export a table or database, the only available options are:
- INSERT statements
*or MERGE statements
There is no option to include:
- DROP TABLE IF EXISTS
- CREATE TABLE
- LOCK TABLES
- CREATE DATABASE IF NOT EXISTS
- or any other structural statements
- CREATE SCHEMAS
Is there a way within Toad Edge to export both the structure and data together in one .sql file, including DROP TABLE, CREATE TABLE, and related options? and create schemas? If so, could you please guide me on how to do this?
Thank you for your assistance.