MySQL DELETE all but specific items or records howto
DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('user@hotmail.com','another@hotmail.com')
The above is an example of specific records you type out, but you could also base it on a subquery.........
Delete all comments from wordpress (in case of extreme SPAM)
*Note this will delete all comments indiscriminately.
DELETE FROM `wp_comments`
To delete all but save specific comments based on "author e-mail use the following". Add more e-mails below in the same format if you have more.
DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('user@hotmail.com','another@hotmail.com')........
ERROR! MySQL manager or server PID file could not be found! ERROR! Manager of pid-file quit without updating file.
I found the cause of this issue was from all the diskspace being used but clearing it was not enough. Iguess the tables became inconsistent when space ran out and myisamchk is what fixed the rest.
service mysqld restart
ERROR! MySQL manager or server PID file could not be found!
....................................................................................... ERROR! Manager of pid-file quit without updating file.
se........