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] —trigger not dumping triggers with —no-schema and —no-data #665

Closed
aloks2019 opened this issue May 4, 2022 · 0 comments · Fixed by #666
Closed

[BUG] —trigger not dumping triggers with —no-schema and —no-data #665

aloks2019 opened this issue May 4, 2022 · 0 comments · Fixed by #666
Labels

Comments

@aloks2019
Copy link

aloks2019 commented May 4, 2022

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Command executed:

  • mydumper with all the parameters
    mydumper
    —triggers
    —no-data
    —no-schemas
    -o
    -L trigger_dump.log

What mydumper and myloader version has been used? 0.12.3

Expected behavior
Triggers should get dumped.

Environment (please complete the following information):

  • OS version: RHEL7
  • MyDumper version:0.12.3

Additional context
I understand that in mydumper, I can take dump of triggers along with schema and data. This dump can be restored using myloader, but I am not sure if that would cause any issue while data restore using myloader. Currently I am following:

  1. Take dump with data without trigger
  2. Take dump with trigger without data
  3. Restore data dump created in step1
  4. Restore trigger dump created in step2
    What sequence myloader follows while restore?
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