How to fix a MySQL DB when some tables were deleted

  • Resolved tanmoybiswas

    (@tanmoybiswas)


    6 years, 9 months ago

    Hello users, I’m facing an issue like – I’ve only one MySql DB given by my hosting provider. So what I do is, for different applications I use same DB. but I use seperate prefix always for separate tables to understand, this is related to WP, this is related to another..
    Last day while I created some tables for another application, but unfortunately after the test, I accidentally cleared some of the rows inside those test tables, after that my wp isnot connecting to DB. Right now I dont have a backup of DB.

    Right now i have all wp tables(myISAM type) , test tables- InnoDB type (with some deleted rows).
    How can I fix this? is dropping of those test tables (they re not part of WP anymore) can help me?

    please help me.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Your site is up so it must be able to connect to the database. As to the stuff you deleted or dropped… If you don’t have a backup, it’s gone. Maybe your host has a backup. Check with them.

    Thread Starter tanmoybiswas

    (@tanmoybiswas)

    Thanks @sterndata.
    Yes there was an issue going on with existing DB_user. i created a new db_user & changed the entry in wp_config & everything started to work like charm.

    Thanks man for the follow up .

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to fix a MySQL DB when some tables were deleted’ is closed to new replies.