Yan Seiner wrote:
This is more of a MySQL question, but here goes:
I am using dspam with mysql. I'd like to clean out the dspam database
and start over. (long story, that.)
I don't want to drop the database; I want to clean out all the tokens
and start over training dspam.
Could someone clue me in?
Thanks,
--Yan
You could do:
mysql-dump --no-data db_name > dspam_db.sql
This will dump the structure of the Database, but omit the data within it.
Then drop the DB, and restore from the dump.
or
You could also use the "Truncate" command, but you will have to do this
on each table within the Database.
TRUNCATE TABLE tablename;
There aren't that many tables in a typical DSpam Database, so this
shouldn't take too long.
--Jeff Harris
