Importing database

[bashy]

Hi peeps

I am moving to a new server, in phpmyadmin it says (Max: 2,048KB)
my database is over 6mb, is there a way around this?

Bashy

[Steve Machol]

Sorry, I don't understand the question. Please explain.

[bashy]

On my new server in the phpmyadmin
I am trying to upload my databse that is 6.27mb

In the phpmyadmin the max upload it will accept is 2mb

Or am i doing this wrong?

Bashy

[Steve Machol]

Have you tried uploading it yet?

Restore with phpMyAdmin:

http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_restore

[bashy]

Hi steve,

Yes i have done this, but this is where the problem lies
Next to the browse button it says (Max: 2,048KB) and my
database is 7.15mb just downloaded it again lol

Therefore i cannot upload my database

Bashy

[Zachery]

You need to ftp your backup to your webserver and ask your host to restore it.

[bashy]

Hi

I was thinking this myself...But.. the db backup is a standard text file.
How can i create a gzip or bzip archive, what program will do this, then i think i will be able to upload it

Bashy

[Steve Machol]

You have to restore the uncompressed text file. If your host won't do this for you then some people have reported success with Bigdump which you can find here:

http://www.ozerov.de/bigdump.php

[bashy]

Hi Steve

Thanks for this, i will give it a try although it does look a little over my head

Bashy

[bashy]

Hi again...

Well that was worth a try....
Didnt work though, albeit i prob did sommat wrong, i dont think so though!

Thanks anyway Steve

Bashy

[bashy]

I have cracked it....Sort of me thinks

I pasted sections of the db in the sql window, got a bit trick when it was too big but i think i got around that...THINK being the operative word!

Its not fully tested yet, not only that my avatar aint showing so something is wrong somewhere lol

Also the attacments appear to be corrupt, any ideas pleas?
Bashy