MYSQL db problem

jimi_81

OSNN Senior Addict
Political Access
Joined
29 May 2002
Messages
820
This is the second time this has happened.
I have lost my db. The hosting company (ipowerweb) cannot explain why this is happening.

How can a db be deleted/removed, without having access to a control panel or the db itself. Is that even possible? Do you think it is possibly a security breach? Can an SQL server be overwhelmed to the point where db's are lost?

I have a backup of last nights data, so i am OK, but this is SUCH a pain in the ass.

any insight would be appreciated, thanks guys
 
You can lose a db in many ways, anyone with root access to the server can delete it. I would complain first, and if this is a common occurence, switch hosts.
 
Welcome to one of mysql's major flaws.

Mysql can and does totally loose databases out of the blue at random with narry a whisper as to why.

ipowerweb quite possibly genuinly dont' know why its happening.
 
thanks for the words guys.

Tech support had a look at the issue. They were telling me that some of my tables were corrupt.. and needed repairing. I repaired them all. Not sure why they were corrupt.

i read up on some mysql knowledge base articles and found a rather extensive list of why this happens. doesnt appear to be a way to fix things tho. all my database connections close when they are supposed to.. so i guess its time to get a cron job running daily to backup the db.

grrr
 
MySQL does this quite often. There are a plethora of reasons why it could happen, none of them really make any sense.

Like LordOfLa said, ipowerweb really can't know why, however if it happens often, I suggest you look for another database solution, since many of these problems can be resolved just by putting MySQL under less stress (thus having less databases, and less load).

I would suggest as alternative, take a look at PostGreSQL, if it is possible with what you need it to do.
 
and if you truly need to go "industrial" strength on your data integrity and make this a most remote possibility I would suggest moving to IBM's UDB (born out of DB2).... But there will be major re-engineering and licensing considerations.... it just depends how much you want to put in to remove this pain - I suspect the investment in this to be too much - but the pay back is pretty guaranteed.

Oracle is anothe possibility, but I know less about that so hesitate to commend it personally.

GL with the chron job ;)
 
haha, guys, i get paid 2500 a YEAR to do this site: http://www.stoneycreeksoccer.com

ipowerweb has been the host provider for us for about 5 years now. This year we totally changed the statistics program around, and now we are starting to run into db issues. I repaired all tables, despite having knowledge about how a client fails to close a table. could it be that i mixed in my amateur style query statements with my buddy's inner join and left join combo queries. is an unclosed table referring to opening a table, grabbing a result and then immediately querying another table.. with a couple more queries.. all in a loop?
thats pretty confusing.. can someone explain what a table not closing means?

thanks!!
 
Not closing a table has to do with the MySQL connection being interrupted before properly closing the connection.

MySQL should not be showing this behaviour at all. Your SQL queries should have nothing to do with this problem, as I have seen this problem even for big forums based on vBulletin. This is strictly a MySQL is under too much load, and is not writing tables to disk in time. Like many have said before me, and as have I, find a different host, or talk to ipowerweb and ask them to move your database to a different server.

There is no clear explanation, and no clear reason why. Just know that it can and will happen, and it looks like you are prepared with backups.
 

Members online

No members online now.

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.

Forum statistics

Threads
62,015
Messages
673,494
Members
5,621
Latest member
naeemsafi
Back