Server resourse issue with large forum

[Max Taxable]

Originally Posted by SteveC

hey sorry Max but that turned out to be a nightmare. I talked to a salesperson on the phone, gave him all my specs (# of posts, databse size, users etc) and he assured me everything would be fine. Signed up for a 3 year plan and tried to import my VB database. Nothing seemed to be happening so I called tech support. The support person told me the maximum file size I could import is 8mg. My database is 800mg. He told me I could "break it down" but he couldn't tell me how to do it. I really need help here. Can anyone steer me to a reliable host where I can import this database and get my site up and running again?

Eight megabytes? Complete nonsense, the space is unlimited. Are you sure you were looking at the right hosting plan?

Eight HUNDRED megabytes isn't even a large amount of data, it's not even one gig! It's simply not large.

Here is your solution: Create a new database in the host, then import your SQL file to the new database.

[snakes1100]

Max, you can't import that large of a db file through phpmyadmin on their system, they have it limited.

They dont allow ssh either.

He could use bigbump to split it & import it.

They should of been kind enough to offer to import it for him, but at that point, i wouldnt waste my time with them either, they should have offered.

[Max Taxable]

Originally Posted by snakes1100

Max, you can't import that large of a db file through phpmyadmin on their system, they have it limited.

They dont allow ssh either.

He could use bigbump to split it & import it.

They should of been kind enough to offer to import it for him, but at that point, i wouldnt waste my time with them either, they should have offered.

Eight megabytes qualifies as LARGE?

[SteveC]

thank you, Snake. That is exactly the issue. It's not a problem with having a large database on their server. The problem was doing the import. Can you suggest a host that would either allow the import or do it for me? My traffic and # of users are low so I really don't think I need a dedicated server. I just don't want to deleted 75% of my posts because it's a history I'd like to preserve.

[Max Taxable]

Originally Posted by SteveC

thank you, Snake. That is exactly the issue. It's not a problem with having a large database on their server. The problem was doing the import. Can you suggest a host that would either allow the import or do it for me? My traffic and # of users are low so I really don't think I need a dedicated server. I just don't want to deleted 75% of my posts because it's a history I'd like to preserve.

They would import the DB for you if you asked, and like Snake says they should have offered. Don't give up so easily, sounds like you're going to encounter the same issue with any shared hosting.

[snakes1100]

Originally Posted by Max Taxable

Eight megabytes qualifies as LARGE?

Yes, they consider it large because they over sell their vhosting servers on purpose.

Those limits help them oversell it, they dont have to worry about large accounts actually using things like unlimited disk space, which some offer, if they can deter you one way, then respond w/ a response in a support ticket that simply confuse novice website owners, it servers its purpose, ppl simply give up.

[Max Taxable]

Originally Posted by snakes1100

Yes, they consider it large because they over sell their vhosting servers on purpose.

Those limits help them oversell it, they dont have to worry about large accounts actually using things like unlimited disk space, which some offer, if they can deter you one way, then respond w/ a response in a support ticket that simply confuse novice website owners, it servers its purpose, ppl simply give up.

And apparently give up too easily.

[snakes1100]

Yup....

[Max Taxable]

Hey SteveC, are your images in the file system instead of the database? Makes a big difference in db size.

[betterthanyours]

I would suggest you find a real host. If you were happy with godaddy, you'll be ecstatic with a real host.

Please try innohost or for VPS, try prometeus. You'll love it. Prometeus are very cheap (for VPS and the quality they provide)