User, date Message
Written by siengo1971
3 years ago
Category: Import/Export
1 posts since Mon, 06 Jun 11
Hi everyone,
i use HEIDISQL v. for exporting ( as SQL) one dabatase on remote site to local and after i have to import (my PHPMYADMIN) on another domain.
Here ore my actionhs :
1) click on export voice menu
2) export database as sql
2 bis) data: no data
3) output: one big file
4) filename: domusidea and selcet the path

and click on export and i see the processing

first question :
is it necessary to activate databases create [ ] and tables create [ ] ?
is it necessary to select INSERT on select box data ??

maybe missing activation of these options are the solution of my problem ?

i don't try these yet because i'ma afraid to delete database in remote site..

Thank you

Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
In order to import that file afterwards you will need to check the "create tables" option. The "INSERT" data option will of course export rows - if you select "No data" you should not wonder why you have 0 rows, do you?

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