Textpattern CMS

#1 2006-12-24 12:06:17

apsk121

Member

From: Punjab, India

Registered: 2004-09-02

Posts: 36

Website

Move only a particular section to a new installation

I wanted to move a particular section of my current txp install, let’s say it’s called photoblog. How do I move the entries of that section to a new install?

#2 2006-12-24 17:45:16

hcgtv

Plugin Author

From: Key Largo, Florida

Registered: 2005-11-29

Posts: 2,722

Website

Re: Move only a particular section to a new installation

Hi,

What I’ve done in the past is to export the database with phpMyAdmin. Then I FTP a local copy of the site’s files, this brings along images and everything.

Then I tweak the /textpattern/config.php on this local copy and I FTP up the local copy up to the new site. I create the new database with phpMyAdmin on the web server and import the database I exported above. I sign on to the new site and adjust the admin preferences and test the site.

Then it’s just a case of removing whatever articles you don’t want on this new site and making this new section the default so it appears on the front page.

---

We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make

#3 2006-12-24 19:51:39

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: Move only a particular section to a new installation

You could always drop into phpMyAdmin after following all of Hcgtvs steps then

1. show the Textpattern table
2. sort it by section
3. check all articles that belong toyour section
4. then use the export button at the bottom of the list (selecting “replace”)
5. then replace the textpattern install in your new install.

You could write a query to do the select automagically, but that kind exceeds my expertise.

[Edit] Look Ma I made a query

SELECT title FROM textpattern WHERE Section = 'your_section_name' LIMIT 1 , 300;

Last edited by mrdale (2006-12-26 06:43:09)