Tag Archives | mysql

ERROR 144 at line 1 Table

ERROR 144 (HY000) at line 1: Table ‘./wordpress/wp_options’ – WordPress MySQL

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

Continue Reading 4
Copyright David Hill

Powered by WordPress. Designed by Woo Themes