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. Skartor

    Mysql Databases options not loading in some cPanel accounts

    Skartor, Jun 8, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    114
    cPanelLauren
    Jun 10, 2019
  2. Stacy HM

    MySQL error in users cPanel

    Stacy HM, Apr 27, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    317
    cPanelMichael
    Apr 30, 2019
  3. newbiesysadmin

    SOLVED [CPANEL-25603] Update breaks MySQL configuration file when no quotes are added to 'sql_mode' value

    newbiesysadmin, Apr 24, 2019, in forum: Database Discussion
    Replies:
    5
    Views:
    458
    cPanelMichael
    May 28, 2019
  4. 2Pro4u

    Would a backup of the cPanel partition be enough if mysql upgrade goes wrong?

    2Pro4u, Apr 15, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    195
    cPanelMichael
    Apr 17, 2019
  5. kUdtiHaEX

    Multiple cPanel servers with a common MySQL Cluster

    kUdtiHaEX, Apr 15, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    192
    cPanelLauren
    Apr 16, 2019

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