[URGENT] Someone to fix my SQL DB $50

[Sandino]

[root@ns26757 ~]# mysqlcheck --auto-repair --check --optimize --all-database
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
[root@ns26757 ~]#

No didn't do anything, there's something that happent to my server so I attempt a hard reboot, when it came back online it's like that

I'm using centos 5.5 by the way

try putting the password & username. (however you login).

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases


Also, is that table empty?

You just just try to export the table; delete the table, recreate it, and import the table data again.

(as someone said above, backup before doing so).

And also what scripts are you using that use this data base? And when did it start happening.

[narutoroot]

Nope. But your table has been corrupted. I wouldn't have enough knowledge to fix that table. If you can't find anyone to fix it for you, youll have to drop the table and create it again using your latest sql backup, if you have one.
Thats all i can think of.

[kohkindachi]

Repairing tables
.links
Error : Can't find file: 'links' (errno: 2)
error : Corrupt

I couldn't access the table at all

[bxflow]

kohki what script are you using, you keep ignoring the question,,,

[Sandino]

restart your MySQL Server.

and ^ ya he is lol kind of hard to help him

[narutoroot]

Ok try
REPAIR TABLE links USE_FRM;

[kohkindachi]

Sorry I'm abit nervous now. I'm using a custom link shortening script

I've restarted the server tons of times

[bxflow]

you probably might need to use your latest mysql back up

[kohkindachi]

Ok try
REPAIR TABLE links USE_FRM;

Table Op Msg_type Msg_text
links repair Error Can't open table
links repair error Corrupt

[SaBteCh]

I told him i can fix this..but he said he dont want to give ftp and phpmyadmin acces