[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Export WP blog and Import to new WP blog

We are updating a website for a client.  They currently have 3 separate Wordpress blogs.  We are creating one blog site for them and segmenting each of the 3 blogs by category in the new site.

is it possible to export the blog content tables and import them to the new site?
0
axessJosh
Asked:
axessJosh
1 Solution
 
Jason C. LevineNo oneCommented:
It's possible, but it's tricky.

In the admin dashboard, until Tools there is a way to export your content and then re-import it into another instance of WordPress.  But if you are linking to any media files, you'll need to make sure that you grab those via FTP and transfer them manually.
0
 
coredatarecoveryCommented:
Once you do the below, you can go to the posts table and change the category on all the data to the correct one and export it, flush the table, repeat and then when you are finished you can import all 3 files and you will be done.


Wordpress how to transfer a site to a new domain name:

First backup your database file using control panel.

Extract the files locally and then open the .sql file from the backup.

replace your user@www.xxx.com with user@www.yyy.com

replace your www.xxx.com with www.yyy.com

save it as xfer.sql

Create the new site name
go to control panel, run mysql databases, create database sitename_ add wrdp1 database
add the user, create a nice password and save it for using later
add the user to the database with full privledges
import xfer.sql using myphpadmin - import

copy all the files (wordpress files) to a directory from the old site.
copy all the files to the new site

edit the wp-config.php and modify the database information to match
the database name and user information.

edit the .htaccess file, or erase it and let wordpress create it.



0
 
gwkgCommented:
A CSV importer plugin is another option

http://wordpress.org/extend/plugins/easy-csv-importer-2/

Export your posts to csv, add the new categories and Import.
0
 
axessJoshAuthor Commented:
If i use the WP import/export feature.  

I want the imported posts to only show for a certain category in my new blog.  Can i set that up?
0
 
coredatarecoveryCommented:
You can do some edits to the.sql export.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now