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 ?
Share Improve this question edited Oct 18, 2016 at 7:13 fuxia♦ 107k39 gold badges255 silver badges459 bronze badges asked Oct 18, 2016 at 6:32 jodksojodkso 111 bronze badge3 Answers
Reset to default 1If 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:
- Go to
phpmyadmin
and select your database (whose post you wants to copy). - Click on
wp_posts
table to open it. Now click on
SQL
tab (available above the table) and type following query and click onGo
button (bottom right side).SELECT * FROM `wp_posts` WHERE post_type='post'
Now all posts will be shown to you in tabular form (in tables).
- Final step, All of post contents are use to store in field names as
post_content
and post title is use to store in fieldpost_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