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

Dump/Restore

root9 posted 9 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 9 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.