PDA

View Full Version : Starting Over & resetting the database


-brs.2-
6-25-04, 03:16 PM
How does one dump what records are in a current database, wipe it out, and start anew?

I started setting a database up, and the configuration is incorrect. So now, I'm fumbling over incorrect settings stacked on top of incorrect settings. I just want to dump it, and start over with a empty database.

Suggestions welcomed.

Bannerzap.com
6-25-04, 03:58 PM
I would go to http://phpmyadmin.powweb.com, log into your database, and just select (check box) all of the tables you want removed and then select "Drop" from the options at the bottom of the page.

BerksWebGuy
6-25-04, 04:00 PM
If you want to keep the tables...and just delete all the rows in the table...then do the same with the drop box...but just inside the table.

-brs.2-
6-25-04, 04:17 PM
Worked great!! Thanks.

tmprod
6-25-04, 06:39 PM
just a littlem side not here, next time bexk it up just incase :)

-brs.2-
6-25-04, 06:51 PM
Any suggestions as to how to back up the database??

BerksWebGuy
6-25-04, 08:44 PM
You can export your database...there are a few options (csv, sql export, etc).

There should also be backups in OPS (but don't depend on them).

Bannerzap.com
6-26-04, 12:36 AM
It is best to make your own manual backup, but so far the ones made daily by powweb and displayed for download in ops have worked well for me. :)