MyBB Community Forums

Full Version: Backing Up the Database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Just wanted to give everyone an idea on how to make good backups of their database. What i've done is gone and found the Windows GUI interface for MySQL, and used the Backup function. You can set to automatically run at a particular time, and it'll make a new backup with a timestamp on the sql file for the times that you specify.

For example, I set mine to backup the database at 3:00 AM, and it makes a new copy with the name: (name of db)-(date)(time).sql

Just an idea.
Brandon
Another really good tool is MySQLDumper which can be started by using a cronjob and sends the dump via Email or via ftp to another webspace. Wink
Good "Handling Information" advise here for backing up databases.

Hmmm, this has got me giggling, as I refer to a 'dump' as something else. Big Grin He he
wow, thanks for this tip, it's really useful (mysqldumper)

:ok:
FraGe
For us nix users here, I don't think that dumper works; correct me if I'm wrong.
us nix?
UNIX?
why not?
FraGe Wrote:us nix?
UNIX?
why not?

My bad, I didn't think that dumper did... my mistake.
Smile
I guess I was thinking that you were thinking ...

good night Smile
FraGe