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

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:
   Copy

   xxxxxxxxxx

    

   1

   Database(s): Create

   2

   Table(s):    Create

   3

   Data:        Insert

   4

   Output:      Clipboard
4. click the Export button.
5. Now database schema with data is in system clipboard - you can paste it into any editor.