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.

Sign up for GitHub

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

Jump to bottom

option to not download data from VIEWS. Separate insert statements limit config #15

Open
samsong opened this issue Feb 6, 2020 · 0 comments
Open

option to not download data from VIEWS. Separate insert statements limit config #15

samsong opened this issue Feb 6, 2020 · 0 comments

Comments

@samsong
Copy link

samsong commented Feb 6, 2020

2 options important:

  1. Use Show FULL tables instead of show tables.
    2nd column of results tell you TABLE or VIEW

  2. For View change the drop statement to drop VIEW

  3. option / hard code don't download VIEW data to sql backup

  4. option / hardcode limit for insert statements. 1 row per statement is safer for some applications and servers to avoid server crash during restore.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@samsong