mysql database

  • Status Closed
  • Budget $30 - $50 USD
  • Total Bids 16

Project Description

it may require a db admin to fine tune your mysql database to prevent corrupt tables to determine what is the issue this problem is happening to often we need a solution Reparing the table worked correctly, although I am also seeing this in the logs.

root@server2 [/var/lib/mysql]# tail -f [url removed, login to view]

130614 9:07:59 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './hoodbox_demandtest/[url removed, login to view]'; try to repair it

130614 9:07:59 [ERROR] Got an error from thread_id=30829, /home/rpmbuild/rpm-build/BUILD/[url removed, login to view]:121

130614 9:07:59 [ERROR] MySQL thread id 30829, OS thread handle 0x2abc7b855940, query id 533203 localhost hoodbox_dtest updating


FROM `qsuxbs_session`

WHERE `time` < '1371217979'

I then got the following error when repairing the next table.

Table './hoodbox_demandtest/qsuxbs_session' is marked as crashed and should be repaired SQL=INSERT INTO `qsuxbs_session` (`session_id`, `client_id`, `time`) VALUES ('96435680e46dcecbad3a46eb79b752a7', 0, '1371220782')


| Table | Op | Msg_type | Msg_text |


| hoodbox_demandtest.suxbs_session | repair | Error | Table 'hoodbox_demandtest.suxbs_session' doesn't exist |

| hoodbox_demandtest.suxbs_session | repair | status | Operation failed |


It appears that a table was deleted per the mysql error log above.


Andrew Zahn

Systems Administrator

Get free quotes for a project like this
Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online