0
votes
0answers
87 views

Unable to restart MySQL server on CENTOS 6.5 x86_64 kvm – server (WHM/cPanel)

I am not able to restart MySQL server on CENTOS 6.5 x86_64 kvm – server (WHM/cPanel). I am getting following error while trying to restart the MySQL server. Waiting for mysql to ...
0
votes
1answer
25 views

Linux CentOS dedicated server, process is dissapearing from WHM process manager

I have a script running on my dedicated server /usr/bin/php/home/user/public_html/myscript.php. When I log in to WHM/Process Manager, sometimes this script disappears from the list. Also, when I log ...
-2
votes
1answer
31 views

mySQL upgrade caused root ownership of files [closed]

I recently upgraded mySQL to 5.5 on my Centos box. It failed on restart as some of the files had taken root ownership instead of being owned by mysql user/group. Its working now, after 30 mins of ...
0
votes
0answers
119 views

WHM: Is it normal to get chkservd HANG warnings every few weeks?

Over the course of the last few months we've been receiving emails about chkservd hanging which may (?) be the source of a few other problems. Is it normal to have trouble with chkservd hanging? ...
0
votes
1answer
175 views

WHM/CPanel system applying a per-user MySQL resource limit

Through testing of our server, I have come to the conclusion that our server is somehow limiting usage per user to MySQL. When I run mysqltuner.pl, the script pegs one of the processors for several ...
0
votes
1answer
491 views

cpanel account transfers failing: ERROR: Failed to dump one or more databases

Getting this error when transferring multiple accounts via whm transfer utility: ERROR: Failed to dump one or more databases I was told this by a cpanel tech Here is the specific error I'm seeing ...
0
votes
1answer
289 views

Mysql skip-name-resolve [closed]

I had recently purchased a new server, and transferred all my accounts via WHM Transfer. The problem is that when WHM takes a daily backup, it outputs are message such as DBD::mysql::st execute ...
1
vote
2answers
274 views

heavy load on mysql

i have dedicated server with very good configuation like 16 gb ram etc but i am facing heavy load from mysql i am running a music wesbite however only one database is running and 5-10 pages are only ...
0
votes
1answer
143 views

Limit Database Size for a particular Package on VPS with cPanel

Is it possible to limit mySQL database size for a particular package (created via whm)? So we can offer a kind of trial hosting account. Trial should obviously have catches or we won't really earn. I ...
1
vote
2answers
1k views

Uninstalling MySQL for MariaDB Replacement on cPanel

Well the first part of my day was spent researching how to remove MySQL to install MariaDB and the second part of my day was spent trying to reinstall MySQL cause something was messed up. So now I ...
0
votes
2answers
2k views

setsockopt EOPNOTSUPP (Operation not supported)

When I strace my MySQL process, I keep finding the same error over and over: setsockopt(240, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported) futex(0x87ab944, FUTEX_WAKE_OP_PRIVATE, ...
-1
votes
1answer
474 views

How to store WHM data on remote MySQL without ssh

Is it possible to connect WHM to remote MySQL server without ssh? Thing is I am hosting WHM on Amazon EC2 and want to move all MySQL databases to Amazon RDS, but WHM by default supports connection via ...
4
votes
9answers
946 views

Server Crashes Every 2 Weeks Days On The Exact Same Time

A few months ago our server started to crash every 14 days, at the exact same time(around 11:04 every time). We're pretty sure this isn't some kind of hardware failure, as hardware failures tend to be ...
-2
votes
3answers
223 views

Locked out of server by not-sure-what, remote reboots don't help. What to do?

I'm in charge of a dedicated web server for a client. He's got some pretty good traffic and it's been going down more and more often in the last 2 months. I was just in the process of finalizing a big ...
1
vote
4answers
373 views

My LAMP server is getting hammered with traffic, how can I see what's causing the load?

We're getting tons of traffic but it's causing the site to respond extremely slowly, or not at all. I'm in WHM checking out the load, the top processes, etc but I can't seem to find exactly what the ...
0
votes
1answer
65 views

How to connect mysql remotely from other server

I want to host databse at different host than webiste. How can i connect it remotely. Which setting i have to make in whm to allow mysql to be connected remotely
0
votes
3answers
426 views

Concerns upgrading to MySQL 5.1 on WHM web host

I'm currently running a host with 5.0 installed and wanted to upgrade to 5.1. Is there any real issues or concerns I should have in doing this? I run 5.1 on my dev server without any issues but I do ...
0
votes
3answers
711 views

SSH Backup and transfer to backup server?

I'm running WHM/cPanel and I would like to make my own backup methods than what WHM is offering. What I need to do is make backups each users public_html directory (/home/username/public_html/) and ...
0
votes
3answers
373 views

Cpanel user DB config

Where does cPanel/WHM store its associations between users and their MySQL databases? I can't seem to find anything in /home/$USER, or /var/cpanel, or /etc/..
0
votes
2answers
1k views

Automated WHM MySQL backup not working

I am using WHM's automated backup system to make daily backups of my database. I have it set that it only makes a backup of what has changed. I've had this running for a while now and thought it was ...