Unable to Export Full SQL (Structure + Data) in Toad Edge

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.

Hi,
If you're trying to back up your full MySQL database, then Toad Edge allows you to backup and restore databases by internally using mysqldump utility.

I believe mysqldump allows similar options during backup creation.

More information can be found in our backup/restore feature in our user guide.