October 2008
MonTueWedThuFriSatSun
« Aug Nov »
 12345
6789101112
13141516171819
20212223242526
2728293031 

Month October 2008

Entries 3 Total

Duplicating a mysql database

Oct 8, ’08 6:55 PM

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/

Comments (0)

Locating potential duplicate before switching collation in MySQL

Oct 7, ’08 6:27 PM

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…

Comments (0)

Copy files while preserving permissions

Oct 6, ’08 6:26 PM

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/

Comments (0)