distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL Export !!!! Importent

User, date Message
Written by Handas96
1 year ago
Category: Import/Export
1 posts since Mon, 10 Jun 13
I am new here and have a problem with heideSQL. I made a Database with HeidSQL on my PC but i need it on a other PC. What did i have to export.Please i need fast help

Sorry for my bad English

Written by jfalchMoney, Euro
1 year ago
380 posts since Sat, 17 Oct 09
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)

then
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.
Written by jfalchMoney, Euro
1 year ago
380 posts since Sat, 17 Oct 09
PS: afterwards, to see newly created datebase, click into the tree on the left, and press F5.
 

Please login to leave a reply, or register at first.