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

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

User, date Message
Written by leticiafe
4 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
4 years ago
4977 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
4 years ago
2 posts since Fri, 29 Oct 10
ok,then not problem with the Target compatibility.

Thank you
Written by ansgar
4 years ago
4977 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.