Restoring Database

My friend's forum database is over 600 MB.
He has no SSH access so he cannot restore it. He needs a method that will restore the database quick and smooth.

 

New host would fix it

Who is he hosting with? No phpmyadmin?
scripting would memory error if access to php config is not available.

 

Honestly using phpmyadmin for a 600 MB database would cause many timeouts.
I have no idea where he hosts at sorry

 

Contact new host to do so. Many can do this for free.

 

If you are good at database managment then you can broke the tables and upload it partially. Pm me if need any help.

 

Try using Big Dump, if not ask for help ..PM me

 

send the sql data to the webhoster. they can restore it for ya.

 

I think Big Dump is good

 

even with bigdump it may screw up since php will read a 600mb file soo good chances of screw up best deal is ssh... ask ur host they will do it..

 

Try using sqlyog?

 

Big dump and phpmyadmin are the best choices for this. If the host refuses to upload it for you then defiently try though. Its only 600mb. PHPmyadmin and big dump especially shouldnt mess it up. However a timeout for phpmyadmin could be possible.

Make sure "Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions." is not Checked when restoring in phpmyadmin.

Good luck!!
Amped

 

use bigbump and manual table import addon for bigdump

that way you can import one table at a time using bigdump

this has worked for me a few times

 

Mysqldumper is excellant compaired to bigdump

http://www.mysqldumper.de/en/

Code (markup):

but your host should import it via ssh if you upload the file & open a ticket

 

Thank you for all your help.
I have sucessfully helped my friend restore his server using bigdump.
Thanks again