Title: Database recovery error Last modified: August 21, 2016 --- # Database recovery error * [JamieS1211](https://wordpress.org/support/users/jamies1211/) * (@jamies1211) * [12 years, 1 month ago](https://wordpress.org/support/topic/database-recovery-error/) * Hi, I have been using wordpress for about 1 year now, due to a hard drive failure my linux installation we ruined and I couldn’t boot the system to back up any of my files etc. Fortunately on a second (graphical) installation I was able to copy and back up all of the database files from the mysql database and all the wordpress files from the www directory. Armed with a brand new SSD I reinstalled linux, got the same version of mysql (5.5). I stopped the mysql server, replaced all the files and set them to the mysql user and then rebooted the mysql database. I am faced with this when I start and restart. * ``` root@Xeon:/home/mc# service mysql restart [ ok ] Stopping MySQL database server: mysqld. [ ok ] Starting MySQL database server: mysqld .. [info] Checking for tables which need an upgrade, are corrupt or were not closed cleanly.. root@Xeon:/home/mc# ERROR 1017 (HY000) at line 1: Can't find file: 'wordpress_usermeta' (errno: 2) ERROR 1017 (HY000) at line 1: Can't find file: 'wordpress_users' (errno: 2) ``` * Despite this the wordpress_users.frm and wordpress_usermeta.frm files are both there. I have tried a countless number of different recommended things such as“ mysqlcheck -u root -p –auto-repair –all-databases” however when I run this command my output is this. * ``` wordpress.wordpress_usermeta Error : Can't find file: 'wordpress_usermeta' (errno: 2) status : Operation failed wordpress.wordpress_users Error : Can't find file: 'wordpress_users' (errno: 2) status : Operation failed wordpress.wp_bp_activity Error : Table 'wordpress.wp_bp_activity' doesn't exist status : Operation failed wordpress.wp_bp_activity_meta Error : Table 'wordpress.wp_bp_activity_meta' doesn't exist status : Operation failed wordpress.wp_bp_notifications Error : Table 'wordpress.wp_bp_notifications' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_data Error : Table 'wordpress.wp_bp_xprofile_data' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_fields Error : Table 'wordpress.wp_bp_xprofile_fields' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_groups Error : Table 'wordpress.wp_bp_xprofile_groups' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_meta Error : Table 'wordpress.wp_bp_xprofile_meta' doesn't exist status : Operation failed wordpress.wp_bpspro_login_security Error : Table 'wordpress.wp_bpspro_login_security' doesn't exist status : Operation failed wordpress.wp_bpspro_seclog_ignore Error : Table 'wordpress.wp_bpspro_seclog_ignore' doesn't exist status : Operation failed wordpress.wp_commentmeta OK wordpress.wp_comments OK wordpress.wp_easy_captcha_sessions Error : Table 'wordpress.wp_easy_captcha_sessions' doesn't exist status : Operation failed wordpress.wp_forum_forums Error : Table 'wordpress.wp_forum_forums' doesn't exist status : Operation failed wordpress.wp_forum_groups Error : Table 'wordpress.wp_forum_groups' doesn't exist status : Operation failed wordpress.wp_forum_posts OK wordpress.wp_forum_reputation_posts Error : Table 'wordpress.wp_forum_reputation_posts' doesn't exist status : Operation failed wordpress.wp_forum_threads OK wordpress.wp_forum_usergroup2user Error : Table 'wordpress.wp_forum_usergroup2user' doesn't exist status : Operation failed wordpress.wp_forum_usergroups Error : Table 'wordpress.wp_forum_usergroups' doesn't exist status : Operation failed wordpress.wp_links OK wordpress.wp_login_redirects Error : Table 'wordpress.wp_login_redirects' doesn't exist status : Operation failed wordpress.wp_mca_common Error : Table 'wordpress.wp_mca_common' doesn't exist status : Operation failed wordpress.wp_options OK wordpress.wp_plugin_minecraft_server_info Error : Table 'wordpress.wp_plugin_minecraft_server_info' doesn't exist status : Operation failed wordpress.wp_pollsa Error : Table 'wordpress.wp_pollsa' doesn't exist status : Operation failed wordpress.wp_pollsip Error : Table 'wordpress.wp_pollsip' doesn't exist status : Operation failed wordpress.wp_pollsq Error : Table 'wordpress.wp_pollsq' doesn't exist status : Operation failed wordpress.wp_postmeta OK wordpress.wp_posts OK wordpress.wp_term_relationships OK wordpress.wp_term_taxonomy OK wordpress.wp_terms OK wordpress.wp_usermeta OK wordpress.wp_users OK wordpress.wp_wpbb_categories Error : Table 'wordpress.wp_wpbb_categories' doesn't exist status : Operation failed wordpress.wp_wpbb_messages Error : Table 'wordpress.wp_wpbb_messages' doesn't exist status : Operation failed wordpress.wp_wpbb_posts Error : Table 'wordpress.wp_wpbb_posts' doesn't exist status : Operation failed wordpress.wp_wpbb_topics Error : Table 'wordpress.wp_wpbb_topics' doesn't exist status : Operation failed wordpress.wp_wpbb_topics_unread Error : Table 'wordpress.wp_wpbb_topics_unread' doesn't exist status : Operation failed Repairing tables survivalgames.sg_gamestats Error : Table 'survivalgames.sg_gamestats' doesn't exist status : Operation failed survivalgames.sg_playerstats Error : Table 'survivalgames.sg_playerstats' doesn't exist status : Operation failed wordpress.wordpress_usermeta Error : Can't find file: 'wordpress_usermeta' (errno: 2) status : Operation failed wordpress.wordpress_users Error : Can't find file: 'wordpress_users' (errno: 2) status : Operation failed wordpress.wp_bp_activity Error : Table 'wordpress.wp_bp_activity' doesn't exist status : Operation failed wordpress.wp_bp_activity_meta Error : Table 'wordpress.wp_bp_activity_meta' doesn't exist status : Operation failed wordpress.wp_bp_notifications Error : Table 'wordpress.wp_bp_notifications' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_data Error : Table 'wordpress.wp_bp_xprofile_data' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_fields Error : Table 'wordpress.wp_bp_xprofile_fields' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_groups Error : Table 'wordpress.wp_bp_xprofile_groups' doesn't exist status : Operation failed wordpress.wp_bp_xprofile_meta Error : Table 'wordpress.wp_bp_xprofile_meta' doesn't exist status : Operation failed wordpress.wp_bpspro_login_security Error : Table 'wordpress.wp_bpspro_login_security' doesn't exist status : Operation failed wordpress.wp_bpspro_seclog_ignore Error : Table 'wordpress.wp_bpspro_seclog_ignore' doesn't exist status : Operation failed wordpress.wp_easy_captcha_sessions Error : Table 'wordpress.wp_easy_captcha_sessions' doesn't exist status : Operation failed wordpress.wp_forum_forums Error : Table 'wordpress.wp_forum_forums' doesn't exist status : Operation failed wordpress.wp_forum_groups Error : Table 'wordpress.wp_forum_groups' doesn't exist status : Operation failed wordpress.wp_forum_reputation_posts Error : Table 'wordpress.wp_forum_reputation_posts' doesn't exist status : Operation failed wordpress.wp_forum_usergroup2user Error : Table 'wordpress.wp_forum_usergroup2user' doesn't exist status : Operation failed wordpress.wp_forum_usergroups Error : Table 'wordpress.wp_forum_usergroups' doesn't exist status : Operation failed wordpress.wp_login_redirects Error : Table 'wordpress.wp_login_redirects' doesn't exist status : Operation failed wordpress.wp_mca_common Error : Table 'wordpress.wp_mca_common' doesn't exist status : Operation failed wordpress.wp_plugin_minecraft_server_info Error : Table 'wordpress.wp_plugin_minecraft_server_info' doesn't exist status : Operation failed wordpress.wp_pollsa Error : Table 'wordpress.wp_pollsa' doesn't exist status : Operation failed wordpress.wp_pollsip Error : Table 'wordpress.wp_pollsip' doesn't exist status : Operation failed wordpress.wp_pollsq Error : Table 'wordpress.wp_pollsq' doesn't exist status : Operation failed wordpress.wp_wpbb_categories Error : Table 'wordpress.wp_wpbb_categories' doesn't exist status : Operation failed wordpress.wp_wpbb_messages Error : Table 'wordpress.wp_wpbb_messages' doesn't exist status : Operation failed wordpress.wp_wpbb_posts Error : Table 'wordpress.wp_wpbb_posts' doesn't exist status : Operation failed wordpress.wp_wpbb_topics Error : Table 'wordpress.wp_wpbb_topics' doesn't exist status : Operation failed wordpress.wp_wpbb_topics_unread Error : Table 'wordpress.wp_wpbb_topics_unread' doesn't exist status : Operation failed ``` * This suggests that none of the files are being located even when they are present. I have also changed file permissions to 777 and they do belong to the mysql user on my server and the files in the www directory have now been changed to 777 in a hopeful attempt to. What should I do? is there some way to export database files into a wordpress file to import into a fresh wordpress install as I have done that before? Any and all help is appreciated. Thanks. Viewing 1 replies (of 1 total) * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 1 month ago](https://wordpress.org/support/topic/database-recovery-error/#post-4665672) * [https://wordpress.org/support/topic/permalinks-changing-but-still-404?replies=1](https://wordpress.org/support/topic/permalinks-changing-but-still-404?replies=1) Viewing 1 replies (of 1 total) The topic ‘Database recovery error’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [file](https://wordpress.org/support/topic-tag/file/) * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * [sql](https://wordpress.org/support/topic-tag/sql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 1 reply * 2 participants * Last reply from: [esmi](https://wordpress.org/support/users/esmi/) * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/database-recovery-error/#post-4665672) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics