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

Dump/Restore

root9 posted 10 months ago in Import/Export
Hi

If is posible to add wizard for MySQL export/import sql with this parametars:
- disable constraint (SET foreign_key_checks = 0/1;)
- disable database ( use `database_name`;)
- disable from procedure/trigger definer (DEFINER=`root`@`localhost`)

thx

ansgar posted 10 months ago
You can disable "Create database" in the export dialog, which will also leave out the "USE dbname". Foreign key checks are also disabled in the header:

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;


Only the definer cannot be suppressed.

Please login to leave a reply, or register at first.