Cpanel + MySQL 4.0.13 = Corrupted databases?

GFED

Member
Jun 14, 2003
20
0
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:
 

casey

Well-Known Member
Jan 17, 2003
2,288
0
191
What version of cPanel are you using?

cPanel.net Support Ticket Number:
 

ciphervendor

Well-Known Member
Aug 26, 2002
1,050
0
166
Are the databases that are being corrupted always the same? Are the databases being manipulated with PHP?

cPanel.net Support Ticket Number:
 

carlgm

Well-Known Member
Mar 25, 2003
103
0
166
England, UK
okay then, this is min requirement for mysql 4:

Firstly delete it:
rm /etc/my.cnf
then reopen it in pico:
pico -w /etc/my.cnf
copy and paste:
[mysqld]
set-variable = max_connections=500
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
then save:
ctrl + x
y
enter
cPanel.net Support Ticket Number:
 

carlgm

Well-Known Member
Mar 25, 2003
103
0
166
England, UK
Originally posted by NeutralGold
stop - start mysql?

cPanel.net Support Ticket Number:
I knew I forgot something.

After you have changed it do this

service mysql restart
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:
 

ciphervendor

Well-Known Member
Aug 26, 2002
1,050
0
166
Originally posted by GFED
this is still happening, does anyone know how to fix it? :(

cPanel.net Support Ticket Number:
Hire a system admin.

cPanel.net Support Ticket Number:
 

advisor

Member
Feb 23, 2003
24
0
151
to solve your problem downgrade mysql to version 3 from whm>tweack settings

that's it

cPanel.net Support Ticket Number: