distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

leticiafe posted 4 years ago in Import/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!!
ansgar posted 4 years ago
Nearly the same way, that should be intuitive: Right click a database > Export as SQL. Then, check drop/create options and destination file.
leticiafe posted 4 years ago
ok,then not problem with the Target compatibility.

Thank you
ansgar posted 4 years ago
"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.