Get Your Site Content And Files After Domain Expiration – Part 2

In the first article I showed you how to get a backup on your harddrive from a site you can’t access anymore due to letting the domain name expire. In this article, I’m going to show you how to keep the files and database on your hosting and recreate the site in a subfolder of the rootdomain that is linked to your hosting account. However, before we make any changes, follow the steps in the previous article so you have a backup of the old version on your harddrive in case anything goes wrong.

1. Rename the subfolder to the name you want to use

When you added an addon domain, a folder was created with the name of your addon domain. For this example, that folder is named “wpprofitperformance.com”. If we keep the folder name as it is now, our new site would have a URL that looks like this http://yourdomain.com/wpprofitperformance.com. I don’t want to have that second .com at the end of the domain, so I’ll be removing that. If you want, you can rename the folder completely if you want to do so.

When you are in your cPanel, go to your File Manager and look for the folder you want to rename. Make sure it’s selected and then click the Rename button at the top of your screen. Change the name to whatever you have decided on and save your changes.

2. Change your site links to the new link structure

Now comes the hard part, you need to mess around in your database to change all the old links to the new link so your site will work in the subdirectory it is in now. Make sure you know what the name of the database is that you’re working in, if not, find that information in your wp-config file first.

In your cPanel, go to your phpMyadmin and find the database linked to your old blog. When you found it, click on it and open it so you can see the database table structure. At the top of your screen you’ll find different tabs, select the one called SQL

You will be brought to a screen where you can insert SQL queries.

Now enter the following queries one by one and click go for each. Don’t forget to change http://www.old-domain.com and http://www.new-domain.com by your old domain name and new one respectively. Also, if you changed the default table prefix (e.g. “wp_”) to something else, make sure to update it in the queries below.

That’s all there is to it. Some plugins need the site URI. You might need to update that as well. The easiest way to check if another table contains the old domain name is to do a search in PhpMyAdmin (your database -> Search tab -> Select all the tables). It will return all the tables that contain the old site URI and you can then change accordingly as explained above.

About Lady WP

Leslie Bogaerts started working with Wordpress in 2008 when she decided to leave the 9 to 5 grind in order to be a stay at home mom for her two boys. She learned the ropes on her own, mastering the technical ins and outs of Wordpress as well as the nuances of blogging and getting traffic to your blog.

She's successfully setup hundreds of blogs for herself and for her clients over the years. Now she's incorporated her knowledge into a series of Easy Guides so that you won't have to learn everything the hard way like she did.


  1. hello,
    I would like to thank you very much for the article. I reached here by accident through web search but found very useful info as I got two of my sites with domain expired. I will save this page and go to your first article to check it.
    thanks again

  2. Oh awesome, awesome, awesome, great fantastic. Thank YOU. I wasn’t at all expecting the follow up to come so soon, but I’m so glad it did. I need to get this done. Now on my ‘honey do’ list. Thank you.
    Vanessa recently posted…Just One Mom- A Day In The Life OfMy Profile

    • You’re welcome 🙂 I told you I’d add it yesterday and I did. I hope this is of a big help for you. If you run into problems you know where to find me 🙂

  3. I read this through the first time while in the middle of eating breakfast and drinking my second cup of coffee (e.g., I had low blood sugar and hardly any caffeine). At that point I was thinking, “No way can I wrap my head around this.”

    But now that I’m looking at it again, and I see it makes perfect sense. Ah ha — I think I COULD do this using your instructions. But I’d probably just hire you to do it anyway so that my database didn’t blow up or something. 🙂

    Rebecca “Becky” Hagel
    R Hagel recently posted…What’s your product’s biggest benefit? Hmmm, are you SURE?My Profile

    • Becky,

      I’m sure you can do this on your own, it’s not that hard as it seems. But on the other hand, I wouldn’t deny your business if you rather have me do it for you if you ever need it LOL 😉


Speak Your Mind


CommentLuv badge
This blog uses premium CommentLuv which allows you to put your keywords with your name if you have had 9 approved comments. Use your real name and then @ your keywords (maximum of 3)

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.