Repairing Databases ?!

  • lenyxgarcia

    (@lenyxgarcia)


    10 years, 12 months ago

    Suddenly it said I had to repair my detabases then this happened?!
    Help!!!

    wp_g67g76_usermeta: Table ‘profiletrans_com_1.wp_g67g76_usermeta’ doesn’t exist
    wp_g67g76_posts: Table ‘profiletrans_com_1.wp_g67g76_posts’ doesn’t exist
    wp_g67g76_comments: Table ‘profiletrans_com_1.wp_g67g76_comments’ doesn’t exist
    wp_g67g76_links: Table ‘profiletrans_com_1.wp_g67g76_links’ doesn’t exist
    wp_g67g76_options: Table ‘profiletrans_com_1.wp_g67g76_options’ doesn’t exist
    wp_g67g76_postmeta: Table ‘profiletrans_com_1.wp_g67g76_postmeta’ doesn’t exist
    wp_g67g76_terms: Table ‘profiletrans_com_1.wp_g67g76_terms’ doesn’t exist
    wp_g67g76_term_taxonomy: Table ‘profiletrans_com_1.wp_g67g76_term_taxonomy’ doesn’t exist
    wp_g67g76_term_relationships: Table ‘profiletrans_com_1.wp_g67g76_term_relationships’ doesn’t exist
    wp_g67g76_commentmeta: Table ‘profiletrans_com_1.wp_g67g76_commentmeta’ doesn’t exist

Viewing 7 replies - 1 through 7 (of 7 total)
  • Matthew

    (@kidsguide)

    10 years, 12 months ago

    Can you still access your admin area? If not contact your hosting provider.

    Thread Starter lenyxgarcia

    (@lenyxgarcia)

    10 years, 12 months ago

    No, it tells me “One or more database tables are unavailable. The database may need to be repaired.” then I can either repair or repair and optimize which only leads me to the original message.

    Matthew

    (@kidsguide)

    10 years, 12 months ago

    Can you please provide a picture?

    catacaustic

    (@catacaustic)

    10 years, 12 months ago

    That error means that your database has crashed, and by the looks of it pretty badly.

    If you don’t have a backup of the database I’d talk to your hosting company as soon as possible and see if they have backups that they can reinstate. If they don’t then there’s really not anythng that anyone can do.

    This is another reason that it’s always recommended that you have backups, and if possible, multiple ones so you can revert if something like this does happen.

    Thread Starter lenyxgarcia

    (@lenyxgarcia)

    10 years, 12 months ago

    Picture attached via imgur –

    View post on imgur.com

    Thread Starter lenyxgarcia

    (@lenyxgarcia)

    10 years, 12 months ago

    Luckily it was a fresh install, all I need to do is just delete and restart the installation then?

    catacaustic

    (@catacaustic)

    10 years, 12 months ago

    If it’s a fresh install, then yes, deleting the database tables is by far the best way to go.

    And after that, keep backups regularly. This may not happen again, but it could very easily be an ongoing problem.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Repairing Databases ?!’ is closed to new replies.