Hosting transfer & frustrations

[Silky]

Hi,

Our forum crashed recently and apparently it's because we've blown the database capacity on the server. We're with Webfusion and have decided to upgrade to a new server but they claim we can only transfer our database in chunks of 8MB (!). As the forum database is in gbs, this is something that will take ages to break down. We haven't had advise from Webfusion on how to reconstitute this at the other side either...

Has anyone come across this before or is this just Webfusion? It's unbelievable that they're insisting on 8MB chunks, it's almost back to the days of floppy discs. We've asked if they could remove / increase the cap for the transfer of the forum, needless to say the frontline support people we get are unable to do this and the engineers are just not getting back to us.

If anyone can throw any light on this we'd be grateful, it's proving frustrating to say the least.

Thanks,

Silky

[sanjiv]

I am assuming you are running a VPS ?

This 8mb limit is set by PHP however you should be able to increase it by making changes in php.ini. Another way of doing it may be to just copy over the whole database file and pasting it into the new server.

[stugster]

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

[openmind]

Do you have command line access via SSH? (assuming this is a Linux server of course)

[openmind]

I am assuming you are running a VPS ?

This 8mb limit is set by PHP however you should be able to increase it by making changes in php.ini. Another way of doing it may be to just copy over the whole database file and pasting it into the new server.
The database file? What would that be then?? Copying and pasting MySQL folders is a very bad idea as it could/would lead to DB corruption and is also impossible if any of the table use InnoDB as the storage method.

[Virtuo]

I agree with stugster. Get your webhost or yourself in at command level and just do a database dump. Then you can copy the one (rather large?) file wherever you need it to be and import it onto a new server.

[Lukejenx]

I would try backing up as much as you can first though.

Or just take back ups of recent posts, all users and start fresh. But that is not really a good option IMO.

[Silky]

Thanks everyone for your replies to this, we're really struggling.

If anyone's got experience of this and would be able to help, please message me - it looks like we're going to have to contract this out.

Thanks,

Silky

[stugster]

Do you have command line access, control panel, or anything?

We can probably do this for you if we have enough access to the system.