[high]* Guest210212002 notes that anyone wondering how filburt does that should look at his how-to. :)[/high]

OK so I did the dump overnight. The database according to phpMyAdmin is 210mb... Thegzip of it is 51mb, the gunzipped file is 364mb. Does this sound right? As I've had some trouble with dumps creating databases 600mb in size/being corrupt.

did you try mysqldumper ?

That's what I did the dump with last night.

EDIT:

redspider you have saved my site! I'm eternally greatful. Reimported via SSH on the new server like a dream. I'll be donating to their project, only script that's managed to back up my database and I have tried many!

On a side note, phpMyAdmin says my 'collation' is 'latin1_swedish_ci'. My site certainly isn't Swedish. Is this going to be a problem?

I really dont know the anwser to that one but my guess is no.

all we need is someone to integrate this to vbulletin admin panel and this will make backup so easy for the non guru like me .

I don't think that will be allowed with the license they distribute under. But something of a similar logic would be a huge benefit. The tool included it useless on most servers with a medium to large database. I understand that SSH can solve the issue, but I have just had to move off a server that did not offer SSH - as a result I had a huge struggle getting the DB off the server. I will test the database later tonight when I finish work. :)

let me know if work good for you . Good luck !

It bloody worked!

I really happy for you. :)
all we need now is someone to make a hack that integrate this to vb .

this thing is awesome thanks for pointing me to it <3