Icy Phoenix

//Believe should leave this as post it

BigDump, restores BIG databases



Surely more than one of you has a medium forum in future or a huge blog, in the end, any Web application that requires MySQL and occupying much of this space.

When you make backups of a database through applications such as phpMyAdmin or similar, we have a file with the dump of the database when trying to restore some emergency gives mistake.

... And gives us error because it is too big, because it exceeds the timeout or simply because some managers believe very gracious hosting the limit rising to 2 mb dumps, thus ending one by archivitos small or using the ancient technique of "copy paste , copy paste "¬ ¬

In my case, even having dedicated server I can not restore a database by phpMyAdmin because the pure table Posts my forum weighs more or less 1 GB ...

The operation of BigDump is simple, stepwise teach them ...

1 .- We opened with a text editor BigDump file and edit these lines with your DB:



2.-Create in your web folder pongamosle "dump"

3 .- Here we climb the same bigdump.php file and database dumps, which are usually files. SQL and. Gz (even. Zip)

4 .- bigdump call via Web




5 .- From there just select the file you want it to be restored to the base and go! Ñ_ñ

Note: If the database is utf8 or other game characters different from "Latin", then specify the file bigdump.php, editing the following line: (this is an example)

Thanks JHOSMAN,

I will test it :)

EDIT: Topic moved to "Free PHP Scripts" but maybe it should be under "Documentation And How To"

I've heard about this but never tried.
I'll try it 8)

Thanks!

LOL

I'm used this scrip for restore my database of KoKForos.com (I change of server) at time of import in phpmyadmin, prinf error of time of importation :P

Very useful (and easy to use) script for restoring big databases :)

Worked like a charm!

You can also download this program. Them you kan restore your database at any time

http://www.heidisql.com/

Gr Ron

Harimau wrote: [View Post]

You can also download this program. Them you kan restore your database at any time

http://www.heidisql.com/

Gr Ron

Heidisql is a Software
Bigdum is a Scrip that runt direct in your service of hosting :wink:

This script works great I have used it plenty of times when trying to do some conversions of ICY to phpBB3.

Depending on the DB you are importing into make sure you either add the DELETE or CREATE statements or if the tables are clean just do the INSERT statements.

Only bad thing is that it dies on errors and you must clean up and fix the your DB file and start again.


-D1-

Thanks :)

I'll move it to Docs Section, which I think is a more appropriate section.

This section is meant for developers to post their own PHP scripts.

Thanks for sharing!

I think the best download from the original site
There is a new version in beta and work fine with me :)

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