XF 1.1 dump backup with embpty seach index table

[xml]

my database size is 8 GIB and search index table takes almost 5 GIB wich might take long time when restoring the dump file

what would be the comandline to dump a backup of the whole database with empty search index table?

 

[Jake Bunce]

http://stackoverflow.com/questions/425158/skip-certain-tables-with-mysqldump

 

[xml]

http://stackoverflow.com/questions/425158/skip-certain-tables-with-mysqldump

Hello Jake

that command line will dump a backup without the search index table which will prevent xenforo script to function correctly after restoration because of the missing xf_search_index. what I had in mind is a dump backup including empty search index table like in a fresh install

 

[Jake Bunce]

I don't see anything like that:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

There is the --no-data option, but it doesn't let you name specific tables:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_no-data

 

[xml]

If there is no such comand line can do that then I have to create xf_serach_index manually after restoration or import the table from another fresh install xenforo with empty xf_serach_index which is somthing easy to do.

Thank you Jake