# rsync -avz /usr/local/mailman/lists root@new-server:/var/lib/mailman/

Migrating mailman lists

Truecrypt HOWTO:

http://blog.gnu-designs.com/truecrypt-on-linux-with-xfs-and-ext2ext3-volumes

Format as ext3 FS:

Here’s how I created a Ext3-filesystem in a external Truecrypt device.

truecrypt -l

gives you information about your mounted Truecrypt drive. Typical output:

/dev/sde2 /dev/loop0 /media/truecrypt1

You need to unmount the volume using

sudo umount /media/truecrypt1

Then you can format the volume (the encrypted volume that is):

sudo mke2fs -j -m0 /dev/loop0

This will format your encrypted volume into Ext3.

When finished, just Dismount it using the Truecrypt GUI, and then mount the whole thing again. Now, you’ll have an encrypted Ext3-formated volume!

Arctic Linux: Ext3 in Truecrypt 5.1a

$ mysqldump –default-character-set=latin1 –databases wordpress > m.sql

$ replace “CHARSET=latin1″ “CHARSET=utf8″ \
“SET NAMES latin1″ “SET NAMES utf8″ < m.sql > m2.sql

$ mysql < m2.sql

wp-config.php:
define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);

atppp’s Blog » Convert WordPress database from Latin1 to UTF-8

max_connections = 500
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M

key_buffer_size=512M
table_cache=2048
sort_buffer_size=32M
read_buffer_size=16M

http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php
http://www.professionalmiddleman.com/blog/2007/10/mysql-table-is-.html
http://rackerhacker.com/mysqltuner/

you’ll want to change this line in /etc/my.cnf from:

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

to

innodb_data_file_path = ibdata1:10M:autoextend

Professional Middleman: MySQL table is full error on Gentoo Linux