What caracteristics I need to enable in heidiSQL 5.1 to export?...
| User, date | Message |
|---|---|
|
Written by leticiafe
3 years ago Category: Import/Export 2 posts since Fri, 29 Oct 10 |
Hello, I´m using heidiSQL 4.0 to export all my database with: Source: (select all tables) Destination. Enable: Structure Database Create if necessary Tables Create if necessary Data Insert Target compatibility: HeidiSQL w/MySQL Server 5.1 Output: File: C:/resp_fecha.sql ¿What caracteristics I need to enable in heidiSQL 5.1? ¿How do the import? Thanks!! |
|
Written by ansgar
3 years ago 3949 posts since Fri, 07 Apr 06 |
Nearly the same way, that should be intuitive: Right click a database > Export as SQL. Then, check drop/create options and destination file. |
|
Written by leticiafe
3 years ago 2 posts since Fri, 29 Oct 10 |
ok,then not problem with the Target compatibility. Thank you |
|
Written by ansgar
3 years ago 3949 posts since Fri, 07 Apr 06 |
"Target compatibility" never worked as expected in old releases, so I removed that feature. Should not be a bigger problem on most older or newer servers as most version critical SQL is stuffed in conditional comments, for example: /*!40000 ALTER TABLE bla DISABLE KEYS */ |
|
Please login to leave a reply, or register at first. |