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

TRANSFER DB CONTENT

aij07 posted 2 years ago in General
Hello!

I am really new with HeidiSQL. smile

I am not sure if this issue has been asked/solved already but just wanted to know how will I export/copy the db and tbl structure from one PC to another PC.

I really don't know how to do it. Aha.

Thanks for the answer. :)
ansgar posted 2 years ago
Tools > Export database as SQL

Then, select "Output": "Server [your 2nd PC]".
aij07 posted 2 years ago
OK. I'll keep you guys posted on my progress.

Thanks anse! :)
aij07 posted 2 years ago
Hello again!

And now I am able to export my DB, I rather chose 'one big file' on the selection.

How will I import it now on another PC?

Thanks. :)
aij07 posted 2 years ago
Aha. I got it!

Here's how I did it (Please advise me if this is not the proper way of doing it).

EXPORTING: Tools -> Export database as SQL -> SQL Export Tab -> Output: One big file, Filename: etc..
NOTE: Check Database(s) and Table(s) Drop and Create


IMPORTING: Tools -> Load SQL File Then Execute.

:D
ansgar posted 2 years ago
Exactly

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