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

Support wildcard table structure-only dumps #28

Open
bomoko opened this issue Nov 10, 2021 · 3 comments
Open

Support wildcard table structure-only dumps #28

bomoko opened this issue Nov 10, 2021 · 3 comments

Comments

@bomoko
Copy link
Collaborator

bomoko commented Nov 10, 2021

Drush's sql-sync has the ability to exclude tables based on patterns.

A new feature that could, for example, all tables with the structure cache_* is required for lagoon-sync to have parity here.

@seanhamlin
Copy link

This feature has been requested by a customer, basically the same functionality as the drush command, so structure only on a table pattern.

@seanhamlin seanhamlin changed the title Support wildcard table exclusions Support wildcard table structure-only dumps Oct 11, 2022
@timclifford
Copy link
Contributor

timclifford commented Oct 25, 2022

@seanhamlin so we are talking about replicating the structure-tables-list that drush supports? essentially returns the structure, but no data?

Do we want to expand on this issue and include a --no-data option as well?https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_no-data

@seanhamlin
Copy link

seanhamlin commented Nov 8, 2022

Correct, an example use case is to do structure only (so skip the data) for tables that match

  • cache
  • cache_%
  • watchdog

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants