Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Mydumper couldn't dump a database without any table #693

Closed
Suarez1024 opened this issue May 19, 2022 · 0 comments · Fixed by #694
Closed

[BUG] Mydumper couldn't dump a database without any table #693

Suarez1024 opened this issue May 19, 2022 · 0 comments · Fixed by #694
Labels

Comments

@Suarez1024
Copy link

Suarez1024 commented May 19, 2022

Describe the bug

Mydumper couldn't dump a database without any table.

To Reproduce
Command executed:

  • mydumper with all the parameters

./mydumper --host 'XXX' --port 3306 --user 'root' --password 'XXX' --outputdir 'antData3/' --verbose 3

What mydumper and myloader version has been used?

v0.12.3-1

Expected behavior
I'm sure mydumper v0.11.3 could dump a database without any tables. I think it's a bug in new version.

**Log**
** Message: 16:34:10.878: MyDumper backup version: 0.12.3-1
** Message: 16:34:10.885: Server version reported as: 5.7.25-log
** Message: 16:34:10.888: Connected to a MySQL server
** Message: 16:34:10.891: Acquiring FTWRL
** Message: 16:34:10.894: Started dump at: 2022-05-19 16:34:10
** Message: 16:34:10.896: Written master status
** Message: 16:34:10.903: Thread 1 connected using MySQL connection ID 140189
** Message: 16:34:10.913: Thread 2 connected using MySQL connection ID 140190
** Message: 16:34:10.923: Thread 3 connected using MySQL connection ID 140191
** Message: 16:34:10.933: Thread 4 connected using MySQL connection ID 140192
** Message: 16:34:10.941: Thread 3 dumping db information for `luna`
** Message: 16:34:10.941: Thread 1 dumping db information for `mao1`
** Message: 16:34:10.941: Thread 2 dumping db information for `mysql`
** Message: 16:34:10.941: Thread 4 dumping db information for `syncer_meta_schema`
** Message: 16:34:10.943: Thread 3 dumping db information for `sys`

luna is a new database without any table. This database is mentioned in the logs. However, there are no files related to this database in the dumped folder.

# ls antData3 | grep schema-create
mao1-schema-create.sql
mysql-schema-create.sql
syncer_meta_schema-schema-create.sql
sys-schema-create.sql
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| luna               |
| mao1               |
| mysql              |
| performance_schema |
| syncer_meta_schema |
| sys                |
+--------------------+
7 rows in set (0.01 sec)

mysql> use luna;
Database changed
mysql> show tables;
Empty set (0.00 sec)

@Suarez1024 Suarez1024 changed the title [BUG] [BUG] Mydumper couldn't dump a database without any table May 19, 2022
@davidducos davidducos added the bug label May 19, 2022
@davidducos davidducos linked a pull request May 19, 2022 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants