Languages
[Edit]
EN

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

9 points
Created by:
Abul-Emery
457

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.

 

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