Xah Lee wrote:
Many people suggested:
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"
13 messages in com.mysql.lists.mysqlRe: best way to wipe info
