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.
2 options important:
Use Show FULL tables instead of show tables.
2nd column of results tell you TABLE or VIEW
For View change the drop statement to drop VIEW
option / hard code don't download VIEW data to sql backup
option / hardcode limit for insert statements. 1 row per statement is safer for some applications and servers to avoid server crash during restore.