Eimer Music

This is another MySQL trick I keep coming back to. mysqldump -u root –password=pass db1 | mysql -u root –password=pass db2 found @ http://mywheel.net/blog/index.php/2006/01/05/mysql-duplicate-database-quick-tip/

When you need to switch a fields collation you can check if any existing data will conflict with this change. For example a keyword-field might contain data that is considered unique in one collation but not in another. The Swedish character ä is considered a unique character in swedish collation but in general collation it [...]

The unix cp command makes you the owner of the copied files. You can set flags but this is supposedly a more complete way to keep any attributes. mkdir /var/backup/michael cd /home/michael tar cf – . | (cd /var/backup/michael && tar xBfp -) found @ http://info.michael-simons.eu/2007/03/18/copy-directories-and-preserve-permissions/