WordPress.org

Forums

Database recovery error (1 post)

  1. JamieS1211
    Member
    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic