View Single Post
  #2  
Old 05-08-2006, 05:15 AM
paaco
Discordant
 
Join Date: Jan 2005
Posts: 320
Default

If you already have a DB you want to use just go into the command prompt. Type in:

cd/mysql/bin < Hit Enter >
mysql -u root < Hit Enter >
now type drop database <dbname>; <hit enter>

That will totally delete the DB you already have so if you still want it back it up first.

now to add the new DB make sure the db you want to use is in the mysql/bin folder and type:

create database <dbname you want to use>;
source dbname.sql;
it should source in your DB now, then you just set your config.xml file to use whatever you named the db.

Last edited by paaco; 05-08-2006 at 01:20 PM..
Reply With Quote