Re: best way to wipe info

[Thimble Smith]

On Wed, May 19, 1999 at 09:08:52PM -0700, Xah Lee wrote:
> Here's the question again: What is the 'best' (i.e. proper, standard,
> scalable, expedient etc.) way to delete all info in a given database but
> keeps the schema? (in mysql)

I missed out on all of the ignorant answers, so maybe this one's
already been sniffed and and pissed on, but it's close enough to
what you're doing now that it might be preferable:

$ mysqldump --opt --nodata db-name | mysql db-name

Tim