Icy Phoenix

Documentation And How To - DB - BigDump - Backup And Restore BIG Databases

JHOSMAN [ Sat 16 Feb, 2008 01:02 ]
Post subject: DB - BigDump - Backup And Restore BIG Databases

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

Code: [Hide]

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

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

Code: [Hide]

http://yoursite.com/dump/bigdump.php

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)

Code: [Hide]

$db_connection_charset = 'utf8';

TheSteffen [ Sat 16 Feb, 2008 01:52 ]
Post subject: Re: BigDump, Restores BIG Databases

Thanks JHOSMAN,

I will test it

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

KasLimon [ Sat 16 Feb, 2008 10:19 ]
Post subject: Re: BigDump, Restores BIG Databases

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

Thanks!

JHOSMAN [ Sat 16 Feb, 2008 20:19 ]
Post subject: Re: BigDump, Restores BIG Databases

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

whiskey_pete [ Sat 16 Feb, 2008 22:37 ]
Post subject: Re: BigDump, Restores BIG Databases

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

Press 22 [ Sun 17 Feb, 2008 02:26 ]
Post subject: Re: BigDump, Restores BIG Databases

Worked like a charm!

Harimau [ Sun 17 Feb, 2008 03:03 ]
Post subject: Re: BigDump, Restores BIG Databases

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

http://www.heidisql.com/

Gr Ron

JHOSMAN [ Sun 17 Feb, 2008 19:04 ]
Post subject: Re: BigDump, Restores BIG Databases

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

darkone [ Thu 21 Feb, 2008 17:23 ]
Post subject: Re: BigDump, Restores BIG Databases

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-

Funky [ Wed 30 Jul, 2008 20:52 ]
Post subject: Re: BigDump, Restores BIG Databases

Thanks

Mighty Gorgon [ Sun 03 Aug, 2008 10:23 ]
Post subject: Re: BigDump, Restores BIG Databases

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!

Funky [ Sun 31 Aug, 2008 12:33 ]
Post subject: Re: DB - BigDump - Backup And Restore BIG Databases

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