I have a dedicated server and have backup configure set up to do daily, weekly and monthly. What I can’t seem to find in the backup configure (using WHM) is where to set the TIME you want the backups to begin? I know there must be some way to designate what time the backups start and it is probably right under my nose, but being a relative newcomer to the world of dedicated servers, I can't find it. Can someone point me to the right location to set the backup time?
tdot:/# /etc/init.d/mysql start Starting MySQL database server: mysqld.
. . . . ...failed or took more than 6s. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! tdot:/#
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
have googled this to death. solutions are not working.
so far have tried the whole linking mysql.sock to the file in /tmp, changing mysql root password, rebooting, adding socket parameters in my.cnf. nothing works!
Stopping web server: Apache2. www:/# /var/wkscript/tools/panel_manager start LayeredPanel related software starting.Starting system log daemon: syslogd. Starting periodic command scheduler: cron. Starting mail transport agent: Postfix. Starting MySQL database server: mysqld. . . . . . . . . . . . . . ...failed or took more than 6s. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Starting domain name service: named. Starting ftp server: Running: /usr/sbin/pure-ftpd-mysql -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -E -O clf:/var/log/pure-ftpd/transfer.log -S 75.126.177.244,21 -u 1000 -B Starting web server: Apache2. Starting web server: Apache2.
If you visit the site, the main page gives this error: Fatal error: Failed to connect to the DB server in /var/wkscript/db.php on line 28
What command could I use to see all the currently running services on my Windows (vista) computer?
I'm trying to start my MySQL server, but it won't start. I think I know what the problem is though I'm not sure. I think that the service name "MySQL" is already running...and I need to remove it or something.
Btw...my apache and php is fine. Though...I cannot use my MySQL from php obviously...since it's not running.
I have a cheap managed server and support is of little help BUT they will do what I tell them, where should I tell them to start to fix high mysql load?
The server currently has a large IPB forum, a large 4images gallery, and a couple popular Wordpress blogs, and this combo keeps taking mysql down.
What can I do server side to help this? And what shouldn't I do?
I just installed mySQL server on a brand new dedicated server and am getting Timeout error occurred trying to start MySQL Daemon. I have uninstalled and reinstalled it a few times and am still getting the same error.
Can anyone recommend a Apached and MYSQL optimization expert? I just some optimization done on mysql and apache upgraded... but pache wouldn't restart with the following entries:
if i remove above then it starts... but my CPU spikes and I am getting a ton of errors emailed to me:
Invalid SQL: SELECT COUNT(DISTINCT(userid)) AS count FROM vb_session WHERE vb_session.userid>0 AND vb_session.lastactivity>1245294346;
MySQL Error : Out of memory (Needed 8388580 bytes) Error Number : 5 Request Date : Wednesday, June 17th 2009 @ 09:39:06 PM Error Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Its constantly complaining about this same query and i thought i removed all of the vbulletin options...
i am pulling my hair out... cuz my server isn't swapping, ther are 0ver 8GBs in cache.... but my CPU goes up
Here is original problem thread...
[url]
2nd post has recommended config... and my subsequent probs
I am getting the error (as listed in the title) on my server. This is a BRAND NEW FRESH install on a brand new server...
OS: Unix Fedora Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686 Hardware Information: Brand new Dell SC1435 Server Software Version: MySQl 5 Control Panel: Nothing yet
Apache starts ok but when I go to strart MySQL I get the following error...
[root@server112]# /etc/rc.d/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon Starting MySQL: [FAILED]
Does anyone have any ideas? I did some pretty extensive searching... Web Hosting Talk article that basically describes the same error. I followed everything as listed in his suggestion and it didn't change anything.
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
Mysql is restarting all the time, but when I look at the log file, I got the following error message. Anyone has any idea about this issue?
080604 22:48:45 InnoDB: Started; log sequence number 0 1304279005 080604 22:48:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 080604 22:48:45 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 080604 22:48:46 [Note] /usr/sbin/mysqld: Normal shutdown
We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM : -------------------------------------
cpdavd up cpsrvd up exim (exim-4.69-15.1_cpanel_maildir) up ftpd up httpd (2.2.11 (Unix)) up imap up interval up mysql (5.0.67-community-log) up named (9.3.4) up pop up rsyslogd up spamd up syslogd up Server Load 6.97 (1 cpu) Memory Used 49.4 % Swap Used 0.23 % Disk /dev/hda3 (/tmp) DMA+ 70 % Disk /dev/hda5 (/) DMA+ 22 % Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM : ------------------------------------------ Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz Processor #1 speed: 2394.068 MHz Processor #1 cache size: 2048 KB
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492 /usr/sbin/mysqld: ready for connections. Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$ A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007 070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown 070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted 070106 14:40:40 InnoDB: Starting shutdown... 070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492 070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete 070106 14:40:42 mysqld ended 070106 14:40:42 mysqld started 070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
After 2 years of application hosting on ixwebhosting.com i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.
Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.
I now need to sireously move to a VPS / Dedicated server or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.
The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.
I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.
Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.
I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.
I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:
Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.
looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.
I have this error when i put import to mysql database
Code: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244
I have in domain > doemainname > max_execution_time Standaard Geef een aangepaste waarde op 0
and insert in usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command $cfg['ExecTimeLimit'] = 70000;
I can't get access to a certain site. I always get the page with:
network time out - server at *** takes to long to respons. More people have noticed this and apparently it only happens to people with certain specific providers. And not all the time. Some times they DO get access eventy to they belong to the same ISP. So I guess an ISP isn't blocking access to it otherwise it would be permenantly/The site administrator insists that certain ISP's are blocking his site. He's hosting it on his own server. The domain belongs is registered at namecheap.com.
If an ISP is blocking this site (if that's possible?), that would lead to that 'network timeout' page wouldn't it?
What is the most likely reason for getting a timeout page anyway?
I have a dedicated server specs: AMD 3500+ 64 Bit CPU, 1 GB Ram, 160 GB Sata Drive. For 1 month, CPU load average reaches 40-50 value. This happens about 5-6 times in a day. When I stop httpd service for 30 seconds everything goes normal. I think this is not a DoS attack because it comes systematic, I dont believe no one makes this regularly except bots.
Maybe its a system service or a cronjob but it stops when I turn off httpd service? How can I be sure about what's making this regularly load?
I also did set up a script which mail me when load average of system goes crazy and restart httpd service. But instant restart is not working to stop load increase.