A billion apologies to Thales (deleted thread)

[Anonymous]

You should do a daily mysql database backup. It is a very simple command:

mysqldump -u root --all-databases --password=${passwd} | gzip > ${backupfile}


Where you put in your password and backupfile with what you want.

eg:



passwd="yourpassword"
backupfile="filename_with_datestamp"

 

[Len]

We do a daily backups of everything onto a remote server, but when we went to retrieve the phpbb backups, we discovered some corruption in the files that we're now investigating.