icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » PHP, MySQL » Database Won't Delete

PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >>

Closed Thread
 
LinkBack Thread Tools Search this Thread Rate Thread
Old October 3rd, 2003, 3:32 AM   #1 (permalink)
Registered User
Fresh Surpasser
 
Joined in Oct 2003
4 posts
Gave thanks: 0
Thanked 0 times
I was doing routine maintenance on my domain's backend, and I noticed a couple of databases that I wasn't using anymore. I successfully deleted the first one, but when I tried to delete the 'crescent' table, it gave me an error message. The database is completely empty, so I don't see why it wouldn't delete. Here's the error message I got from within phpmyadmin:

Account Removed
Deleted the database cherrii_crescent /usr/bin/mysqladmin: DROP DATABASE cherrii_crescent failed; error: 'Error dropping database (can't rmdir './cherrii_crescent', errno: 39)'

My domain is cherrii.net, my username is cherrii, and I'm hosted on yesenia.vivar.us. Can anyone help me with this?
Cherrii is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 3rd, 2003, 4:00 AM   #2 (permalink)
the one who was
Super #1
 
patrickb's Avatar
 
Joined in Jul 2003
Lives in Memphis
1,967 posts
Gave thanks: 0
Thanked 3 times
I think that error numer relates to an unexpected EOF. Something along the lines of file corruption probably. Email supportsurpasshosting with all the info in your original post, and they can delete the database for you...
__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org
patrickb is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 3rd, 2003, 8:31 AM   #3 (permalink)
Registered User
Super #1
 
Joined in Jul 2003
Lives in So. NJ
1,557 posts
Gave thanks: 0
Thanked 9 times
Hi, cherrii,

Would you mind adding your server to your .sig? That way we have to spend a little less time trying to figure out which server to query to help you out.

Thanks.
__________________
Dime13 | Pass17
snide is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 4th, 2003, 12:40 AM   #4 (permalink)
Registered User
Fresh Surpasser
 
Joined in Oct 2003
4 posts
Gave thanks: 0
Thanked 0 times
The only machine I know to tell you is what I've been told before, which is that my server is yesenia.vivar.us, which was the last thing I said in my original post. If there is additional information that you need, I'm afraid you'll have to tell me where to find it.

-Cherrii
Cherrii is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 4th, 2003, 12:55 AM   #5 (permalink)
CTO, Surpass Hosting
Super #1
 
Emmanuel's Avatar
 
Joined in Apr 2003
Lives in Florida
1,824 posts
Gave thanks: 10
Thanked 134 times
Cherri


what are the datebases that need to be deleted and which are the ones that don't need to be deleted.
__________________
Emmanuel :: Surpass Hosting Network Admin
http://www.SurpassHosting.com
Emmanuel is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 7th, 2003, 8:04 AM   #6 (permalink)
Registered User
Fresh Surpasser
 
Joined in Oct 2003
4 posts
Gave thanks: 0
Thanked 0 times
Meep! Sorry. I've been away from my computer for a few days and just now got back to finish resolving the issue.

The only database that needs to be deleted that I couldn't delete myself was the "crescent" table, which is cherrii_crescent. Everything else is working fine. ^_^

Thanks!
Cherrii is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On