Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-05-01 00:49:43
- _n
- Member
- Registered: 2005-07-13
- Posts: 44
Can you dump articles from only one secion of txp database?
Hi,
I was wondering about how to do something. I am setting up a new site, that has all new article content…except for the blog section. I was wondering if there is a way to use PHP MyAdmin to dump only the articles from the textapttern section named blog, so that i can then upload it to the new database and hence the new blog.
Suggestions or resource links?
thank you!
_n
Offline
Re: Can you dump articles from only one secion of txp database?
I’m not sure if phpMyAdmin can do it, but if you SSH access you can do:
mysqldump -u<db_user> -p <db_name> textpattern "--where=Section='<section>'"Offline
#3 2009-05-01 02:06:11
- _n
- Member
- Registered: 2005-07-13
- Posts: 44
Re: Can you dump articles from only one secion of txp database?
thanks. i found a way to dump it by phpMyAdmin but now its doing la-choke-a-roke-a-dance (this is a very technical term…i swear ;) ) when trying to upload it. Which is weird because its only a 300kb file.
…aha! zipping it works.
heh. sorry for the posts.
Last edited by _n (2009-05-01 02:16:17)
Offline