MySQL Account Maintenance
Jan 25, 2007I have 150 accounts on my server and suddenly 75 accounts the users of the Database are deleted?
you can see this account:
[url]
I have 150 accounts on my server and suddenly 75 accounts the users of the Database are deleted?
you can see this account:
[url]
Windows normally require far more frequent patching than Linux. There is one issue with VPS. Everytime we do maintenance we need to reboot the server and the VPS are affected. Normally for VPS I thought the best method will be to remote into the VPS first to shut them all down before rebooting the main server.
Issue is sometimes clients want security and do not give us these passwords. If we were to shut down by the main server interface and reboot, won't it harm the VPS? For those doing maintenance, what are your ways of overcoming these?
possibility of having a web server that require little to no maintenance?
View 7 Replies View RelatedRecurring maintenace can be down the uptime %?
View 5 Replies View RelatedI know that after you have been running a site for a while you will have some "clutter" after a while. For example, email boxes that are not used might be taking up a lot of space because they are getting spammed.
View 14 Replies View Relatedtoday i received this email from BurstNET, really i am chocked from what happened.
BurstNET™/NOCSTER™ Network Mailing List Members;
BURSTNET Network Maintenance Update - Saturday, September 20th, 2008
Please be advised that the network maintenance performed on Saturday, September 20th, 2008, starting at 2AM EST was unsuccessful.
Due to an unforeseen equipment issue (an undocumented Cisco™ limitation) that did not appear until after live traffic was flowing, the maintenance was not able to be completed as planned. The maintenance was nearing completion, at which time live traffic was brought online on the new equipment. The live traffic immediately caused multiple/repeat outages, and BustNET™ Network Engineering attempted to diagnose and workaround the issue. BustNET™ Network Engineering found that this was not possible at this time, and the network design would have to be altered accordingly to proceed.
Proper planning, configuration, simulation, and testing had been completed in advance of this maintenance period, however, this was a undocumented Cisco™ IOS limitation that was not found until after live traffic was brought online.
BurstNET™ Management made a decision to revert back to old equipment/configuration, to get our client base back online, until which time this issue can be rectified/resolved on the new equipment.
A new maintenance window will be announced shortly.
We apologize for this inconvenience, and do appreciate your patience and understanding, as we work to upgrade/improve the network for the best future performance.
BurstNET™, BurstNET Technologies™, and NOCSTER™ are either registered trademarks or trademarks of BurstNET Technologies, Inc.™ in the United States and/or other countries.
____________________________
You are currently subscribed to the BurstNET™ Network Mailing List.
To unsubscribe from this BurstNET™ mailing list, please visit: [url *removed*]
The removal process is automated, and you will be removed immediately.
BurstNET™ - an INC500™ Company
BurstNET™ - The Speed the Internet Travels™
To place an order, or for more info, contact;
BurstNET Technologies, Inc.™ - BurstNET™
Toll Free 24/7/365 Support: 1-877-BURSTNET
Phone (570) 343-2200 - Fax (570) 343-9533
PO Box #591 Scranton, PA 18501-0591 USA
[url]& [url]
sales@burst.net
Copyright 1996-2008 ©
BurstNET Technologies, Inc.™
All Rights Reserved.
I got around 5 servers running and added one more last week. Its becoming a pain managing them all. Updating, setting up new policies and restrictions, securing or whatever other tasks that are needs to be executed on ALL these servers.
Wanted to know how you guys are doing it. I know that some hosts use HSPc, HSphere, Helm, etc to manage the entire cluster. But what about the lot who use cPanel?
yestarday i ressived email from them
Dear Valued Limestone Networks Client,
You are receiving this notification because Limestone Networks has scheduled a maintenance window to perform work on several fiber cross connects which provide carrier bandwidth to our facilities. Since this will involve a minor interruption in service we are informing all of our clients of scheduled maintenance as far in advance as possible.
This maintenance window is scheduled for Friday, November 14th, 2008 from 12:00AM to 6:00AM CST. Those clients who will be affected, which is anticipated to be less than 5% of all clients, will experience a brief (5-10 minute) loss of network connectivity to their servers. We do not anticipate power loss to any servers during this maintenance window.
We appreciate your understanding and cooperation in this matter. Please feel free to contact us email (sales@limestonenetworks.com) via our ticket system [url] or our live chat system (www.limestonenetworks.com) if you have any questions, comments, or concerns.
but one thing i cant get it,they sayeing outage will be from 12-6am or just 5-20min because my server has been down for more than 3hrs
how do you guys do the maintenance for shared hosting SQL 2000/2005? Do you just let the customers do the maintenance, compacting and optimizing themselves or do you scheduled a task to do that?
Till now I had let my clients do that. But some clients it seemed do not really know much about this. But if we were to compact or optimize all the databases by task scheduling, I am worried that it is something against their privacy.
today i got a email form my web hosting:
"Lunarpages Web Hosting is scheduled to undergo maintenance this Saturday, January 17, 2009, at our San Diego location in order to upgrade our internal systems to be more energy efficient in our power usage, a major step in our initiative to Go Green in 2009. Unfortunately, this means that some of our servers will be unavailable for a short time while we upgrade these systems. We apologize for any inconvenience this may cause.
Below, you will find information on how to track the progress of our upgrades and the scheduled times that our servers will be undergoing these improvements.
The following times are our three scheduled maintenance windows for this upgrade. Please note that the information is in Pacific Standard Time (PST):
* Saturday, January 17, 7am-10am
* Saturday, January 17, 10am-1pm
* Saturday, January 17, 6pm-9pm
"
will this maintenance affect the rank of my website in google and other search engine?
Since 3 Days the "daily maintenance script" isn't working anymore.
Task info
[table="width: 500, align: left"]
[tr]
[td]Task ID[/td]
[td]43315[/td]
[/tr]
[tr]
[td]Task name[/td]
[td]Run the daily maintenance script[/td]
[code]....
I run a shared hosting
OS:centos with whm/cpanel
and would like to restrict access to mysql database
example:
username:user1 created database:user1_db1,user1_db2 etc..
and can only access his own databases
so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases:
Quote:
ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database roundcube......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists'
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database horde......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists'
ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist
ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist
ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist
ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist
ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist
ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist
ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string
Done
What does this error mean and how to solve this problem?
I have updated cpanel and mysql but the problem is still found
This problem found while trying to restore any account not this one only..
My Server Is down nearly every day in the last three days
I think one of my clients is sending emails from his forum to his members.
How can I know who is he, And most important can I stop him from emailing his members?
Also,
How can I find out which account is making the biggest load on MySQL?
In previous thread we made few manual transfer of our domains.
We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.
All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
Script Auto Remove account Cpanel - if account inactive ?
View 5 Replies View RelatedIn moving my site to Drupal, I have had it on a "Beta" account on the same server. I need to move the DB to the "Live" site. How do I re-assign it using the master PHPMyAdmin through WHM to change the owner of the DB from "Beta site" to "Live site"?
View 3 Replies View RelatedI noticed there is always notification to user account mail with account info but on all my servers on different networks notification comes only to server mail.How do i enable that?Do i need to install tweak to whm/cpanel?
View 7 Replies View Relatedexisting account have enabled catch all account automatically & i don't know how?
Main >> Server Configuration >> Tweak Settings
Default catch-all/default address behavior for new accounts. "fail" is usually the best choice if you are getting mail attacks.
currently it is tick marked on fail
And forwarders has been set to e.g jeetu@jeetu.info to domain automatically & also i don't how?
when i try to delete this forwarder its shown deleted successfully
Code:
Email Forwarding Maintenance
jeetu@jeetu.info's mail will no longer be redirected to jeetu.
then again i checked forwarder & found that forwarder is not deleted why?
what could be the problem?
due to this our clients are facing out of disk space running problem & they are not able to get future emails
1. now i want to disable catch all account for all existing accounts at one go
2. also i want to terminate forwarders for all existing users at one go
Let me know how to do this
Check attachment for further reference