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
[MySQL] Don't remove before import get success.
Please login to leave a reply, or register at first.