May 9, 2005 in Feedback
Mysql Backups I am in the process of setting up a very large chat room and I love the IPB! It seems to do everything I can dream of; the main chat room, the blogs, and the on-line chat room
A task to do this could be created.
Surely backup is an aspect of the OS and/or system administrators and should not be the 'responsibility' of an application such as IPB!
Most people not only have an IPB but a web site as well, plus you have to consider all the 'other' applications/packages that may be/are running............
I see IPB as a single application, much like my word processor or speadsheet etc - so does your word processor, spreadsheet or even email client software backup your whole computer?
There is NO commercially available program to make unattended backups and restore the data
This leads me to conclude that the folks at Invision have a sever lack of understanding of the importance of backups
that is one of the most sensible posts made on these forums. Thank you.
What about security?
What about security?
#0 I agree so +1 here
Perry, assuming you are on a Linux/Unix server, you can add a cron entry to back up your databases every day.
00 2 * * * /usr/local/mysql/bin/mysqldump --opt -u (dbusername) -p(username'spassword) ipb_db > /backupdirectory/ipb_db.sql && gzip -f /backupdirectory/ipb_db.sql
This will backup your db every day at 0200 hours, tar it then gzip it.
If you're on a Windows server, I'm sure there's an automated task you can run.
If your host doesn't either take care of backups that you can trust, and/or provide facilities for you to automate your own backups then you are clearly with the wrong host.
I have backups scheduled to run on a daily basis for my IPB-based site which are completely unattended. Whilst I just have them stored on the server, I can download them to my own computer if I like (which I do around once a week - site is still in development so not much DB side changes), and I can have them transferred to another location via FTP as part of the backup process.
I completely agree that IPB should NOT be responsible for backing its database file up - even if you don't have any other site infrastructure in your situation, you still have things like site stats, mailbox config (+ mail?) to be backing up so you need an account level solution rather than just worrying about your database!
I have been using it. dbx viewer and dbx file recovery more stable and secure than other programs.
There are three things I want to say regarding this.
1) Backup, Backup, Backup ... Backup often ... Backup to more than one location. There have been many times where I have lost data because of stupid things I did.
2) Do not place COMPLETE faith in your host to actually backup your data - even if you trust them. I know from experience ... six months of one of my communities gone because I did not make recent enough backups and my host did not EVER backup my account (even though I was guaranteed weekly backups).
3) Quick plug - Simna Web Services (http://www.simnaweb.com) offers premium hosting at great prices. Even though we gurantee weekly backups (as my old host did) ... we actually do daily backups to two seperate off-site locations. Which server backups are sent to goes back and forth each day. I don't know of any hosting provider that can say that about their backup systems.
Good idea to have second remotly site/host for backup, many good comapnies out there, one of them is gnax.net, my best.
This topic is now archived and is closed to further replies.
Started 31 minutes ago
Started Wednesday at 04:53 AM
Started 12 minutes ago