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?
export error
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.
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.
Thanks for reply i retrived my old db .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?
"-- Data exporting was unselected."
For this reason imported db will unsuccesfull.
How can i correct export as sql format in heidisql?
Please login to leave a reply, or register at first.