WordPress.org

Ready to get started?Download WordPress

Forums

Missing Tables (2 posts)

  1. daverice
    Member
    Posted 1 year ago #

    Hi, I'm trying to reapir a wordpress installation (not one I originally set up), and am getting the following errors when trying to use the automated repair:

    The wp_users table is okay.
    
    The wp_usermeta table is okay.
    
    The wp_posts table is not okay. It is reporting the following error: Table 'database_wrd45.wp_posts' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_posts table. Error: Table 'database_wrd45.wp_posts' doesn't exist
    
    The wp_comments table is not okay. It is reporting the following error: Table 'database_wrd45.wp_comments' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_comments table. Error: Table 'database_wrd45.wp_comments' doesn't exist
    
    The wp_links table is not okay. It is reporting the following error: Table 'database_wrd45.wp_links' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_links table. Error: Table 'database_wrd45.wp_links' doesn't exist
    
    The wp_options table is not okay. It is reporting the following error: Table 'database_wrd45.wp_options' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_options table. Error: Table 'database_wrd45.wp_options' doesn't exist
    
    The wp_postmeta table is not okay. It is reporting the following error: Table 'database_wrd45.wp_postmeta' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_postmeta table. Error: Table 'database_wrd45.wp_postmeta' doesn't exist
    
    The wp_terms table is not okay. It is reporting the following error: Table 'database_wrd45.wp_terms' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_terms table. Error: Table 'database_wrd45.wp_terms' doesn't exist
    
    The wp_term_taxonomy table is not okay. It is reporting the following error: Table 'database_wrd45.wp_term_taxonomy' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_term_taxonomy table. Error: Table 'database_wrd45.wp_term_taxonomy' doesn't exist
    
    The wp_term_relationships table is not okay. It is reporting the following error: Table 'database_wrd45.wp_term_relationships' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_term_relationships table. Error: Table 'database_wrd45.wp_term_relationships' doesn't exist
    
    The wp_commentmeta table is not okay. It is reporting the following error: Table 'database_wrd45.wp_commentmeta' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp_commentmeta table. Error: Table 'database_wrd45.wp_commentmeta' doesn't exist
    
    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
    
    wp_posts: Table 'database_wrd45.wp_posts' doesn't exist
    wp_comments: Table 'database_wrd45.wp_comments' doesn't exist
    wp_links: Table 'database_wrd45.wp_links' doesn't exist
    wp_options: Table 'database_wrd45.wp_options' doesn't exist
    wp_postmeta: Table 'database_wrd45.wp_postmeta' doesn't exist
    wp_terms: Table 'database_wrd45.wp_terms' doesn't exist
    wp_term_taxonomy: Table 'database_wrd45.wp_term_taxonomy' doesn't exist
    wp_term_relationships: Table 'database_wrd45.wp_term_relationships' doesn't exist
    wp_commentmeta: Table 'database_wrd45.wp_commentmeta' doesn't exist

    Is there any chance of being able to manually repair this? I'm not sure what the access to old backups of the MySQL db (if any) is...

    Any input appreciated.

    Thanks

  2. esmi
    Forum Moderator
    Posted 1 year ago #

    Nope. Not a snowball's chance. Your only real option is to restore a previous database backup.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.