MySQL Forums
Forum List  »  General

Mysqldump options
Posted by: Alexandre Salomé
Date: January 25, 2020 05:07PM


I have a huge database, as following:
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

Options: ReplyQuote

Written By
Mysqldump options
January 25, 2020 05:07PM
January 25, 2020 05:10PM
January 25, 2020 07:40PM
January 25, 2020 09:06PM
January 26, 2020 10:12AM
January 27, 2020 06:29AM
January 27, 2020 12:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.