how do I delete a database completely? [Archive]

View Full Version : how do I delete a database completely?

mambogani

7-1-03, 08:31 PM

If I want to delete the database completely off mysql02 and start again, how do I do it? I checked in OPS...is it a case of renaming the database? I am installing a forum and am doing some testing - but want to start afresh.

HalfaBee

7-1-03, 08:43 PM

You can delete all the tables using phpmyadmin or mysql-front.

HalfaBee

mambogani

7-1-03, 09:06 PM

where do I get these? :D

Elmore

7-1-03, 09:14 PM

mambogani,

You can get My SQL Front Here. (http://mysqlfront.sstienemann.de/)
and you can get PHPMyAdmin Here. (http://www.phpmyadmin.net/)

Both of these are very good for administering your MySQL Database, though mysql front is a little more secure..
:D

HalfaBee

7-1-03, 09:16 PM

mysql-front ( PC gui ) from http://mysqlfront.sstienemann.de/

phpmyadmin from www.phpmyadmin.net a server side mysql admin tool.

HalfaBee

.{TM}.

7-2-03, 11:57 AM

i use phpmyadmin and its worked out great for me.

Jade Dragon

7-2-03, 02:06 PM

If you use phpmyadmin then you must use .htaccess to secure it. Otherwise anyone with your path to the phpmyadmin folder can change things within your database.

=)
Jade