I have my older post wordpress with domain, example1 where my domain example1 already deleted and I only can access my phpadmin and cpanel.

and a few ago, I make a new website with domain example2 where in my new website I already have 10 new post.

How I can add my older post to my new domain ?

I have my older post wordpress with domain, example1 where my domain example1 already deleted and I only can access my phpadmin and cpanel.

and a few ago, I make a new website with domain example2 where in my new website I already have 10 new post.

How I can add my older post to my new domain ?

• posts

Share Improve this question edited Oct 18, 2016 at 7:13 fuxia♦ 107k3939 gold badges255255 silver badges459459 bronze badges asked Oct 18, 2016 at 6:32 jodksojodkso 1111 bronze badge

Add a comment  | 

3 Answers 3

Sorted by: Reset to default 1

If you have your old database and uploads folder, you can install WordPress and give it that database.

Then, you can use the wordpress importer/exporter to export the posts, then upload it to your new site using the same plugin.

If your old site is much larger, it may even be easier to take an export of your new site, then upload the old sites database and import the new posts into the old site.

This should handle the post content and all the tags

Easiest way of doing this would be copy contents of your older post from phpmyadmin and paste it in new domain and publish again. For that follow this procedure:

1. Go to phpmyadmin and select your database (whose post you wants to copy).
2. Click on wp_posts table to open it.

3. Now click on SQL tab (available above the table) and type following query and click on Go button (bottom right side).

    SELECT * FROM `wp_posts` WHERE post_type='post'
   

4. Now all posts will be shown to you in tabular form (in tables).

5. Final step, All of post contents are use to store in field names as post_content and post title is use to store in field post_title.

Just copy post_title field's content to get title of post and copy post_content field's content to get description detail of posts.

You can copty it either by double click on content of field or by clicking on edit option (available on each row) and on edit page copy those fields and paste in your new domain (dashbord -> Posts -> Add New).

Note: You just need to copy only two fields (mentioned above) from wp_posts table.

Please for next time, try to save all your articles using Notepad or Microsoft word format. That is what I normally do in every of my articles that I write in other not to be stranded if I loss any of my sites with articles to publish.

Thank you.

Sammy Jnr