lisss001 Posted November 22, 2006 Share Posted November 22, 2006 I think that It would be an excellent idea to integrate a features into Invision Powerboard for automatic database backup. This would be a logical and useful feature of the forum software which could be used to either save a copy of the database locally or send it to a specified email addesss in a compressed format. I know that it is currently possible to obtain modifications which can do this, however I feel that it would be even better if it was a part of the forum software anyway. I mean it would help virtually any webmaster restore a board in virtually minutes if a site went down. Also another reason why I would like this to be a prt of the forum software is that not everyone is aware that a modification such is this can be installed. I only even considered using it untill last night when I nearly lost my entire forum community. I think this features should really be implemeneted into IPB ;)Hope you consider it ! Link to comment Share on other sites More sharing options...
Mesmer Posted November 22, 2006 Share Posted November 22, 2006 I don't think it's possible with large db's due to php restrictions. Link to comment Share on other sites More sharing options...
Brandon C Posted November 22, 2006 Share Posted November 22, 2006 There is a modification out there for this out there right now for 2.1.x. I use this modification and I love it. They really need to incorporate this into IPB for 3.0, as it is a vital feature and should not be left as a modification. I fully support this idea and would love to see it in IPB 3.0. Link to comment Share on other sites More sharing options...
Grant Posted November 22, 2006 Share Posted November 22, 2006 I don't think a 2GB DB is going to make it through an email.. Also imagine if a nice big 2 GB database was being backed up on your shared server slowing the machine down a bunch... Link to comment Share on other sites More sharing options...
Michael Posted November 22, 2006 Share Posted November 22, 2006 Incorporating this into IPB will lead to way to many problems, such as busy servers as they try to build a 2GB database file and send it, and full email boxes. According to my Magic 8 Ball, the chances of this getting added to IPB are slim. Link to comment Share on other sites More sharing options...
lisss001 Posted November 22, 2006 Share Posted November 22, 2006 I think this could be done beause some people own their own dedicated servers. Also it could have options such as to only backup the last 1,000 most recent topics and to backup all members. It's really should be added to IPB by default. Rememer not everyone has to use it but I bet a majority of people would. Link to comment Share on other sites More sharing options...
PigFat Posted November 23, 2006 Share Posted November 23, 2006 I don't think a 2GB DB is going to make it through an email.. Also imagine if a nice big 2 GB database was being backed up on your shared server slowing the machine down a bunch...Implement gzip, zip, tar compression as an option for those webmasters with large databases :thumbsup: Link to comment Share on other sites More sharing options...
Guest Posted November 23, 2006 Share Posted November 23, 2006 if it's optional it could be very usefull indeed for people with smaller to medium sized databases. Link to comment Share on other sites More sharing options...
Michael Posted November 23, 2006 Share Posted November 23, 2006 I think this could be done beause some people own their own dedicated servers.Yeah, but most people don't. This won't be added, simply because it will lead to way too many support issues. There are mods that do this, use them. Link to comment Share on other sites More sharing options...
William R Posted November 23, 2006 Share Posted November 23, 2006 With the proper documentation and well written code there shouldn't be a problem. What I mean by Documentation is for example "Documentation on small databases and big databases" and so on. With the busy server load, not hard to set the back up to 4:30 5:00 in the morning ah? Though you need to be careful of the insomniacs. Like me! Link to comment Share on other sites More sharing options...
Mark Posted November 23, 2006 Share Posted November 23, 2006 I have this mod, it gzips it and stores it on my server, deleting the old one. It does this every day at 3am and switches the board offline automatically while it does it.I have a large forum and it rarely takes more than 6 seconds Link to comment Share on other sites More sharing options...
PigFat Posted November 24, 2006 Share Posted November 24, 2006 I have this mod, it gzips it and stores it on my server, deleting the old one. It does this every day at 3am and switches the board offline automatically while it does it.I have a large forum and it rarely takes more than 6 secondsBut have you ever tryed restoring the backups that were backed-uped with that mod?It has some sort of error. Link to comment Share on other sites More sharing options...
Idolized09 Posted November 24, 2006 Share Posted November 24, 2006 Just install the mod. No file edits are required:http://mods.invisionize.com/db/index.php/f/6456 Link to comment Share on other sites More sharing options...
Mark Posted November 24, 2006 Share Posted November 24, 2006 But have you ever tryed restoring the backups that were backed-uped with that mod?It has some sort of error.No, it saves it as a standard SQL file. However 90% of forums will need to upload it in chunks (due to it being too big), or do what I do - get your host to upload it for you :thumbsup: Link to comment Share on other sites More sharing options...
bfarber Posted November 26, 2006 Share Posted November 26, 2006 As Fusoya said, the chances of this getting added are slim. ;)While a large number of sites are not relatively "big" (i.e., mysql size may be around 100 MB), we do have several sites that are enormous. Those 2 GB databases would kill the server.We get tickets as it is on the MySQL backup not working on large databases...an auto backup and restore feature would likely be much more hassle than it is worth.I think people are forgetting that IPB is a forum. It is not an all in one website management system, though it does provide plenty of tools to build this sort of platform from. This isn't really a forum feature if you ask me, and if you want it with IPB, it's better left to a mod. Really, it's better left to your host management or cpanel, in my opinion. But if you can swing it from a web interface, go for it. Link to comment Share on other sites More sharing options...
ellawella Posted November 27, 2006 Share Posted November 27, 2006 In my view, if IPB is to incorporate a DB backup feature, it makes sense to incorporate an optional cron task that dumps a backup to disk every now and again. Link to comment Share on other sites More sharing options...
Michael Posted November 27, 2006 Share Posted November 27, 2006 Did you read any of the reasons for not including it? It may make sense to you, but you're only looking at it from your end, not from the point of view of the people who have to support such a feature. Link to comment Share on other sites More sharing options...
ellawella Posted November 27, 2006 Share Posted November 27, 2006 Did you read any of the reasons for not including it? It may make sense to you, but you're only looking at it from your end, not from the point of view of the people who have to support such a feature.A warning about potential issues that could arise from overly large databases being dumped (memory limits being exceeded, timeouts etc.) could be placed within the description of the cron job. And so on.I was actually making the assumption that people would be smart enough to manage this feature on their own and deal with any un-workroundable problems that may arise by turning it off. Perhaps an assumption too far :) Link to comment Share on other sites More sharing options...
bfarber Posted November 27, 2006 Share Posted November 27, 2006 I was actually making the assumption that people would be smart enough to manage this feature on their own and deal with any un-workroundable problems that may arise by turning it off. Perhaps an assumption too farYou have no idea....it is indeed an assumption that cannot be made. If we include a feature, EVERYONE expects it to work flawlessly, regardless of the reasons that it may not work (such as trying to backup a 2 GB database via a web script). Link to comment Share on other sites More sharing options...
Guest Posted November 27, 2006 Share Posted November 27, 2006 in your backup script just add a check for the size of the database and send a message: database too large, no backup taken. All issues solved. :) Link to comment Share on other sites More sharing options...
bfarber Posted November 27, 2006 Share Posted November 27, 2006 It is easy to say, but then users will submit support requests about why that is the case - if it is a feature it should work.At the end of the day, like I said - IPB is forum software. Not MySQL backup routine software. :) Link to comment Share on other sites More sharing options...
Volvospeed Posted November 28, 2006 Share Posted November 28, 2006 in your backup script just add a check for the size of the database and send a message: database too large, no backup taken. All issues solved. :)Or you just set it up from cpanel. Problem solved :whistle: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.