Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted November 22, 200618 yr 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 !
November 22, 200618 yr 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.
November 22, 200618 yr 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...
November 22, 200618 yr 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.
November 22, 200618 yr 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.
November 23, 200618 yr 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:
November 23, 200618 yr if it's optional it could be very usefull indeed for people with smaller to medium sized databases.
November 23, 200618 yr 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.
November 23, 200618 yr 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!
November 23, 200618 yr 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
November 24, 200618 yr 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.
November 24, 200618 yr Just install the mod. No file edits are required:http://mods.invisionize.com/db/index.php/f/6456
November 24, 200618 yr 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:
November 26, 200618 yr 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.
November 27, 200618 yr 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.
November 27, 200618 yr 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.
November 27, 200618 yr 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 :)
November 27, 200618 yr 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).
November 27, 200618 yr 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. :)
November 27, 200618 yr 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. :)
November 28, 200618 yr 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:
Archived
This topic is now archived and is closed to further replies.