export error

[expired user #6620]'s profile image [expired user #6620] posted 11 years ago in General Permalink
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?
jfalch's profile image jfalch posted 11 years ago Permalink
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.
[expired user #6620]'s profile image [expired user #6620] posted 11 years ago Permalink
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?
kalvaro's profile image kalvaro posted 11 years ago Permalink
You've already been told. Please review the dialogue options instead of just clicking "Export".
ansgar's profile image ansgar posted 11 years ago Permalink
Just do not select "No data" mode in the export dialog, but e.g. "INSERT".
[expired user #6620]'s profile image [expired user #6620] posted 11 years ago Permalink
Thanks...

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