Received this error today ERROR 144 (HY000) at line 1 Table ‘./wordpress/wp_options’ on one of my WordPress installations after trying to restart MySQL. This is how I fixed it.
This is the error I received when running
# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
# ERROR 144 (HY000) at line 1: Table './wordpress/wp_options' is marked as crashed and last (automatic?) repair failed
It was showing one of my WordPress tables was corrupted. Don’t panic though, there is an easy way to resolve this. Run the following command myisamchk -r /var/lib/mysql/MyWordPress_db/wp_options replacing the pathname with your path name. If successful you should see the following.
# myisamchk -r /var/lib/mysql/MyWordPress_db/wp_options
- recovering (with sort) MyISAM-table 'wp_options'
Data records: 253
- Fixing index 1
- Fixing index 2
Data records: 348
Restart MySQL again, you will see the following output:
# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Hit your wordpress page again in your browser and everything will be working fine.
Great and simple solution. Thanks for the help.
Thanks for this work around, saved my night from lots of headache, cheers!
Thanks a lot, you are my hero