PDA

View Full Version : how to overwrite or delete peq database


nikkisman
01-11-2010, 07:48 PM
ive been tryin to setup a server for a couple days now and i would like to start over fresh......i was wondering how i would delete my peq database so that i can install it from scratch....i tried just deleteing the files and when i sourced them when i stried to start over it said i couldnt create a new database b/c one is already created

Vampire1212
01-11-2010, 08:26 PM
Use this following MYSQL code

drop database YOURDBNAME;

That will drop the entire database allowing you to source.

trevius
01-11-2010, 10:34 PM
Or, if you use navicat, you can just right click any tables you want to have as blank and chose "Empty Table" to clear them out completely. You don't want all tables to be empty or it will mess up some things (like, don't clear out the zones table!).