Database connection error

  • Hi Team,

    Suddenly while accessing my wordpress website there was an error shown “Database connection Failed”.

    I have used the repair database option in the cwp_config file and repaired the database. Kindly help me with the below output from the repair function.

    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_users: 45 clients are using or haven’t closed the table properly
    wp_usermeta: 48 clients are using or haven’t closed the table properly
    wp_posts: 46 clients are using or haven’t closed the table properly
    wp_comments: 45 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 47 clients are using or haven’t closed the table properly
    wp_terms: 22 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 44 clients are using or haven’t closed the table properly
    wp_term_relationships: 44 clients are using or haven’t closed the table properly
    wp_termmeta: 36 clients are using or haven’t closed the table properly
    wp_commentmeta: 40 clients are using or haven’t closed the table properly

Viewing 14 replies - 16 through 29 (of 29 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    The mysql server has crashed. (Probably a server config issue that caused it to crash before, corrupting your dB and starting the original issue.) Anyhow, contact your host.

    Thread Starter shashikant91

    (@shashikant91)

    Hey @sterndata

    To my surprise it got auto resolved… and my website seems to be opening now properly..

    Could you suggest me a way round to take care of such issues in the future?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Backup, backup, backup. I like the plugin “backwpup” because you can set it to backup on a schedule and send the backups to Dropbox or other off-site locations.

    Thread Starter shashikant91

    (@shashikant91)

    Ok let me try this plugin currently I am using all in one wp migration.

    Will backwpup help in restoring also in such cases or only takes backup & keep it aside.

    It says db backup needs mysqli

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    If your host has a flaky MySQL server setup, the backups may come in handy. Talk to your host about mysqli.

    Thread Starter shashikant91

    (@shashikant91)

    Hey,

    One more problem…

    my website is up but none of my other urls are working Only home page is getting opened & other pages are showing below error

    Not Found

    The requested URL was not found on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Soemthing’s wrong with your .htaccess file or how the web server is processing it.. Go to SETTINGS->PERMALINKS and click “save” to reset things. Sometimes that helps. If not, contact your host.

    Thread Starter shashikant91

    (@shashikant91)

    You are a gem @sterndata and a god for now at this point of time. I just saved the permalink settings and it just started working like a flash…

    god what’s happening with my website..

    I could also observe few tables which are extra in my database which is in use which were not present earlier.

    Thread Starter shashikant91

    (@shashikant91)

    @sterndata

    One last help. Now my website is Okay but somehow the wordpress dashboard has become very slow.

    Can I try optimizing the db from phpmyadmin? Will this help? or should I contact my hosting company for this?

    I hope the data will not be disturbed if at all I am doing an optimize from phpmyadmin

    Thanks
    Shashikant

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You can try optimizing; I think you’re on an underpowered hosting platform.

    Thread Starter shashikant91

    (@shashikant91)

    Huh!

    You are right but I am on GODADDY…..no DADDY for that ??

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Contact GoDaddy support.

    Thread Starter shashikant91

    (@shashikant91)

    But just to reconfirm am I safe without loosing the data when I optimize the database?

    Just wanted to check before I approach them. If optimizing doesn’t help I have no other way except to contact GoDaddy Support

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Yes, you’re safe.

Viewing 14 replies - 16 through 29 (of 29 total)
  • The topic ‘Database connection error’ is closed to new replies.