Re: mysqldump

[Christian Hammers <ch@westend.com>]

Hi

> does anyone know how I could do a dump of my database ( using mysqldump) but i 
> want to leave out 1 specific table.

mysqldump x specific > save
echo "drop table specifi" | mysql x
mysqldump x > bigdump
mysql x < save
rm save

of course only if no write actions take place to the specific table.

> Clinton
bye,

 -christian-

-- 
Linux - the choice of the GNU generation.           Join the Debian Project 
                                                      http://www.debian.org 
Christian Hammers * Oberer Heidweg 35 * D-52477 Alsdorf * Tel.: 02404-25624
0AA3 E879 1D82 F59E 77A4 0096 911F 4AE6 86A1 18E6 1024D/86A118E6 1999-09-17