[plug] Whats a quick way to zap a mysql database?

[Luke Dudney]

William Kenworthy wrote, On 16/09/03 21:41:

>Whats a quick way to zap a mysql database?
>
>I want to keep the schema, but truncate all the tables at once -
>truncate doesnt take a wildcard it seems!
>
>BillK
>  
>

You could dump the schema with "mysqldump -d", delete the database files 
and then rebuild the table structure from the output of mysqldump...

Cheers
Luke


_______________________________________________
plug mailing list
plug at plug.linux.org.au
http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug