dont know if this is right forum topic about mysql..but anyway
Doom
11:59 pm on Mar 1, 2004 (gmt 0)
when i run mysql_install_db , it will create new tables..how to remove the old ones?
Doom
12:25 am on Mar 2, 2004 (gmt 0)
i found there are in /var/lib/mysql
should i remove the whole mysql dir to get rid of it?
hyperbole
12:45 am on Mar 3, 2004 (gmt 0)
It's safer to use the DELETE <table> or TRUNCATE <tabel> command.
DELETE <table> will remove the entire table from the DB. TRUNCATE <table> will remove all the records from a table and leave the structure of the table in tack.
