MySQL:: backup entire databse but with selected tables structure only using mysqldump
 

Hi guys,

I have been using mysqldump to backup my entire database but recently I need to backup this particular database but for one of its table, I just need the structure. That table holds temp data and its huge! (3GB+)

Initially I used --ignore-table=db_name.tbl_name but that totally ignore the table.

There's an option which does not write any rows informations from the table, and that is --no-data, -d but it doesn't seem to accept values to specify which tables...

currently my statement is as such

mysqldump -uxxx -pyyy -B -opt database | gzip -9 > file.sql.gz

How can I use --no-data, -d within the same line so that I can backup the entire dB with the rows information but yet just only backup the structure for one of the table?

thanks guys!

Browse to zmanda.com and check out their mysql-zrm backup solution which is free for MySQL. It gives you the options to select and configure backups with the ability to select distinct databases and tables, etc.