UBB.Developers Forums Community Development Programming MySQL and Server Configuration cannot access large database - online game

im having trouble accessing my database.

i have an online game pimpattack.com

and at first i could easily access the db and edit it etc.. but now when i try to access it via phpmyadmin i can login but when i try to enter the database it times out.

i have asked techs to look at my server and they said they cannot access the database via command console either.

i have tryed using a few programs here that are supposed to help in accessing a database that times out.

i need to access the database to run the game.

any help would be much appreciated, even if i can just get in to backup the database that would be good.

Thankyou in advance

Are you running the database server on your own machine? Or is a web hosting company running the server?

Something must have changed somewhere, tracking it down is the trick : login id's ?, database server settings ?

Have your techs generated an error log? What kind of errors (if any) are in there.

Check the docs on how to generate a debug log for the mysql command line client.

Mike

Log into your phpAdmin and enter the following...

REPAIR TABLE `YOUR_TABLE_NAME`

That should repair your damaged table and allow you to get back into it - I'm guessing that you are running an older version of phpAdmin such as 2.2.x (or anything PRIOR to 2.5.x)

I hope this helps


...notes, if your DB is HUGE and the server is SLOW, you may have to run that command a few times to get it back on track