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.

MySql 4.0.12

Discussion in 'General Discussion' started by jackal, May 9, 2003.

  1. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    16
    We finally had all the table corruption we could stand. We have been reading these forums for over 2 weeks making all the changes that were suggested. Finally we have given up and downgraded to version 3.23.56 .
    Does anyone know when we might get a stable release out for version 4.0.12?
     
  2. WebmastTroy

    WebmastTroy Well-Known Member

    Joined:
    Apr 28, 2002
    Messages:
    85
    Likes Received:
    0
    Trophy Points:
    6
    When pigs have wings maybe? "Stable" and "[insert word related to CPanel here]" don't belong in the same sentence....
     
  3. tlp

    tlp Well-Known Member

    Joined:
    Jan 9, 2003
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    For any of you that have a forum hosted on a server w/ cPanel w/ MySQL 4 if you are having problems that we are having on this forum with the MySQL errors then try this.

    For WHM/Cpanel server users, mysql package in cpanel was updated to 4.0.12 if you set automatically to update cpanel nightly.

    You need to do a few things after this upgrade.

    1. as root user run mysql_fix_privilege_tables to add new privileges to mysql database

    2. edit my.cnf and at least add under [mysqld] 4 new variables
    i.e.

    Code:--------------------------------------------------------------------------------
    [mysqld]
    skip-innodb
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    --------------------------------------------------------------------------------type

    mysqladmin -u root -p flush-tables

    then restart mysql if you don't use innodb tables.

    3. for virtual hosted cpanel users who have 'can't open database table' or corruption errors in their databases, and have ssh telnet access, they can type

    mysqlcheck -u mysqlusername -p vbdatabasename

    then when prompted enter their mysqlusername's password to do a repair of their vb database

    After restarting MySQL it's most likely you will get an error when trying to access your forum, to fix this you will need to access the forum via the admin.php address and using your MySQL functions select all the tables and choose repair and this should restore your froum back to normal.
     
  4. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    16
    Well sorry about that, we down graded to 3.23.56 we will sleep at night once again!!
     
Loading...

Share This Page