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

export error

User, date Message
Written by dgn
2 years ago
Category: General
3 posts since Sun, 07 Oct 12
Hi,
I exported my database from heidisql after that i imported another computer.But i encountered this error.
"-- Data exporting was unselected."
so my export settings wrong.I have my old computer's hdd.How can i retrive database from hdd.Is there any method for take database without *.sql (exported db/backup) file?
Written by jfalchMoney, Euro
2 years ago
406 posts since Sat, 17 Oct 09
yes. you can, in principle, just copy mysql´s data directory to the new system; this directory is specified in mysql´s configuration file (my.cnf or my.ini) in section [mysqld] value datadir= . The directory name itself is usually "data".

copy this directoy, and everythimng below it, to the new system, and make certain that the new mysql server´s my.cnf[mysqld]datadir= points to the directory where you put it.

PS why do you not want to use .sql export/import instead ? Just setting "Data" menu on Heidsql´s "table tools" / "sql export" dialog to e.g. INSERT will also export the data.
Written by dgn
2 years ago
3 posts since Sun, 07 Oct 12
Thanks for reply i retrived my old db smile.But when I export db on the db list in heidisql i make right click on the current db after that i choose "export database as sql" so this command make output *.sql format.But when i look at the this file with notepadd++
"-- Data exporting was unselected."
For this reason imported db will unsuccesfull.
How can i correct export as sql format in heidisql?
Written by kalvaro
2 years ago
595 posts since Thu, 29 Nov 07
You've already been told. Please review the dialogue options instead of just clicking "Export".
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Just do not select "No data" mode in the export dialog, but e.g. "INSERT".
Written by dgn
2 years ago
3 posts since Sun, 07 Oct 12
Thanks...
 

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