This topic was marked solved by Arantor, on May 23rd, 2013, 12:44 AM
request for reliable backup and restore function

abraamz

  • Mmm! Wedge is beautifull!
  • Posts: 15
request for reliable backup and restore function
« on June 1st, 2011, 01:12 PM »
Its all in the title actually. I dont know if it is in someones to do list, but i think something reliable here, at least for new admins could be a life saver. On the other hand someone could say that if you want to be a forum admin you should know how to backup your server.
So what do you think?

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: request for reliable backup and restore function
« Reply #1, on June 1st, 2011, 02:06 PM »
Why should we do this when, to be honest, cPanel has a perfectly good one in it? And those who aren't using cPanel or similar should really know better anyway.

While yes, we could do something with it, I'm really not sure there is anything other than a mediocre solution to be had putting it in the software itself.
When we unite against a common enemy that attacks our ethos, it nurtures group solidarity. Trolls are sensational, yes, but we keep everyone honest. | Game Memorial

Nao

  • Dadman with a boy
  • Posts: 16,063
Re: request for reliable backup and restore function
« Reply #2, on June 1st, 2011, 02:16 PM »
I'm not sure about it either...
Never used the SMF backup feature, so I wouldn't be in the best position to use it.
I'd recommend using BigDump for the transfer of huge database files. (Well, that's what I used last time I needed to do that. Went flawlessly on a small server.)

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: request for reliable backup and restore function
« Reply #3, on June 1st, 2011, 02:17 PM »
Quote
Never used the SMF backup feature, so I wouldn't be in the best position to use it.
It has a horrible habit of crash-and-burn when it hits memory limits, seeing how it invariably attempts to get the entire SQL dump in a variable first, which on a modest sized forum is going to be unpleasant.

abraamz

  • Mmm! Wedge is beautifull!
  • Posts: 15
Re: request for reliable backup and restore function
« Reply #4, on June 1st, 2011, 02:41 PM »
I used SMF backup all the time until i tried to make a local test forum and found out that my "backups" were unusable.[1]
A backup/restore function would be something like a parachute for new admins. Maybe give them a chance to restore stuff after the first fuck up[2].
Maybe a database auto backup every night, overwriting the same file as long as the forum is a small one with an option to disable it for more experienced admins. Its your call, of cource.
 1. encoding problems
 2. a new admin, saved by genius programers, would be for ever in love with wedge  ;) :eheh: :eheh:

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: request for reliable backup and restore function
« Reply #5, on June 1st, 2011, 02:50 PM »
Encoding problems will be less of an issue for us anyway since there's only one encoding ever in use.
Quote
Maybe give them a chance to restore stuff after the first fuck up
Quote
a new admin, saved by genius programers, would be for ever in love with wedge
If the software were that smart, it wouldn't let the admin fuck up in the first place ;)

Norodo

  • Oh you Baidu, so randumb. (60 sites being indexed at once? Jeez)
  • Posts: 469
Re: request for reliable backup and restore function
« Reply #6, on June 13th, 2011, 08:08 PM »
Quote from abraamz on June 1st, 2011, 02:41 PM
I used SMF backup all the time until i tried to make a local test forum and found out that my "backups" were unusable. (Encoding problems)
Sweet mother of Jesus yes the backup is horrid. Would be better to rip it right out, in my opinion, than to keep it. Japanese signs, umlauts, non-standard signs anywhere in any post? Shit's gonna dissapear.

The best way, for me anyway, to back up SMF, has been to do a MySQL dump and then copy paste the folders. I'm sure there are lazier and better ways, but this one works for me... Magical wonderful cronjobs. :)

dazed

  • OK, one more operation to go I hope.
  • Posts: 52
Re: request for reliable backup and restore function
« Reply #7, on June 13th, 2011, 11:57 PM »
I used to use the backup from Admin till I needed to restore a database on one of the sites once...ouch!  >:(

My host does have a backup function in c-panel, so I have been using that. Haven't been so lucky as to have to restore one yet.

Cron job would be cool, but beyond my ability.


Eros

  • I has a thought. Be afraid.
  • Posts: 56
Re: request for reliable backup and restore function
« Reply #8, on June 14th, 2011, 03:40 AM »
Honestly, a guide on how to use mysqldump, cPanel, et al. to do backups and restores would be more useful to people. However, that really isn't Wedge's responsibility to provide. Any php-based backup 'solution' like the one in SMF is only viable until your forum hits 100k posts. Imo.
18+ Roleplay Forum <- hopefully running Wedge when it is ready.

Yaoi RP Forum <- hopefully running Wedge when it is ready.

busterone

  • Posts: 12
Re: request for reliable backup and restore function
« Reply #9, on June 14th, 2011, 03:58 AM »
I have always used SSH and command line dump and import. I have used Big Dump a couple of times for others that did not have SSH access and their db was too large for phpmyadmin to import, but I prefer the command line way myself. 

DoctorMalboro

  • I like rounded borders.
  • Posts: 316

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278