I'm a total newbie in these things and have no idea what to do

I have consulted my friends who are more aware of these kinds of problems than me but still i could not understand.

If i do not resolve this issue by the 7th, godaddy will shut down my hosting account.. Really need you guys to help me!

I know the problem is over utilization but i don't know what to do, they said either to upgrade to a dedicated server which i do not have the funds to or address and resolve this problem..

This was the message they sent me..

Dear Sir/Madam,

Thank you for contacting Hosting Support regarding the network violation for over-utilization of the smartbananas MySQL database on your smartbananas.com hosting account.

Upgrading to a different plan within the shared hosting environment would not be a solution to this issue. By definition, shared hosting shares resources with other plans and therefore the over-utilization of those resources by any one account is not acceptable. If you have server administration experience, you may wish to consider moving to a dedicated server plan, as you would then no longer be in a shared environment. Otherwise, you may wish to consider moving to a Managed Hosting plan, which features the benefits of a dedicated server without the requirements of managing it yourself.

However, should you wish to remain in the shared environment, you would need to address the following query:

SELECT DISTINCT u.ID, u.display_name FROM wp_users u , wp_usermeta um where u.ID = um.user_id ORDER BY rand() limit 5

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE u ALL PRIMARY 156578 Using temporary; Using filesort
1 SIMPLE um ref user_id user_id 8 smartbananas.u.ID 15 Using index; Distinct

This query examines 2,348,670 rows, which is unacceptable in the shared environment.

Upon further review, we are seeing that the size of this database is approximately 2,300 MB, with approximately 1,300 MB being consumed by the 'wp_posts' table within it. Currently the size limitation for databases in our shared hosting environments is 2,000 MB.

We would therefore strongly recommend you review your database content, using the read-only user 'smartbananas2' through the phpMyAdmin interface, to determine whether this is valid content or the result of unchecked spamming of your WordPress application.

To Manage Your Databases Using phpMyAdmin

Log in to your Account Manager.

From the Products section, click Hosting.

Next to the hosting account you want to use, click Launch.

In the Databases section of the Hosting Control Center, click MySQL.

Click Manage via phpMyAdmin for the database you want to manage with phpMyAdmin.

Enter your user name and password. The user name is the same as the database name.
TIP: If you don't know your password, see Resetting Your MySQL Database Password for information about changing it.

Click Go.


For more information about working with phpMyAdmin once you're logged in, visit phpmyadmin.net.

If you find the contents to be due to spamming, you would need to clear that out either through phpMyAdmin or the WordPress dashboard, once you have responded with the required statements listed below so that we can re-enable access to this database.

If you find that the contents are legitimate, you would need to either remove any non-essential content in order to comply with the 2,000 MB limit or move to a more suitable hosting plan, as referenced above.

Please keep in mind that we are unable to support custom scripting or the inner workings of third-party products. Therefore, as the owner of this hosting plan, is is incumbent on your to verify that there are no other underlying factors that may be contributing to this issue.

*** IMPORTANT ***

Due to the serious nature of this situation, this hosting account is scheduled to be suspended if you do not take timely action. This suspension will take place SATURDAY JANUARY 7, 2012 if either you fail to reply to this message with the required statements below OR fail to correct the issues with this database after committing to do so.

****************

After you have examined this issue, your services can be reactivated by responding to this notice with the following:

1. A statement that you have reviewed and agree to abide by the terms of the "Web Hosting and Virtual Dedicated Hosting Service Agreement," and
2. A detailed description of the steps you have taken, or intend to take, to resolve and/or correct this issue, and
3. A statement that you agree to configure your site in such a way as to ensure that there is not a re-occurrence of this issue at any point in the future.

After we receive your reply with these statements we will contact Go Daddy’s database administrators, provide them with your solution, and request that they re-investigate the issue. If they approve your proposed solution, we will reactivate your service. (We reserve the right to suspend your services again should its reactivation result in a repeat occurrence of the problem.)

We appreciate your cooperation and your understanding in this matter. If you have any questions, you may contact us by replying to this email or by calling 480-505-8871.

Regards,

Scott S.
Advanced Hosting Support

I would really appreciate it and be very thankful to you if you could tell what should i do, or whether i can choose any other plan that is in the under $30 range per month.. but they said you can only choose a dedicated server ..

Unfortunately, your ONLY option at this point is to upgrade from a shared hosting environment.. However, I highly recommend you do NOT go through GoDaddy again.

Your database is over 2GB in size, that alone is too big for shared hosting. Not to mention that every time the query they listed in the email runs, it examines 2,348,670 rows!.. My friend, you need a VPS or a dedicated server for sure (I would choose a decent VPS for now though).

My honest advise to you is this... Backup your website's files and database ASAP, and start making arrangements to move to a better host (fast). Start by looking for a reputable host that can offer you a FULLY MANAGED VPS (Virtual Private Server).

This will be just like having a shared hosting account (in the sense that you do not have to worry about managing the server yourself), but you will have full control and full access to all of the resources available on your VPS. Make sure you choose a VPS with decent CPU power and available RAM, or you will be in a worse position than when using GoDaddy (trust me)..

Some reputable and affordable VPS providers that come to mind are http://www.hostv.com/ and http://www.knownhost.com/ but there are many, many more to choose from. Both offer Fully Managed VPS plans with cPanel installed. If you do your research, you can find promo codes and discounts on the web for both companies and get an ever better deal.

Hope this helps.

Thank you so much HostLeet!
That definitely really helped!

Actually my problem is i do not make that much money, and all i make is from that site which is anywhere from $200-700 per month, plus all the electricity bills and everything included i end up with barely nothing in the end.

For the past 6 days my site has been down and i have had 6 days of 0 income, thus me being so paranoid.

I contacted Hostgator a while back, via their live chat and forwarded them the rows i was using etc etc.. which godaddy had sent me and is also present in the post i made here.

They said something like,
"We will not restrict your site and all our hosting plans have unlimited storage facility."

And then he sent me to the hosting page link..

At first i was really happy and thought that my solution was solved.
But then i called my cousin (Who is much more knowledgeable than me in these kind of things) but he said his friend used hostgator and he used much fewer space than me but still hostgator warned him and put his site down etc etc..

After that i was totally confused and immensely worried me again.

Sometimes i just make $100 with my site and if i take a dedicated or a virtual server (Which won't cost me below 100$) I will sometimes be left with nothing.

But Hostleet you really helped me get a clear picture of things and gave a straight forward answer which really helped me.

Now hopefully i can find a solution, if not, there are always other ways in life

I definately agree with HostLeet in this situation, A 2GB database with frequent queries would use up a reasonable chunk of memory and cpu time. When hundreds of websites are hosted on one server in the shared hosting case. If one website takes up an unfair amount of resources on a regular basis, unfortunately the only fix is to contact the customer and suggest an upgrade.

Many sales operatives work on commission, therefore will say anything in order to get a sale but... When your website is finally loaded onto their servers after a time the technical support who maintain the server will probably take the same approach GoDaddy took. In order to maintain a respectable service for the other customers on the server.

I would recommend getting yourself a Virtual Private Server (VPS), these range in price and can come managed which may be handy depending on the level of expertise you have in the area with managing and maintaining a server. I'd recommend having a look in the offers section, to find some deals and make contact with a few of the hosts see what they can suggest.

I hope you get your situation sorted!

ghufran1,

I will side with both of the previous responders. Right now the priority is to get you back online and not trying to deal with GoDaddy, which clearly won't be hosting you in the same environment.

Given that you do not have the budget for a dedicated server, go for a VPS solution. There are many special discount deals posted in this forum for members of this forum. You can find a Virtual Private Server nowadays for the price of a high-end shared hosting plan and enjoy the more resources and a more speedy website.

The problem with all the providers who offer unlimited resource will most definitely always restrict you in other ways: the size of the database, the amount of traffic, the CPU usage your site is responsible for, etc. There are many excuses. Seems like you got yours. At HostingDiscussion.com, we established a policy for web hosting companies to post clear limitations along their deals and we do not allow "unlimited" offers.

Don't waste more time, go find a nice VPS.

Thank you so so much all of you, for taking out the time to help me out. You won't imagine how much i appreciate it!

@Artashes, i will definitely waste no more time, but godaddy has blocked my "mysql" database and i do not know how should i transfer the files from 1 hosting to another..

Will i need the access of mysql to transfer the files or is there any other way to do it?

I'm really sorry again, as i said i really lack knowledge in these parts unfortunately

I will leave this to someone more technical than me to address.

The way I imagine it now is you place a temporary home page that says something among the lines that "We are experiencing technical difficulties and moving our server to a new location. We will try to resolve this matter in the shortest time. Thank you for your patience." Don't put nothing else.

In the meantime, you ask GoDaddy to unsuspend your site so that your clients can see that you are not gone. Once they give you access to the account, you ask your new hosting provider to help you move the databases over (or you can attempt to do it yourself by generating a full backup of your site). I'd rather ask your new provider to do it for you though.

That's about it. You move, you close your account with GoDaddy and live happily ever after.

What is your budget for hosting? Can you afford $10.00 -$20.00 a month? if so there are plenty of vps provider that we can get you with that would be more than happy to help you move over to them and we know are stable.

no host will unsuspend for this reason.

just say you need access to do a full backup of your site or if they can provide you with a backup

Thanks alot guys,
@24khost, that will definitely be a fine range for me.

@easyhost, Yup that's what my cousin told me and said to me send them following :

"We have disabled the Query which overloaded the database
and we will soon redesign our db to avoid overloading

Kindly allow access to our db so that we will re-design it."

Hopefully they will allow access or all my 50k plus pages will be deindexed by google if i can't find a solution.

Just can sit and pray for the best.

If you have been blocked from accessing the administration page for your database, you should contact GoDaddy asking for an export of your SQL database. With this export you should then be able to import it into another MySQL Server.

However.. With such a large database you may experience problems with importing through a web page in one large sum. I would recommend once you receive the export you split it into more manageable imports. If you do head over to a VPS I would probably recommend importing the database by uploading the database to your server and importing it via command line.

There are scripts/programs which can help with importing the large database,

As others have already said, find a good VPS host first. Then ask GoDaddy to allow you to access your files and database once more. Once you have access to your files again, kindly ask your new host to move your website for you to their servers. If they are any decent at all, they will take care of the move for you. All you have to do then is change your domain's nameservers to point to your new hosting provider after the move is complete.

*WE* unsuspended people all the time for reasons as stated and redirect to a single page. Posting a simple page to alert users that you're not gone, is a pretty big priority. We do this for people who are moving from shared to VPS or VPS to Dedicated servers on a regular basis. We have also ha no issues contacting other hosts requesting access to post a temporary file while we remove files, databases & emails in order to migrate the user away from them.

I've never personally had an issue NOT getting that done with just a very simple request.

OP suspended for network abuse, so they would not be unsuspended until we did a full investigation as to unspended will just reativate the bd again

Guess it depends on the host. On our end, we run a permanent redirect on with an .htaccess file (owned by root so the user can't overwrite it) and point it to a single file. This stops ALL processing of all files on the site except for the one designated.

It still allows the user full FTP access to access their site to retrieve their files, databases and full access to their email and control panels.

Suspension, through the use of an account suspension, can have a negative effect on any emails or communication, but it all depends on how the host operates.

For us - routing all traffic to a single file, while permitting a single IP address so the user (or webmaster) can test and repair their site - that seems to always have worked best for us and our clients in the past.

Might be something to consider for the future