export error
| User, date | Message |
|---|---|
|
Written by dgn
7 months 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 jfalch
7 months ago 222 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
7 months ago 3 posts since Sun, 07 Oct 12 |
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? |
|
Written by kalvaro
7 months ago 440 posts since Thu, 29 Nov 07 |
You've already been told. Please review the dialogue options instead of just clicking "Export". |
|
Written by ansgar
7 months ago 3949 posts since Fri, 07 Apr 06 |
Just do not select "No data" mode in the export dialog, but e.g. "INSERT". |
|
Written by dgn
7 months ago 3 posts since Sun, 07 Oct 12 |
Thanks... |
|
Please login to leave a reply, or register at first. |