phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Automatic Database saving

Goto page Previous  1, 2, 3  Next
 
Search this topic... | Search MOD Requests... | Search Box
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Author Message
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 665
Location: Texas


flag
PostPosted: Wed Dec 24, 2008 10:07 pm 
Post subject: Re: Automatic Database saving

Unless the MOD author has you modify the database backup routine, any new tables added to your database are not included with the ACP backup. A dump from phpMyAdmin or mysqldump will get the complete database.
_________________
phpBBDoctor Blog
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Wed Dec 24, 2008 10:53 pm 
Post subject: Re: Automatic Database saving

I did not realize that. icon_eek.gif

So what your saying is the backup in the ACP only saves the basic tables that come with a out of the box version of phpbb.com? Skips everything else??well the what good is the backup from the ACP if you have a heavily modded version of phpbb2?

Am I missing something here?

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: Wed Dec 24, 2008 11:29 pm 
Post subject: Re: Automatic Database saving

Making save in ACP isn't highly recommended.
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Thu Dec 25, 2008 1:16 am 
Post subject: Re: Automatic Database saving

Is there a file that I could alter to cover all the tables??

And why is it not recommended?

If the board is unmodded it should work correctly right? If that is the case couldn't the file be modified to cover all sql tables ect?

If there is a problem with that function surely their must be a way to fix it right?

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Ptirhiik
Board Member



Joined: 19 Nov 2008

Posts: 114


flag
PostPosted: Thu Dec 25, 2008 2:07 am 
Post subject: Re: Automatic Database saving

Larges database (and a database is quickly large on a standard board) won't succed in being saved through the acp option. There are numerous tools dedicated to such task, and the best for mysql is definitivaly the mysqldump standard command. A forum is not a blog, nor a site, nor a wiki, and obviously not a database manager. Use the dedicate tool for the appropriate task is what I've learned the hard way.
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Thu Dec 25, 2008 2:17 am 
Post subject: Re: Automatic Database saving

I understand that the backups in the ACP are not very good.

It seams everyone is in agreement with that, but I was wondering why they don't function as designed.

What do they do that makes them fail?

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Thu Dec 25, 2008 8:22 am 
Post subject: Re: Automatic Database saving

Probably we have to add every new table somewhere. icon_confused.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: Thu Dec 25, 2008 8:24 am 
Post subject: Re: Automatic Database saving

SQL Backup MOD

Vic D'Elfant wrote:
Modification description: This MOD will add an additional module to the Administration Panel which will allow you to backup your phpBB database without having to worry about the "Maximum execution time reached" errors, which would normally prevent you from creating a full database of a large database.

Besides backing up the default phpBB tables, it also allows you to select any additional tables that start with the same table prefix as your normal phpBB tables. This will prevent MODs from getting broken if you ever have to restore your database from the backup.
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Thu Dec 25, 2008 8:38 am 
Post subject: Re: Automatic Database saving

That sound nice but I hope it works. icon_biggrin.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: Thu Dec 25, 2008 8:42 am 
Post subject: Re: Automatic Database saving

I have never tested it (I like phpmyadmin xD), so you must read the comments (or make try).
Back to top
Ptirhiik
Board Member



Joined: 19 Nov 2008

Posts: 114


flag
PostPosted: Thu Dec 25, 2008 9:19 am 
Post subject: Re: Automatic Database saving

The main problem is the timeout: as long as your database is growing, it takes much more time to generate the .sql, and eventually too much time for the php allowance. The second is the servers (php+mySQL) load it generates. The third which has to be considered critical since the latest mySQL 4 & mySQL 5 is the requests generated which does not handle all the parameters (collations, engines, procedure if any, ...).

Security is also a concern at some point, as php-based programs are running within the web area, where correctly configured backup process have to run outside the web area.
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Thu Dec 25, 2008 12:22 pm 
Post subject: Re: Automatic Database saving

I like MySQLDumper very much. It can be used with cronjob, is very easy to install, their support is very good etc.

Have a look at it. icon_wink.gif

_________________
phpBB2 will never die, I hope!
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Thu Dec 25, 2008 4:15 pm 
Post subject: Re: Automatic Database saving

Dumper looks pretty nice but I want to stay within the phpbb2 ACP if at all possible because of mine being a multiforum. For Security I will most likely disable upload but allow a download. So they can have their backup at will so they won't feel they are captive. I will of course still do phpmyadmin backups.

So Both Rams suggestion about SQL Backup MOD and dogs and things suggestion have a place for me I think. icon_biggrin.gif

@Ptirhiik Thanks for that info. Thats exactly the information I was looking for. Image link

Image link

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 665
Location: Texas


flag
PostPosted: Fri Dec 26, 2008 2:34 pm 
Post subject: Re: Automatic Database saving

~Cowboy~ wrote:
Is there a file that I could alter to cover all the tables??

Yes, you can... admin/admin_db_utilities.php contains a list of tables to be included in a backup. If the MOD author thought about it, they would include something like this:
OPEN
Code:
admin/admin_db_utilities.php

Special Notes wrote:
On or about line 696; find text might not be a complete line

FIND
Code:
'disallow'

IN-LINE FIND
Code:
'disallow'

IN-LINE AFTER, ADD
Code:
, 'new_table_name'


Quote:
And why is it not recommended?

I believe this has already been answered, but I will reinforce the idea that while the phpBB2 backup utility is adequate for most smaller boards, it is not adequate for larger (MODded) boards in my opinion. It also presents a security risk, as the restore utility can be used to run any sql statement, not just a database restore.

I have used this "back door" to run installation scripts for clients that do not have phpMyAdmin or shell access or any other way of directly accessing the database. icon_wink.gif

_________________
phpBBDoctor Blog
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Fri Dec 26, 2008 4:04 pm 
Post subject: Re: Automatic Database saving

I will be disabling the upload for backups. icon_wink.gif
~Cowboy~ wrote:
For Security I will most likely disable upload but allow a download. So they can have their backup at will so they won't feel they are captive. I will of course still do phpmyadmin backups.


I should not change "disallow" to "allow" ?


What is the best way to disable SQL uploads?

My purpose of having client side backups would only be as I said, to allow people to take their database and go if they feel ready to graduate to their own private installation of phpbb. Disabling uploads would really disable a hackers ability to have an effect on the database through that means I would hope.

I am concerned about the time outs for larger databases though...

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » MOD Requests  Previous TopicPrint TopicNext Topic
Page 2 of 3 All times are GMT
Goto page Previous  1, 2, 3  Next
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0287 seconds using 15 queries. (SQL 0.0016 Parse 0.0009 Other 0.0262)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo