Error: unable to start mysql 130207 5:33:16 /usr/sbin/mysqld: Can’t open file: ‘sends.MYI’. (errno: 145)

Posted on Updated on

MySQL crashes frequently,  Getting error while starting the service “No mysqld pid file found. Looked for /var/lib/mysql/server.910mall.jp.pid.” .  It is because of  table crash. repair crashed tables using below commands.

Engine : MyISM

# repair the tables
root@server [/var/lib/mysql]# myisamchk -r */*.MYI
- recovering (with sort) MyISAM-table 'DB_wrdp1/wp_post2cat.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------
- recovering (with keycache) MyISAM-table 'DB_wrdp1/wp_postmeta.MYI'
Data records: 0

---------
- recovering (with sort) MyISAM-table 'DB_wrdp1/wp_posts.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2

---------- recovering (with sort) MyISAM-table 'DB_wrdp1/wp_usermeta.MYI'

Data records: 2
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

# Start Mysql
root@server [/var/lib/mysql]# /etc/init.d/mysql start
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s