Restoring large mysql databases

I have had this problem several times - trying to restore fairly large forum mysql databses 40mb-100mb on a webhost where you do not have root access.

You can load the sql dump via ftp to your webspace and get the admin of your web host to restore it for you.
PHPMYADMIN will dump large databases ok but will not restore large databases over http.

I have come across this excellent liyyle php utility for restoring large databases. Load the php file (which you edit with your mysql details) to your webspace along with your sql dump.
The php program will load the sql dump little by little refreshing automatically with javascript.

www

ozerov.de/

bigdump.php

 

 

 

 

Top