Re: best way to wipe info

[Sasha Pachev]

Xah Lee wrote:
> 
> Many people suggested:
> 
> > DELETE FROM tablename
> 
> Please note that my question asked for how to delete a database, not a
> table. Linux ignoramuses, please pay attention.
> 
> 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)
> 
> (Btw, I'm aware that one can delete certain files in mysql data directories
> as a solution. My question stands as it is.)
> 

Write a perl script or a C program that will first execute "show
tables", then for each table execute "delete from $table"

-- 
Sasha Pachev
http://www.sashanet.com