Restore Mysql Database from your Backup folder

[computerbar]

Say you have made a backup of your database and it is about 50MB.
you can not upload/import more than 10MB in phpmyadmin
so how you do it?

I have just found out this BigDump today and thought would share it with you.

follow instructions below

download bigdump from here about 10Kb http://www.ozerov.de/pphlogger/dlcou...de/bigdump.zip

Unzip and you will find bigdump.php
open it with any text editor (notepad)

Find this and replace ENTER with your database details etc

// Database configuration

$db_server = 'ENTER';
$db_name = 'ENTER';
$db_username = 'ENTER';
$db_password = 'ENTER';

then Create the working directory (e.g. dump) on your web server and CHMOD it to 777.

Move/Upload bigdump.php and your dump files (.sql, .gz from pligg backup folder) via FTP to the working directory

Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php

first click on Structure.sql and when it is done go back/start again with database.sql

It worked for me and took only 2 minutes.

full instructions and developer page
BigDump: The Staggered MySQL Dump Importer

hope it would help some pliggers