[MySQL] Don't remove before import get success.

[expired user #7681]'s profile image [expired user #7681] posted 9 years ago in Import/Export Permalink
I'll use as example a user FUNCTION.

When you import from external DB that you don't have the SHOW CREATE FUNCTION privilegies (to receive `Create Function` column), HSQL will first remove my current FUNCTION and will fail on import. So I loses my current FUNCTION for nothing.

Example:

EXTERNAL DB SCHEMA:
- table1
- table2
- table3
- MYFUNC (without privilegies to read CREATE)

CURRENT LOCAL DB SCHEMA:
- table1
- table2
- table3
- MYFUNC

AFTER IMPORT FROM EXTERNAL DB:
- table1
- table2
- table3

LOG:
[Localhost] DROP TABLE IF EXISTS `table1`;
[Localhost] CREATE TABLE IF NOT EXISTS `table1` ( ... ) ...;

[Localhost] DROP TABLE IF EXISTS `table2`;
[Localhost] CREATE TABLE IF NOT EXISTS `table2` ( ... ) ...;

[Localhost] DROP TABLE IF EXISTS `table3`;
[Localhost] CREATE TABLE IF NOT EXISTS `table3` ( ... ) ...;

[Localhost] DROP FUNCTION IF EXISTS `MYFUNC`; <-- NOOOO!!!
[External] SHOW CREATE FUNCTION `externaldb`.`MYFUNC`;
[Localhost] ;
[Localhost] Erro SQL (1065): Query was empty

HeidiSQL: r4822
MYSQL: 5.6.17

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