Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post DB - BigDump - Backup And Restore BIG Databases 
 
//Believe should leave this as post it

BigDump, restores BIG databases

mysqlke5

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: [Download] [Hide]
  1. $db_server   = 'localhost';  
  2. $db_name     = '';  
  3. $db_username = '';  
  4. $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: [Download] [Hide]
  1. 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: [Download] [Hide]
  1. $db_connection_charset = 'utf8'; 


bigdump.zip
Description: Bigdump PHP Scrip 
Download
Filename: bigdump.zip
Filesize: 10.13 KB
Downloaded: 734 Time(s)

 




____________
? JHOSMAN - Webmaster
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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"
 



 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: BigDump, Restores BIG Databases 
 
I've heard about this but never tried.
I'll try it

Thanks!
 




____________
Gabriel Anca
 
KasLimonSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 




____________
? JHOSMAN - Webmaster
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: BigDump, Restores BIG Databases 
 
Very useful (and easy to use) script for restoring big databases
 




____________
Icy phoenix websites: dimitrovgrad4U.com | WorldBiology.net
 
Last edited by whiskey_pete on Tue 01 Jul, 2008 21:00; edited 1 time in total 
whiskey_peteSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: BigDump, Restores BIG Databases 
 
Worked like a charm!
 




____________
Running two Icy forums on one server
 
Press 22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 




____________
Gr. Ron

Team "Dutch"

?If you have accomplished all that you have planned for yourself, you have not planned enough."
 
HarimauSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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  
 




____________
? JHOSMAN - Webmaster
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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-
 




____________
Check out my new website:
Adult Forums - A place where everyone can fit in.
Currently running v1.1.10.25 RC3
 
darkoneSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: BigDump, Restores BIG Databases 
 
Thanks  
 



 
FunkySend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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!
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
FunkySend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML

HideSimilar Topics





 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron