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!

Cpanel + MySQL 4.0.13 = Corrupted databases?

Discussion in 'General Discussion' started by GFED, Jul 9, 2003.

  1. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    Is this a bug with mySQL or Cpanel?

    I had problems a few weeks ago with mySQL databases getting corrupted on my new server at XXX...

    Someone helped my diagnose and fix it by adjusting a higher setting for my mySQL connections... from 500 to 5000...

    it helped... and the databases quit corrupting as much... a couple have a few days ago and yesterday... so I upped my max connections to 10000 to see if it helps...

    I haven't seen any other posts about this... am I the only one having problems with them?

    +++

    Several people have told me that this is a problem with the new version of mySQL + Cpanel

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 GFED, Jul 9, 2003
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    What version of cPanel are you using?

    cPanel.net Support Ticket Number:
     
    #2 casey, Jul 9, 2003
  3. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    WHM 6.4.2
    Cpanel 6.4.2-S75
    RedHat 7.3

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 GFED, Jul 9, 2003
  4. carlgm

    carlgm Well-Known Member

    Joined:
    Mar 25, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    England, UK
    hi,

    do this in root SSH and copy and paste what it outputs.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 carlgm, Jul 9, 2003
  5. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    166
    Are the databases that are being corrupted always the same? Are the databases being manipulated with PHP?

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 ciphervendor, Jul 9, 2003
  6. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    No, and yes. :)




    carlgm, what does cat /etc/my.cnf do?

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 GFED, Jul 9, 2003
  7. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    oh, my.cnf file contains this...


    [mysqld]
    set-variable = max_connections=10000

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 GFED, Jul 9, 2003
  8. carlgm

    carlgm Well-Known Member

    Joined:
    Mar 25, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    England, UK
    okay then, this is min requirement for mysql 4:

    Firstly delete it:
    then reopen it in pico:
    copy and paste:
    then save:
    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 carlgm, Jul 9, 2003
  9. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    Thank you carlgm! I will see if this stops all the corruptions of my DBs!

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 GFED, Jul 9, 2003
  10. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    nope... I just had to repair another database... :(

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 GFED, Jul 9, 2003
  11. NeutralGold

    NeutralGold Well-Known Member

    Joined:
    Jun 5, 2002
    Messages:
    231
    Likes Received:
    0
    Trophy Points:
    316
    stop - start mysql?

    cPanel.net Support Ticket Number:
     
    #11 NeutralGold, Jul 10, 2003
    Last edited: Jul 10, 2003
  12. carlgm

    carlgm Well-Known Member

    Joined:
    Mar 25, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    England, UK
    I knew I forgot something.

    After you have changed it do this

    Now, that config is bare min and I would suggest having more options defined withih your /etc/my.cnf config file.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 carlgm, Jul 10, 2003
  13. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    I'll see if this helps... thanks again!

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 GFED, Jul 11, 2003
  14. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    this is still happening, does anyone know how to fix it? :(

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 GFED, Jul 12, 2003
  15. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    166
    Hire a system admin.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #15 ciphervendor, Jul 12, 2003
  16. advisor

    advisor Member

    Joined:
    Feb 23, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    151
    to solve your problem downgrade mysql to version 3 from whm>tweack settings

    that's it

    cPanel.net Support Ticket Number:
     
    #16 advisor, Jul 12, 2003
  17. GFED

    GFED Member

    Joined:
    Jun 14, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    151
    I downgraded to v3... thanks for your help, but seems to be a bug with mySQL or Cpanel from what I'm told...

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #17 GFED, Jul 12, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cpanel MySQL Corrupted
  1. asdcxz@1239

    cPanel reports MySQL down but sites work

    asdcxz@1239, Aug 6, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    104
    cPanelMichael
    Aug 7, 2018
  2. DigitalComunic

    SOLVED Can't update cPanel due to MySQL conflicts

    DigitalComunic, Jul 24, 2018, in forum: General Discussion
    Replies:
    8
    Views:
    154
    cPanelLauren
    Jul 30, 2018
  3. Bretas

    SOLVED Declare specific MySQL version during cPanel installation

    Bretas, Jul 23, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    129
    Bretas
    Jul 25, 2018
  4. geekbaaz

    Multiple cPanel servers with a common MySQL server?

    geekbaaz, Jun 21, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    124
    cPanelMichael
    Jun 21, 2018
  5. Clud7

    Pending Publication [CPANEL-22282] No mysql for clients on MariaDB 10.2

    Clud7, Jun 16, 2018, in forum: Database Discussion
    Replies:
    19
    Views:
    337
    cPanelLauren
    Aug 16, 2018 at 9:10 AM

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