How to move My Sites to a new Content Database and Web Application
A great article below on how to move My Sites from an existing content database to a new web application in SharePoint 2007. Many customers will find this link valuable because having done a database upgrade and not taken the painstaking steps to separate My Sites from the main content database in SPS2003, the My Sites end up in the same content database and web application as the main portal, post upgrade. Since this is against recommended best practice (mixing My Sites with other site templates), the goal is to separate these sites and place them into their own Web Application with a My Site Host site template at the root. The following article outlines the steps that are required to use the new stsadm command mergecontentdbs to achieve this effort.