[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysqldump


> 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


Linux - the choice of the GNU generation.           Join the Debian Project 
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

Reply to: