DB Importing error in Servage

[mecho]

Hi ... i registered in Servage.net and now when i want to restore DB via bump script or anyother way i got error ..

here is the error ( when script want to import a table more than 2000 ) :

Error at the line 1: DROP TABLE IF EXISTS access;
Query: DROP TABLE IF EXISTS access;
MySQL: User 'nameofuser' has exceeded the 'max_updates' resource (current value: 20000) i import db via phpmyadmin . but i get error too .. db was no import completely ...

any idea that would be great :(

Thanks ( sorry for my bad English )

[Kerry-Anne]

You will need to contact your host about this as it is due to a limit on the amount of queries that they have set.

[mecho]

Thanks .. i will contact them but they said there is a limit and ....... anyway it fixed now . thanks for help .

but i have another question about this server . after 4 or 5 hours i get Warn Email about HIGH LOAD !!! they said users allow to have 400,000 hits perday and when u get 300.000 this warnings will send automatic ! but i never have that amount hits !! i asked them to tell the main reason but also i want to ask u tell me what's the reason of high load . i have this problem always :( but i dunno what it is and what can i do for control it .

Thanks in Advance

[Steve Machol]

That is another artificial limit imposed by your host. Frankly I'd start looking for a more suitable host, and wickly.

[mecho]

yea as u said that is another limit :(

they said this :
Here is definition of how we count hits:
Each time a Web server sends a file to a browser, it is recorded in the server log file as a "hit". Hits are generated for every element of a requested page (including graphics, text and interactive terms). If a page containing two graphics is viewed by a user, three hits will be recorded - one for the page itself and one for each graphic. Only one page view will be recorded.

do u have any idea how can i make this hits lower ?? i have no idea :(

[Kerry-Anne]

As Steve said, you are going to be best looking for a more suitable host and quickly as you are going to keep hitting these limits and there are a lot of other hosts available which do not have such low restrictions on usage.

[mecho]

yea they said this :
400000 hits/day/account is enough limit, You can check which script getting more hits and you should know why it gets this much amount of hits. If this is because of poorly written script/bugs, please contact with your programmer/search the internet to optimized the script.

how can i find that script that they said ?

[Steve Machol]

Find another host unless you are happy having your forums shutdown on a regular basis.

[mecho]

i find otherone . they said we dont have such this limit perday . but !! there is a limit that u can not have more than 30hits per minute :(( how can i understand and find the per days hits in my site ...

what the hell is these rules and limits !!

[Steve Machol]

Please provide the name of this host as a warning to oithers.

[mecho]

sure .. i put their name in the title

" Servage.Net "

anyone can help me to find a good host without these limits :(

[mecho]

i talked with another host . they looks great . they said have just this limit :

The connection of user should be less than 50000

what does it mean ?? and how i can understand that amount in my site ?

[Steve Machol]

That sounds pretty bogus. You need to ask them what they mean.

[mecho]

i asked them again he just add this :
The connection of user to DATABASE should be less than 50000

[Steve Machol]

Stay away from them. You will have problems.

[mecho]

Thanks again.. i talked to them again and they said :
the connection of the database user to the database should be less than 50000 per hourso is it still make a problem ?


another hosting words :
simultaneously database connection limit - is 50 and webserver is 100 ......
in one moment of time maximum of 50 connections.how about this ?

[Steve Machol]

You are free to ignore our advice if you want but I would stay away from any host that imposes these kinds of limits. There are far better hosts to choose from.

[mecho]

no i dont want to ignore ur advice . otherwise i never ask u about these problems !!

would u plz give me some good host without these limits ?!

Thanks

[Steve Machol]

Sorry but we don't provide official recommendations for hosts. I suggest you view the vBulletin Hosting Options forum for advice from other customers:

http://www.vbulletin.com/forum/forumdisplay.php?s=&forumid=11

Also checkout this site:

http://www.webhostingtalk.com/

[mecho]

thanks ...

but the point is i requested for fix my problem or cancel my account ! they cancel my account after 1second !!!!!!!!!! then i request for backup they said
Feb 14 - 16:06 GMT
Servage - Patricia
Hello .....,

It is unfortunately technical not possible when the account is closed. We are sorry about that.

Kind regards,
Patricia, Servage Hosting