How to backup (export) MySQL database using HeidiSQL

do not use more than one "!" in post titles.

in heidisql:
right click on database in tree on the left.
select "Export database as SQL"
in the dialog, on the right select
Database(s) [x] Create box
Table(s) [x] Create box
Data: select INSERT
Output: select One big file
FileName: click on small disk symbol at right edge to select the name and location (path) where output file is to be stored
click "Export" button (lower right)

transfer output file to new PC
start heidisql
select from Menu "Tools" / "Load SQL file…"
in open dialog, select the transferred .sql file
after file has loadled into the upper pane, press F9

that should be it.

By vichhaiy Posted in DB, WEP

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s