Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

lose database (mysql) connections during backup

Discussion in 'Database Discussion' started by warren0728, Jun 13, 2010.

  1. warren0728

    warren0728 Member

    Joined:
    Dec 23, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    i have two sites using databases (wordpress) sites....

    every time i backup using whm's backup, as soon as the backup process starts neither site can connect to their databases. after the backup procedure i have to restart mysql and then the sites work fine....is there any way to keep mysql running during or after the backup so these sites can stay online?

    Apache 1.3.42
    mysql 4.1.22
    php 4.4.9

    thanks in advance,
    ww : )
     
    #1 warren0728, Jun 13, 2010
  2. eth00

    eth00 Well-Known Member
    PartnerNOC

    Joined:
    Mar 30, 2003
    Messages:
    723
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    NC
    cPanel Access Level:
    Root Administrator
    Is the server overloading when this is happening or is it just going down anyways?


    Does MySQL actually crash or is it still running, just not responding?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 eth00, Jun 15, 2010
  3. warren0728

    warren0728 Member

    Joined:
    Dec 23, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    i just upgraded the server to the latest version of cpanel/whm and last night it backed up and did not lose connection....hoping the upgrade fixed the problem!
     
    #3 warren0728, Jun 15, 2010
  4. eth00

    eth00 Well-Known Member
    PartnerNOC

    Joined:
    Mar 30, 2003
    Messages:
    723
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    NC
    cPanel Access Level:
    Root Administrator
    A upcp can sometimes help, a mysqlupdate may also not be a bad idea. Glad it seems to be working for now at least :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 eth00, Jun 15, 2010
  5. warren0728

    warren0728 Member

    Joined:
    Dec 23, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    well 2 or 3 backups worked fine and now it is doing it again....this is really frustrating....as soon as i restart mysql everything works fine again....anyone else have this same problem and have any ideas....it's crazy that it started working and then all of a sudden quit again....

    i have also noticed that if i add a new account (domain) to my server the same thing happens and i have to restart mysql to get my database driven (wordpress and joomla) sites running again....any help would be appreciated!

    thoughts?
    ww
     
    #5 warren0728, Jul 28, 2010
    Last edited: Jul 28, 2010
  6. warren0728

    warren0728 Member

    Joined:
    Dec 23, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    bump....still having the same problem....i did check the MySQL error log and did not see any errors that would suspend operations....this is driving me crazy :-(
     
    #6 warren0728, Sep 9, 2010
  7. contractorsan

    contractorsan Registered

    Joined:
    Sep 10, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    I'm experiencing the same issue, but I think it might be tied to some configuration settings within my database. If I find it's on my end, I'll post the fix, otherwise I'll keep my eye on this thread incase it is indeed on cPanel's side.

    Thanks! :)
     
    #7 contractorsan, Sep 10, 2010
  8. warren0728

    warren0728 Member

    Joined:
    Dec 23, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    bump....still having the problem....can anyone help?

    thanks in advance....
     
    #8 warren0728, Oct 4, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - lose database (mysql)
  1. DimasFrolov

    HTTP2 stream 1 was not closed cleanly

    DimasFrolov, Sep 7, 2018, in forum: EasyApache
    Replies:
    2
    Views:
    106
    cPanelLauren
    Sep 11, 2018
  2. parstfp

    Close Open Directory Listing?

    parstfp, Jun 21, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    109
    cPanelMichael
    Jun 22, 2018
  3. Lillike

    Security Advisor: close port 3306 in the server’s firewall

    Lillike, Jun 20, 2018, in forum: Security
    Replies:
    11
    Views:
    458
    cPanelLauren
    Jun 25, 2018
  4. monkey64

    SOLVED Server restart loses custom SQL Mode and ignores my .my.cnf file

    monkey64, May 20, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    329
    cPanelLauren
    May 22, 2018
  5. Adamk

    Edit DNS Zone Error Loses Data

    Adamk, Feb 28, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    175
    cPanelMichael
    Feb 28, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice