Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: backing up the mysql database.  (Read 1756 times)

3Pinter

  • Jr. Member
  • **
  • Karma: 0
  • Posts: 61
    • Fromthemill.nl
backing up the mysql database.
« on: January 13, 2007, 07:39:51 pm »

Hi,

Since this whole hacking a cms is supposed to be 'cool' ....... ..... NOT ....

I thought of a nice automatic backup.

I don't if this is possible but here's my thought:
- admin is given the possibility to alter a value: weekly, monthly, yearly.
- dependend on that value, the mysql database is saved as .txt file
- this .txt file is sent to a given emailadress.

In this way one always has a recent backup incase they forget to make one.


3Pinter

Keyrocks

  • Doug
  • ULTIMATE member
  • ******
  • Karma: 449
  • Posts: 6020
  • Semantically Challenged
    • snews.ca
backing up the mysql database.
« Reply #1 on: January 13, 2007, 08:01:14 pm »

As long as your host provides you with C-Panel access to your domain... with phpMyAdmin available... creating back-up .sql dump files is quick, easy and the best way to go. You just need to set up a remnder in your favorite desktop calendar appie and it will tell you when to do your back-ups.

I have not seen auto-backup scripts tailored for any cms database yet. Perhaps there are good reasons for that, security-wise. Also, perhaps, because databases are not necessarily always on the same server as the site itself.

There is this very small php script you can add to your server's Cron Jobs folder (if permitted) and it e-mails backups of your MySQL database to you.

You can sign up for an online service to backup your blog database every 24 hours in 2 places. Or... you can purchase (at low cost) some database backup utilities such as this one that will take care of automatic back-ups for all your databases.
Logged
Do it now... later may not come.
-------------------------------------------------------------------------------------------------
sNews 1.6 MESU | sNews 1.6 MEMU