[URGENT] Someone to fix my SQL DB $50

[kohkindachi]

My server has screwed up, and one of my impt tables in mysql is showing
MySQL said:
#1017 - Can't find file: 'links' (errno: 2)

SQL show index from `links` failed : Can't find file: 'links' (errno: 2)



I hope my DB info is still there. I'm using OVH and webmin. If someone can fic my DB, i'll pay him $50. PM me your msn asap.

kohkindachi Reviewed by kohkindachi on 6th Jun 2010. [URGENT] Someone to fix my SQL DB $50 My server has screwed up, and one of my impt tables in mysql is showing MySQL said: #1017 - Can't find file: 'links' (errno: 2) SQL show index from `links` failed : Can't find file: 'links' (errno: 2) I hope my DB info is still there. I'm using OVH and webmin. If someone can fic my DB, i'll pay him $50. PM me your msn asap. Rating: 5

[Sandino]

Try running this in SSH -> " mysqlcheck --auto-repair --check --optimize --all-databases "

Also, can you post more information such as, the software you are using, when it started, and if you did anything to cause it? (such as installing a new mod, accidental edited something, etc).

[kohkindachi]

[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

[narutoroot]

Try REPAIR TABLE links;

[kohkindachi]

Thanks but it gives me this

File 'links.MYD' not found (Errcode...
Can't find file: 'links' (errno: 2)
Corrupt

[narutoroot]

If all else fails you could try

DROP IF EXISTS links;
CREATE TABLE links (
links INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (links)
);

unless you have important shit in the table "links", and doing this could be dangerous

oh make backup first.

[desiboy]

check the log files
in /var/log
it will have more info on the errors.

[kohkindachi]

narutoroot, will that remove everything from the table? or there's a chance it'll be back?

[narutoroot]

That will remove the table and everything in it, that's why I suggested to make a backup accordingly before running it^

[kohkindachi]

That means nthing will be retrieved?
I'm looking for ways to have it back first