Moving My Sub-Domain To Add-On Domain Is Complete

Wednesday, September 15, 2010, 11:38 AM | 60 Comments

On Monday June 21, 2010, I published a post Moving My Sub-Domain Blog To Add-On Domain. The sub-domain is On and Off, I worked on it. It is now done and completely moved to my add-on domain including a few new posts that you will not see them published on my sub-domain which I am going to shut down in a few days by redirecting it to my new Add-On domain.

I had not done this before so as you can imagine, I had lots of problems. My Web Host Support guys were very helpful and they guided me through the whole process. However, I still had problems on every step of the way. That was lack of understanding on my part.

Redirect subdomain to addon domain

The following are the steps I went through to start and complete the Move-Over:

  • Create Add-On Domain

    The Web Host provides the facility of C-Panel where firstly I went through the process of creating the add-on domain That’s one of the functions under “Domain”. You would see it when you scroll down a little. After I created the Add-On, I noticed that I could redirect it, but I didn’t need it so I didn’t do it.

  • Create Email Account

    The second step was to create email address for my Add-On. I scrolled up the C-Panel and clicked on the Email Accounts under “Mail”. I created the address as

  • Install WordPress

    The third step was to install WordPress on my Add-On. In the process, I set up the User ID and password and gave it my address to send me email when the installation was complete.

  • Exporting 4 tables from old sub-domain database

    Using phpMyAdmin under the heading Databases in C-Panel, I selected my old database that I had filled up with my posts – 729 at the time of exporting the database.

    There are two tables that I needed to export to my PC:

    1. wp_postmeta and
    2. wp_posts

    Now I am dumb about the rest of the table. However, for carrying over comments, I exported 2 more tables:

    1. wp_commentmeta and
    2. wp_comments

    Before I exported the data in these tables, I went over How to optimize your MySQL database for better performance. Once the overheads were cleared, I exported all four tables mentioned above to my PC desktop.

  • Modifying tables

    Using MS Note Pad, first off, in all tables, I changed the name of the old database to the new one that the Add-On process had given me. I did not make any changes in the comment tables. I made extensive changes in the post tables, especially the wp_posts table. On my desktop, the extension to all tables were dot sql.

  • Importing 4 tables to the new Add-On Database

    Again using phpMyAdmin under the heading Databases in C-Panel, this time I selected the new database of my Add-On Domain, clicked on Import, Browsed for each file on my desktop, selected the files one by one, and clicked on the GO button. Except the wp_posts table, the data in the three tables were imported in less than a minute. However, because of the number of posts in wp_posts, it took a lot more than that.

  • One thing I noticed…

    I logged in to my new ADD-On admin area, created all categories similar to what I had in the sub-domain with some minor changes in the name. I changed finances to finance and careers to career. After importing the data into the wp_posts table, I noticed that all categories were “Uncategorized.” I went over all 729 posts and changed the category from “Unrecognized” to the respective category of the post. This process took a good four days.

In a Nutshell
For me it was difficult at first because I had no idea what I was getting into. But now that it’s done and complete, as the saying goes “I can do it with my right hand tied behind my back.” If you get into a similar situation, try to do one step at a time. Your host service guys are there to help you as My Web Host Support helped me.

Throw us a like at

  1. 60 Responses to “Moving My Sub-Domain To Add-On Domain Is Complete”

  2. By How To Get More Plays On Soundcloud on May 13, 2014, 11:37 pm | Reply

    You could certainly see your expertise in the article you write. The sector hopes for even more passionate writers like you who are not afraid to say how they believe. Always go after your heart.
    How To Get More Plays On Soundcloud recently posted…How To Get More Plays On SoundcloudMy Profile

  3. By p90x3 reviews on May 15, 2014, 12:32 am | Reply

    Good morning. Terrific site. I’m wondering, though, where did you get the theme? Or did you make it for yourself? I’m getting started on my own site and am shopping around for a theme as solid as this one. Thanks so much.
    p90x3 reviews recently posted…p90x3 reviewsMy Profile

  4. By Music Downloads For Iphone on May 15, 2014, 10:28 pm | Reply

    Hello. Simply desired to ask a simple dilemma. I am just assembling my own, personal web site and also would choose to realize wherever you were given your current concept? Has been the item cost-free? Or even seemed to be that paid out? I cannot seem to discover something as well as this place, so ideally you are able to allow me to recognize. Many thanks. PS, the apologies. English is not my own 1st words.
    Music Downloads For Iphone recently posted…Music Downloads For IphoneMy Profile

  5. By home security systems philadelphia on May 16, 2014, 1:36 pm | Reply

    Interesting blog! Is your theme custom made or did you download it from somewhere?
    A theme like yours with a few simple tweeks would really make my
    blog stand out. Please let me know where you got your design.

    Appreciate it
    home security systems philadelphia recently posted…home security systems philadelphiaMy Profile

  6. By free movie making software download on May 27, 2014, 11:56 am | Reply

    Hi there mates, its impressive post on the topic of tutoring and completely defined, keep it up all the time.
    free movie making software download recently posted…free movie making software downloadMy Profile

  7. By buy facebook likes on Jul 16, 2014, 12:57 am | Reply

    Thanks for finally talking about >Moving My Sub-Domain To Add-On Domain Is
    Complete <Liked it!
    buy facebook likes recently posted…buy facebook likesMy Profile

  8. By Kaitlyn on Aug 18, 2014, 5:24 pm | Reply

    Hi to all, the contents present at this web site are in fact awesome for
    people experience, well, keep up the nice work fellows.
    Kaitlyn recently posted…KaitlynMy Profile

Post a Comment on Content of the Article


This is not a billboard for your advertisement. Make comments on the content else your comments would be deleted promptly.

CommentLuv badge