Hey all, I'll mention first that I am extremely new to mysql and frankly I don't really have a clue what I am doing! I'm having a big problem with a mysql database and a wordpress installation. First, I have this error for a particular table in the database: #1016 - Can't open file: 'wp_posts.MYI' (errno: 145) When I view all tables in the database, the wp_posts.myi table says that it is "in use". Trying to use the KILL prompt doesnt stop the process. I really need to get this table, as when I perform a backup/dump i get errors when it reaches this table. Other tables dump fine, but this one has be stuck at this point for several days now. Is it possible to get this table out of there when I can't access it?? thanks, Dave
The index file of this table is corrupted. Repair this table using REPAIR TABLE command e.g. REPAIR TABLE wp_posts; Code (markup):
Hi mywasif, thanks for the reply! here is the error I get when trying to repair the table #1142 - INSERT command denied to user 'fishfinder_hints'@'82.197.131.40' for table 'wp_posts' I've been trying for a few days now to get ahold of that one table with no results. Maybe I need to access the backend of the database or something, I really have no idea! dave
anyone able to help out???? my host disabled my account, and has just now reactivated it and is at least allowing me to access files and databases. If anyone is able to help me out with this........PLEASEEEEEE!!!!! thanks...... there may be some useful backlinks involved here for those who can help me out