Simple error

[devarioj]

My Database has a error in one of the guest_info column.

but I set up my site so long ago i forgor what the name of the Database is. Im sure I can remember the password, but I need the name to try and fix the column that is throwing errors.

I know I had to define it during set up...can anyone tell me where in my vshare i can find the hardcoded value of my Database name?

My site has been down for a week now...any help will do

[hostonnet]

Do you need your databse name using the vShare site?
you can see all the database details in include/config.php

[devarioj]

Thank you!!!!!!!!!!!!!!!

[devarioj]

DANG...i got the name now, but I need this password...the new 2.6 has it encrypted now...do you guys know what the hash is ? or what I can use to reverse eng. it?

[buyscripts]

In config.php you can see the password also.

Or

Try to create the new user and password and add it your database.

Edit config.php and add new details

[devarioj]

The password looks encrypted..although it's not long, it just looks like jibberish...ill see though, thanks!

[devarioj]

Thanks for all the help guys, i got the info that I needed. However i am still in a bind... I am getting this error whenever I click on a video

ERROR: Unable to execute query

SELECT * FROM guest_info WHERE guest_ip=xx.xx.xxx.xxx' AND log_date='25-02-08'
Can't open file: 'guest_info.MYI' (errno: 145)

after looking around this internet I have found that this means that the guest_info table is corrupted and needs to be repaired. i found a repair command for mysql at the command prompt but it seems to not have worked as this error still comes up even after a hard power cycle to the server.

Any ideas?

the command I used was

mysql> repair table guest_info

it just sat there and did nothing, it didn't even give me a prompt line back nor did it give me a confirmation...

[devarioj]

Ok guys I got this issue sorted.

the table "guest_info.MYI" had somehow gotten corrupted.

in order to fix this I went to my server and connected to it VIA SSH

then logged on as the ADMIN.

this can be done by typing "su" and then entering your admin password when prompted (after logging in as a regular user)

Then I logged into mySQL
mysql -u admin -p databasenamehere
then entered the password when prompted
Then I moved to the folder / directory on my System that housed the mysql database and ran this command

myisamchk --recover --quick guest_info USE_FRM
Caution
Do not use USE_FRM if your table was created by a different version of the MySQL server than the one you are currently running. Doing so risks the loss of all rows in the table. It is particularly dangerous to use USE_FRM after the server returns this message: