Restoring Backups

[ULTIMATESSJ]

How would i go about restoring a backup of my forums, since the backup i made is 7.21MB and can't possibly be uploaded that way

[Ember]

Find someone who can, you'd need to use PHPmyAdmin to restore it, just run the .sql file on the database. You'll have to upload it at some point otherwise how can you restore it :P

[ULTIMATESSJ]

well it's over 7MB, and won't upload that way very easily

[Ember]

Its possible on 56k, I've done an 8mb one! Why not get one of your trusted mates with broadband to do it?

[ULTIMATESSJ]

lol i have Broadband, but it still takes forever

[Xenon]

@Orange: on most servers there is a 2MB limit for uploaded files. It has nothing to do with your bandwith.

@Ultimate: As i remember right, there is a backup/restore hack in the betasection which can work on FTP-uploaded sql files

[Ember]

2mb upload limit? heh... not on mine :P hehe!

Hope you get the problem sorted Ulti.

[ULTIMATESSJ]

yep, just found that theres a 2MB limit, and it looks like the host won't upload the mysql for us, does anyone know any other way, i can't do seperate backups, because some individual tables take up over 2MB anyway

[Xenon]

as i already said:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=37655&highlight=backup+restore

[ULTIMATESSJ]

already tried it, doesn't effect my database at all when i use it

[ULTIMATESSJ]

anyone know any other way of doing this, our host won't do it for us, saying something about the database changing to small memory heaps or something like that

[Ember]

Sorry, I have absolutly no idea... can you not even upload the file to your server space? If you could then you could use phpmyadmin (I think)... There may only be a 2mb tmp limit, so if you could get it onto the server space then it would just be transferring it...

unless you did it a bit at a time, do you know much about SQL? If you open up the file you will see its divided into CREATE arguments and others, so if you did some at a time then it wouldnt be over 2mb!

Other than that, I have no idea.

[ULTIMATESSJ]

Originally posted by Ember
Sorry, I have absolutly no idea... can you not even upload the file to your server space? If you could then you could use phpmyadmin (I think)... There may only be a 2mb tmp limit, so if you could get it onto the server space then it would just be transferring it...

unless you did it a bit at a time, do you know much about SQL? If you open up the file you will see its divided into CREATE arguments and others, so if you did some at a time then it wouldnt be over 2mb!

Other than that, I have no idea.

i can get it uploaded to the server space, but how would i be able to run it from that with phpMyAdmin, plus i've tried to open the file, but it's just so big it takes forever to copy and paste things from inside when you are using wordpad