Dump/Restore

1 posts
[expired user #7800]'s profile image [expired user #7800] posted 10 years ago in Import/Export Permalink
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

10146 posts
ansgar's profile image ansgar posted 10 years ago Permalink
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.