//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)

____________
? JHOSMAN - Webmaster

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

Thanks!

____________
Gabriel Anca

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

____________
? JHOSMAN - Webmaster

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

____________
Icy phoenix websites: dimitrovgrad4U.com | WorldBiology.net

Worked like a charm!

____________
Running two Icy forums on one server

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

http://www.heidisql.com/

Gr Ron

____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."

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  

____________
? JHOSMAN - Webmaster

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-

____________
Check out my new website:
Adult Forums - A place where everyone can fit in.
Currently running v1.1.10.25 RC3

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!

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

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