Welcome to Geeklog, Anonymous Thursday, February 29 2024 @ 11:26 pm EST

Geeklog Forums

database backup script


Status: offline

ajzz

Forum User
Regular Poster
Registered: 01/19/05
Posts: 113
A useful Mysql script was released by Tony Bibbs in 2002, which used a cronjob to make smart daily, weekly and monthly backups.

This does not work with a newer Debian-sarge server due to errors in sql that are probably due to the version of MySQL used (4.x). Can anyone help rectify this, it seems a very good strategy for backing up the database compared to a daily dump.

Thanks,

Ajay
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
I am also looking for intelligent back up solutions especially for multiple webspaces. My customers have no idea about backing up.

Have you tried this: http://www.geeklog.net/filemgmt/singlefile.php?lid=465

I also tried this one: http://sourceforge.net/projects/phpmybackup It is very good as it sends the MySql backup by email or ftp. So I can install it on a customer's webspace and back up automatically.

Unfortunately it doesn`t compress yet.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by ajzz: This does not work with a newer Debian-sarge server due to errors in sql that are probably due to the version of MySQL used (4.x).

FWIW, it's working just fine here on geeklog.net and on another site of mine, both with some version of MySQL 4.

Can you be more specific about what exactly isn't working? After all, it's only calling mysqldump ...

bye, Dirk
 Quote

All times are EST. The time is now 11:26 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content