January 1, 2008

 Script to backup entire atmail system

Here is a small script which copies and gzips the entire atmail system to a single file. This allows for the resulting file to be copied elsewhere (the script FTPs it to another server) for safe keeping. The file contains everything required to restore the atmail system.Copy and save it to a script and then set a cron task to run it to backup the entire atmail system.

(more...)


Filed under: Backup — info @ 12:00 pm

 

 Creating an @Mail server mirror

Question:I have two servers for @Mail, and I want to create a secondary machine as a "cold" backup solution in case the main machines goes down. How can I configure two servers to achieve this?

Answer:Using the multi-server license of @Mail you can install the software on two machines, and use a secondary server as a backup solution.

(more...)


Filed under: Backup — info @ 12:00 pm

 

 Excluding MySQL tables during mysqldump

Excluding MySQL tables is not included in some versions of MySQL. Here's a bash script that can do just that:- create a file called mysqldump.sh

- in the file, put:

#!/bin/sh
for TABLE in $(echo "show tables" | mysql -u [mysqluser] -p[mysqlpassword] [atmaildatabase] | grep -v Tables_in_ | grep -v [Excluded Tables])
do
mysqldump -v --add-drop-table -u [mysqluser] -p[mysqlpassword] [atmaildatabase] ${TABLE} > [mysqldumpfile.sql]
done

(more...)


Filed under: Backup — info @ 12:00 pm

 

December 6, 2007

 Excluding MySQL tables during mysqldump

Excluding MySQL tables is not included in some versions of MySQL. Here's a bash script that can do just that:

- create a file called mysqldump.sh

- in the file, put:

#!/bin/sh
for TABLE in $(echo "show tables" | mysql -u [mysqluser] -p[mysqlpassword] [atmaildatabase] | grep -v Tables_in_ | grep -v [Excluded Tables])
do
mysqldump -v --add-drop-table -u [mysqluser] -p[mysqlpassword] [atmaildatabase] ${TABLE} > [mysqldumpfile.sql]
done

(more...)


Filed under: Backup, Linux version — info @ 2:53 pm

 

March 26, 2007

 Exim system-wide message archiving

Sometimes, you will need to archive all messages that pass through your @Mail/Exim installation.This can be useful if you require all messages to be logged for archival/securtiy purposes.

Both incoming and outgoing messages can be logged to a central maildir directory. To enable follow the steps below:

(more...)


Filed under: Backup, Exim, Linux version — info @ 6:06 pm

 

December 15, 2004

 MySQL Archive Script

It is highly recommended to use a script which automatically backs up the database.Using the script you can setup a daily-cronjob which automatically backs up the mySQL database used by @Mail.

The script will keep an archive of backups for 7 days, and will automatically prune old archives, allowing you to rollback the database to a specific day.

(more...)


Filed under: Backup — info @ 8:39 am

 

December 4, 2004

 Backup Addressbook Data for a selected user

Common question from clients is how to backup a selected user-addressbook, without having to dump the entire database.Solution below:

Login to the server running @Mail and run the command:

(more...)


Filed under: Backup — info @ 2:52 am