Empty database is not created

[tsolodov]

Hi,

Here is scenario:

DB EMPTY_DB without any tables.

mydumper 0.9.3, built against MySQL 5.6.21-70.1

mydumper --regex '^(?!(mysql))' --outputdir=/mnt/PATH/
--build-empty-files
-G -E -R --less-locking
--logfile=/tmp/dump.log
--tz-utc
--threads=20
--verbose=4
-u USER -p XXX -h localhost

./myloader -t 10 --verbose=4 -u XXX -h localhost -p XXX -d /mnt/PATH/

I do have a file in /mnt/PATH:

CREATE DATABASE EMPTY_DB /*!40100 DEFAULT CHARACTER SET latin1 */;

but it was not processed by myloader

[maxbube]

Hi @tsolodov , that is expected as myloader only creates schemas when restoring a table, so if there is not any table then no schema.

I will review how hard could be to change this behavior.

[tsolodov]

Thanks for reply!

[jynus]

I added here how this can lead to an outage (sadly, not theoretical) https://bugs.launchpad.net/mydumper/+bug/1558164 At the very least, adding a warning on dump would be nice if expected behavior.

[dongdongvs6]

meet the problem too, is there any solution?

[davidducos]

I reviewed the code, and it is checking on each table creation if the database exists which might not be the best way of doing this.
I think that we should have a stage of schema creation and then another stage of table creation. If we implement like this, we are going to be able to fix this issue.

[davidducos]

#403 imports empty databases