Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Aiheen aloitti: Phphelp - elokuu 22, 2013, 10:36:22 IP

Otsikko: Is there a Backup Database Mod?
Kirjoitti: Phphelp - elokuu 22, 2013, 10:36:22 IP
I did a search and couldn't find one, I'll like to be able to click a button in the admin and have it back up the SMF database.
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: vbgamer45 - elokuu 22, 2013, 10:39:10 IP
There is a backup function built into SMF.

For large forums I suggest doing a dump with phpmyadmin or another db exporting tools
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: TheListener - elokuu 22, 2013, 10:39:27 IP
Admin > maintenance > forum maintenance > database > back up database
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: Illori - elokuu 23, 2013, 05:48:20 AP
Lainaus käyttäjältä: Grumpy Old Sod - elokuu 22, 2013, 10:39:27 IP
Admin > maintenance > forum maintenance > database > back up database

but that backup is known to not be complete depending on host configuration and size of the database.

http://wiki.simplemachines.org/smf/Backup
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: All Colours Sam - elokuu 23, 2013, 12:24:04 IP
Just use MySQL Dumper (http://forum.mysqldumper.de/), if your server has Perl, you can configure a simple cronjob to automatically create backups and having them mail to you every X days and forget a bout having to back up manually.
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: emanuele - elokuu 23, 2013, 12:59:47 IP
Lainaus käyttäjältä: Phphelp - elokuu 22, 2013, 10:36:22 IP
I did a search and couldn't find one, I'll like to be able to click a button in the admin and have it back up the SMF database.

You should really upgrade, the version you are running is terribly outdated and full of critical security issues...
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: Arantor - elokuu 23, 2013, 01:01:29 IP
Yeah, 2.0 RC3 is a bit outdated and insecure these days (and I didn't even find that from the footer ;D)
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: Sir Osis of Liver - elokuu 23, 2013, 03:02:05 IP

phpmyadmin dumps do not work on some hosts due to timeouts.  Any method you use, do several backups, and see if the file sizes are the same.  A bad backup often does not generate errors, so you'll believe you have a good one when you don't.

And don't use the SMF admin backup.

Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: Phphelp - elokuu 23, 2013, 04:37:53 IP
I just took it over and I agree I need to upgrade.  I'm just dreading putting back in all the customization.

I am using MySqlDump on a schedule Job now and I'm dumping it to my skydrive sync folder, so the storage is off site.  (Which is pretty cool)

Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: vbgamer45 - elokuu 23, 2013, 04:48:48 IP
I like to use beyond compare to merge changes back and forth if you did custom work to the forum.
Otsikko: Re: Is there a Backup Database Mod?
Kirjoitti: Phphelp - elokuu 23, 2013, 10:00:22 IP
Yay! I did it, everything is upgraded and re-modded - It was a lot of work... OMG

Thanks for making me do this! I just needed a little push.