[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

[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]

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^