Subdomain to website directory blog transferring

Question

I have a blog that is located on a subdomain blog.example.com and I have a main website located on example.com. They both use the same wordpress template.

I'd like to transfer my blog from the subdomain to the directory of the example.com preserving 'recent posts', 'categories' and other blog-ish features.

I know that there is a plugin that allows for importing/exporting wordpress posts, but the main question is, how can I transfer those blog-ish features.

Thanks in advance.

Answer 1

You can just copy your blog files to the domain directory, then look in the MySQL database (with phpMyAdmin, say) and change the siteurl and home rows in the wp_options table to correspond to the new URL. Everything will be preserved, you might have to check and fix the often hardcoded paths to images like template logo and stuff. This is the simplest way.

Answer 2

Other method is to add those two lines in your wp-config.php :

define('WP_SITEURL', 'http://example.com/');
define('WP_HOME', 'http://example.com/');

Then copy the files from blog.example.com to example.com dir and finally replace all urls in database. You can do this with php script:

<?php

    // edit this line to add old and new terms which you want to be replaced
    $search_replace = array( 'http://blog.example.com' => 'http://example.com');

    //change the localhost,username,password and database-name according to your db
    mysql_connect("localhost", "root", "rootpass") or die(mysql_error());
    mysql_select_db("exampledb") or die(mysql_error());

    $show_tables = mysql_query( 'SHOW TABLES' );
    while( $st_rows = mysql_fetch_row( $show_tables ) ) {
        foreach( $st_rows as $cur_table ) {
            $show_columns = mysql_query( 'SHOW COLUMNS FROM ' . $cur_table );
            while( $cc_row = mysql_fetch_assoc( $show_columns ) ) {
                $column = $cc_row['Field'];
                $type = $cc_row['Type'];
                if( strpos( $type, 'char' ) !== false || strpos( $type, 'text' ) !== false ) {
                    foreach( $search_replace as $old_string => $new_string ) {
                        $replace_query = 'UPDATE ' . $cur_table .
                            ' SET ' .  $column . ' = REPLACE(' . $column .
                            ', \'' . $old_string . '\', \'' . $new_string . '\')';
                        mysql_query( $replace_query );
                    }
                }
            }
        }
    }
    echo 'replaced';
    mysql_free_result( $show_columns );
    mysql_free_result( $show_tables );
//    mysql_close( $mysql_link );

?>

Good luck!