Mysqldump options

[Alexandre Salomé]

Hello!


I have a huge database, as following:
MY_DB
tab1 - 10 mb
tab2 - 20 mb
tab3 - 200 mb
tab4 - 11.2 GB

I use the MySQLDUMP to perform my backup:

"mysqldump.exe -h localhost -u MY_USER -pMY_PASSWORD MY_DB > C:\bkpdumpMySQL.sql 2> C:\erro.txt"

Due the size, I would like to know if there is a option to perform backup to store of all data from tab1 tab2, tab3, tab4, but, for tab5, the backup store only the data table structure (no data).



(I tried the option "--ignore-table tab5", but it was not work as I thinked)

Thank you in advance for all helps