What caracteristics I need to enable in heidiSQL 5.1 to export?...

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!!

Nearly the same way, that should be intuitive: Right click a database > Export as SQL. Then, check drop/create options and destination file.

ok,then not problem with the Target compatibility.

Thank you

"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 */