View Full Version : Deleting Database Files
jacksmack
2-13-04, 05:15 AM
How do you delete files stored in your sql database? I've done it before, for example removing all of the openchat database files and retaining the phpboard files. But somehow I have forgotten how to do this.
Thanks.
Do you mean, how do you remove database tables?
If so, then in whatever front end to MySQL you use, the command is
DROP TABLE your_tablename
execute this for each table you want to remove. There is probably a menu option in the GUI you use, but this SQL command widd do the same for you.
jacksmack
2-13-04, 01:54 PM
thank you
mitchind
2-13-04, 02:29 PM
It's very simple in the phpMyAdmin frontend.
Click on your Database, and at the bottom of the table list, "Select All" and then choose Drop from the pull-down list. Or you can check only the tables you want deleted.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.