Matthew’s Weblog

http://dev.mysql.com/doc/mysql/en/ANSI_diff_SELECT_INTO_TABLE.html

Very handy!

http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html

# Copy the base files
/usr/share# cp -R wordpress/ wordpress2/
/etc# cp -R wordpress/ wordpress2/

# edit /etc/apache2/sites-available/default to include the second site setup
Alias /blog2 /usr/share/wordpress2
<directory /usr/share/wordpress2&rt;
Options FollowSymLinks
AllowOverride Limit Options FileInfo
DirectoryIndex index.php
</directory&rt;

# Re-link the configs found in /etc/wordpress2
cd /usr/share/wordpress2
rm wp-config.php
ln -s /etc/wordpress2/wp-config.php
rm wp-layout.css
ln -s /etc/wordpress2/wp-layout.css
rm index.php
ln -s /etc/wordpress2/index.php
rm print.css
ln -s /etc/wordpress2/print.css

# set the permissions for /etc/wordpress2/wp-config.php
chgrp www-data wp-config.php

# Edit the configs for the new install in /etc/wordpress2/wp-config.php to appropriate values
# 1) table prefix
# 2) ABSPATH

# Copy tables for permissions and such?
# See my later post!

Rock on!

#debconf php4-mysql

All better!