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

Dump/Restore

User, date Message
Written by root9
5 months ago
Category: Import/Export
1 posts since Thu, 20 Feb 14
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

Written by ansgar
5 months ago
4940 posts since Fri, 07 Apr 06
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.