[BETA]Backup Pro -For big database backup and restore

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Ideas Centre
User avatar
MikovChain
Registered User
Posts: 137
Joined: Tue Aug 29, 2006 9:19 am

[BETA]Backup Pro -For big database backup and restore

Post by MikovChain » Sun Oct 25, 2009 1:51 pm

MOD Title: Backup Pro
MOD Description: Backup/Restore big databases in spite of the server limits. For MySQL databases only.
MOD Version: 1.0.0 for phpBB 3.0.5 ( should support all 3.0.x versions)
MOD Download: http://www.phpbbchina.com/download/phpb ... _1.0.0.zip
Demo Board: N/A
##############################################################
## MOD Title: Backup Pro MOD
## MOD Description: Backup/Restore big databases in spite of the server limits
##
## MOD Author: IOsetting
## http://www.phpbbchina.com
##
## MOD Version: 1.0.0 for phpBB 3.0.5 ( should support all 3.0.x versions)
## Installation Level: easy
## Installation Time: 5 minutes
##
## Files To Edit: 1
## language/en/acp/common.php
##
##
## Included Files:
##
## adm/style/acp_databasepro.html
## includes/functions_databasepro.php
## includes/phpzip.inc.php
## includes/acp/acp_databasepro.php
## includes/acp/info/acp_databasepro.php
## language/en/acp/databasepro.php
##
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##
##############################################################
## MOD History:
##
## 2009-10-25 - Version 1.0.0
##
##############################################################
##
## Before Using This MOD On Your Forum, You Should Test It In You Testing Environment
##
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD, And Back Your Database
##
##############################################################

#
#-----[ COPY ]------------------------------------------
#

copy adm/style/acp_databasepro.html
to adm/style/acp_databasepro.html

copy includes/functions_databasepro.php
to includes/functions_databasepro.php

copy includes/phpzip.inc.php
to includes/phpzip.inc.php

copy includes/acp/acp_databasepro.php
to includes/acp/acp_databasepro.php

copy includes/acp/info/acp_databasepro.php
to includes/acp/info/acp_databasepro.php

copy language/en/acp/databasepro.php
to language/en/acp/databasepro.php


#-----[ OPEN ]------------------------------------------
language/en/acp/common.php

#-----[ FIND ]------------------------------------------

Code: Select all

 		'ACP_BACKUP'				=> 'Backup',
#-----[ AFTER, ADD ]------------------------------------------

Code: Select all

 		'ACP_BACKUPPRO'				=> 'Backup Pro',
#-----[ FIND ]------------------------------------------

Code: Select all

 		'ACP_DATABASE'				=> 'Database management',
#-----[ AFTER, ADD ]------------------------------------------

Code: Select all

 		'ACP_DATABASEPRO'		=>  'Database management Pro',
#-----[ FIND ]------------------------------------------

Code: Select all

 		'ACP_RESTORE'				=> 'Restore',
#-----[ AFTER, ADD ]------------------------------------------

Code: Select all

 		'ACP_RESTOREPRO'				=> 'Restore Pro',
#
# Configuration
#
#-----[ OPEN ]------------------------------------------
includes/acp/acp_databasepro.php

#-----[ FIND ]------------------------------------------
$archive_store = 'somewhere';

#-----[ CONFIG ]------------------------------------------
$archive_store - This is the folder where your compressed archive will be stored in. Change it to some other names for security sakes.

#
# Install/Uninstall
#
Copy update_module_databasepro.php
to update_module_databasepro.php

Run install/uninstall script from your web browser

Code: Select all

* Install: http://Your forum root url/update_module_databasepro.php?m=install 
* Unistall: http://Your forum root url/update_module_databasepro.php?m=uninstall
After installation, you will find "Backup Pro" and "Restore Pro" in ACP->Maintenance->Database section

Important:
In backup and restore operations, you should use an admin account with a user_id < 100. If you use an admin account with large user_id, you may lost your admin session during the restore.
Because the restore is performed piece by piece, a user with large user_id may not be restored in the first restore step of the users table, then the forum ACP will deny the visits.

When the backup and restore is running, don't try to click the "next" links -- unless the browser doesn't redirect the page automatically.


Be noted:
Before Using This MOD On Your Forum, You Should Test It In You Local and Production Environment, and backup your database.

The author of this MOD won't be responsible for any data losses in your using of this MOD.


Download 1
Download 2

Scofield112
Registered User
Posts: 87
Joined: Sat Feb 02, 2008 11:39 am

Re: [BETA]Backup Pro -For big database backup and restore

Post by Scofield112 » Sun Oct 25, 2009 3:37 pm

Will it work with database larger than 1GB ?
Thanks for reply
Sorry for my bad English :)
Image
Image

User avatar
MikovChain
Registered User
Posts: 137
Joined: Tue Aug 29, 2006 9:19 am

Re: [BETA]Backup Pro -For big database backup and restore

Post by MikovChain » Sun Oct 25, 2009 5:29 pm

Scofield112 wrote:Will it work with database larger than 1GB ?
Thanks for reply
Yes, as long as you have enough space quota.

Except the compress&download function, it can not work with a too large database. On my machine it can compress a 60MB db before hitting the time-out.

Even if so you can download the whole folder via ftp anyway.

User avatar
Ahri89
Registered User
Posts: 516
Joined: Sat Apr 07, 2007 2:53 pm
Location: Spain
Contact:

Re: [BETA]Backup Pro -For big database backup and restore

Post by Ahri89 » Sun Oct 25, 2009 6:08 pm

Thanks for this mod
MODs translated to Spanish: ACP Add User MOD, ACP Announcement Centre, Advertisement Management, Custom Profile Fields, Update Reminder, Flood time setting per forum, MOD Version Check, Posting template, Prune Log, Simple Trash Bin, TinyPic Plugin, User Reminder, View Profile, View your topics, and more...

Sorry for my bad english xD

User avatar
katib
Registered User
Posts: 562
Joined: Thu Jun 26, 2008 12:27 pm

Re: [BETA]Backup Pro -For big database backup and restore

Post by katib » Mon Oct 26, 2009 2:35 pm

Thanks for usefull Mod

User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4917
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: [BETA]Backup Pro -For big database backup and restore

Post by VSE » Tue Oct 27, 2009 3:44 am

This is really cool. Have you thought about adding an automated feature to this, like to have it run daily backups, and also an option to keep how many, like keep up to 7 backups, and auto-run once every day for an automated daily backup feature?
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.

darkone_d1_2000
Registered User
Posts: 150
Joined: Tue Feb 13, 2007 7:43 pm

Re: [BETA]Backup Pro -For big database backup and restore

Post by darkone_d1_2000 » Tue Oct 27, 2009 12:51 pm

VSE wrote:This is really cool. Have you thought about adding an automated feature to this, like to have it run daily backups, and also an option to keep how many, like keep up to 7 backups, and auto-run once every day for an automated daily backup feature?
Agreed. This would be very useful, even if you only had the option to save locally on your webserver. Least you would know it's getting done and you don't have the human forgetfulness factor that I have :)


User avatar
^[GS]^
Registered User
Posts: 274
Joined: Sun Aug 06, 2006 10:59 pm
Location: Argentina
Contact:

Re: [BETA]Backup Pro -For big database backup and restore

Post by ^[GS]^ » Thu Oct 29, 2009 3:02 am

Excelent! Very useful! :D

anthies
Registered User
Posts: 162
Joined: Sun May 17, 2009 10:40 am
Location: Finland, Klaukkala
Name: Janne
Contact:

Re: [BETA]Backup Pro -For big database backup and restore

Post by anthies » Thu Oct 29, 2009 3:47 pm

Thanks for the mod, really handy in some cases.

mykee
Registered User
Posts: 271
Joined: Thu Jun 07, 2007 9:46 pm

Re: [BETA]Backup Pro -For big database backup and restore

Post by mykee » Wed Nov 25, 2009 8:34 pm

Please fix links, because I cannot download your mod. Many thanks! :roll:

gamecharmer
Registered User
Posts: 62
Joined: Sat Dec 30, 2006 7:46 am

Re: [BETA]Backup Pro -For big database backup and restore

Post by gamecharmer » Fri Nov 27, 2009 8:26 am

I use this program for MySQL Backups > http://www.dwalker.co.uk/phpmysqlautobackup/

I also use this program for cron tasks (like the daily backup of all of my websites, cron jobs for updating various stuff, etc...) > http://www.phpjobscheduler.co.uk/

mykee
Registered User
Posts: 271
Joined: Thu Jun 07, 2007 9:46 pm

Re: [BETA]Backup Pro -For big database backup and restore

Post by mykee » Fri Nov 27, 2009 8:59 am

gamecharmer wrote:I use this program for MySQL Backups > http://www.dwalker.co.uk/phpmysqlautobackup/

I also use this program for cron tasks (like the daily backup of all of my websites, cron jobs for updating various stuff, etc...) > http://www.phpjobscheduler.co.uk/
Thanks for tip, but I haven't hosting, and I read this: "you will need PHP hosting to use it - or reseller hosting if you host lots of websites"

If anyone downloaded this mod, please upload to any public place please! Thanks!

fasko
Registered User
Posts: 185
Joined: Wed Jan 28, 2009 9:49 am

Re: [BETA]Backup Pro -For big database backup and restore

Post by fasko » Fri Nov 27, 2009 7:48 pm

super program to advance the http://www.mysqldumper.net/

can choose which table will be backup and restored

screen

Image

Down

http://sourceforge.net/projects/mysqldumper/files/
Sorry for my english

User avatar
MikovChain
Registered User
Posts: 137
Joined: Tue Aug 29, 2006 9:19 am

Re: [BETA]Backup Pro -For big database backup and restore

Post by MikovChain » Sun Nov 29, 2009 6:30 am

mykee wrote:Please fix links, because I cannot download your mod. Many thanks! :roll:
Apologies, the server was down during the days 11/26 to 11/27. It has come back to normal, please try again.

Locked

Return to “[3.0.x] MODs in Development”