migrate wordpress from sub-directory to root and update Permalinks

user

14 years ago

Migrage from www.hang321.net/blog to www.hang321.net

1. backup
tar zcvf blog.\bin\date +%Y%m%d.tar.gz blog/

2. Move
mv * ../

3. edit wp_options table
LIKE %hang321.net/blog%
manually replace to hang321.net/ (could be done by sql too, but only couples of entries to modify)

4. change permalinks
change from ‘Numeric’ to ‘Day and name’, all links broken, especially from Google.
find a plugin, called permalinks-moved-permanently, generate a “301 Moved Permanently” to keep its pageRank
Not work because it look for postname, manually edit the query from post_name to ID

if( $ID = $wpdb-&gt;get_var( 'SELECT ID FROM '.$wpdb-&gt;posts.' WHERE ID = "'.$slug.'" AND post_status = "publish" ' ) ) {

1	if( $ID = $wpdb->get_var( 'SELECT ID FROM '.$wpdb->posts.' WHERE ID = "'.$slug.'" AND post_status = "publish" ' ) ) {

Done!