Languages
[Edit]
EN

HeidiSQL - export database schema and data as SQL into operationg system clipboard

9 points
Created by:
Abul-Emery
517

In this short article, we would like to show how to export MySQL database schema with data as SQL using HeidiSQL under Windows.

Simple steps:

  1. login to MySQL Server with HeidiSQL,
  2. click mouse right button on the desired database and select: Export database as SQL,
  3. configure SQL export:
    Database(s): Create
    Table(s):    Create
    Data:        Insert
    Output:      Clipboard
  4. click the Export button.
  5. Now database schema with data is in system clipboard - you can paste it into any editor.
Export database as SQL into operating system clipboard with HeidiSQL.
Export database as SQL into operating system clipboard with HeidiSQL.
SQL export configuration in HeidiSQL.
SQL export configuration in HeidiSQL.

 

Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join