homepage Welcome to WebmasterWorld Guest from 54.167.174.90
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
PHPMyAdmin ... deleting a database?
JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 3:59 pm on Apr 15, 2005 (gmt 0)

I just want to delete a test database that I made, thats it. There is no upfront obvious way of doing this from my pov so thats why I'm asking.

 

jatar_k

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 4:21 pm on Apr 15, 2005 (gmt 0)

doesn't it have a way for entering straight sql command?

DROP DATABASE [dev.mysql.com] <dbname>

numbrel

10+ Year Member



 
Msg#: 7806 posted 6:44 pm on Apr 15, 2005 (gmt 0)

in phpMyAdmin:

chose the database you want on the left side.

It should come up in the main area under four tabs that say "Structure, SQL, Export, Search, Query"

Put a check in the checkbox next to the database name.
under that area is a list box that defaults to "With Selected:"

Choose Drop from the list and click the Yes button to confirm.

JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 10:31 pm on Apr 15, 2005 (gmt 0)

DROP DATABASE <dbname> not allowed...

There is no checkbox ... there is no "list" of databases except in the left frame and it's a dropdown menu.

dvduval

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 7806 posted 11:22 pm on Apr 15, 2005 (gmt 0)

Do you have root access to the server?
You may not have permission to do this.

mack

WebmasterWorld Administrator mack us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 11:27 pm on Apr 15, 2005 (gmt 0)

Select the database name from the drop down list... The database will then appear in the main page.

Go to the bottom of the list of tables and you will see a link saying "select all" click this and a tick will appear in the checkbox next to each table. There will be a drop down list at the very botton of the list of tables. From there select drop.

This will then brop all tables from your database. Click reload mysql from th enext page and click home. Now select your dataase from the list (at the left) again. It will again open in the main window, but this time there will be no tables. There should be a link "drop database [databasename]" If you click this your db will be removed. In some versiond of phpmyadmin it will ask you to confirm.

I am assuming you have enough permissions to remove it, because you created it.

Mack.

JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 12:26 am on Apr 16, 2005 (gmt 0)

Shared hosting, no root access...

Nothing says drop database and I followed your directions exactly.

phpMyAdmin 2.6.1-rc1
MySQL 4.0.23-standard

mack

WebmasterWorld Administrator mack us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 1:00 am on Apr 16, 2005 (gmt 0)

On that vesion you shoudl have tabs at the top...

When you click on your databae from the left menu you should see...

¦Structure¦ ¦SQL¦ ¦Export¦ ¦Search¦ ¦Query¦ ¦Operations¦ ¦Drop¦

This will appear right above your other options.
Click drop and it will ask you to confirm.

The word drop should appear in red.

Hope this helps.

Mack.

JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 1:37 am on Apr 16, 2005 (gmt 0)

Drop only shows when I'm inside of a table or deeper. I've also got cpanel 9 and I'm on a shared server if that helps.

mack

WebmasterWorld Administrator mack us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 2:08 am on Apr 16, 2005 (gmt 0)

It is possible your host may have made modifications to phpmyadmin to disable certain features.

What I find is when I drop the tables.. then go back and view the database again in main window, the drop opron apears as a tab right above the db information area.

Mack.

JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 11:21 pm on Apr 17, 2005 (gmt 0)

I can create but not delete my own DBs...why do all my hosts have to be amatuers?

Web Design...check.
Web Development ... working on.
Web Hosting ... to do.

>__>

olwen

10+ Year Member



 
Msg#: 7806 posted 12:31 am on Apr 18, 2005 (gmt 0)

On my shared hosting in Cpanel under "MySQL databases" is a link called "Manage Mysql"
I can delete databases there.

JAB Creations

WebmasterWorld Senior Member jab_creations us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 7806 posted 4:50 am on Apr 18, 2005 (gmt 0)

This DB I can't delete *ONLY* shows up in PHPMyAdmin.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved