how to overwrite or delete peq database

nikkisman · #1 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 · #2 01-11-2010, 08:26 PM

Use this following MYSQL code

Code:

drop database YOURDBNAME;

That will drop the entire database allowing you to source.

**trevius** · #3 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!).