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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
     
    #1 GFED, Jul 9, 2003
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    Location:
    If there is trouble, it will find me
    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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #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:
     
    #17 GFED, Jul 12, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cpanel MySQL Corrupted
  1. ca2236

    Mysql Swap on cPanel

    ca2236, Mar 30, 2018, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    115
    ca2236
    Apr 4, 2018
  2. SJR

    SOLVED cPanel Mysql Error Setting Up Google KMS Service

    SJR, Mar 17, 2018, in forum: Database Discussions
    Replies:
    3
    Views:
    101
    cPanelMichael
    Mar 20, 2018
  3. hamidkh

    How to change cPanel backup to use mysqldump -f instead?

    hamidkh, Feb 20, 2018, in forum: Database Discussions
    Replies:
    1
    Views:
    190
    cPanelMichael
    Feb 20, 2018
  4. WebHostPro

    Can I remove the remote MySQL icon from cPanel?

    WebHostPro, Jan 31, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    109
    WebHostPro
    Jan 31, 2018
  5. Michael Legg

    SOLVED cPanel can't connect to MySQL server (Remote)

    Michael Legg, Jan 27, 2018, in forum: Database Discussions
    Replies:
    5
    Views:
    366
    cPanelMichael
    Jan 30, 2018

Share This Page