163824 – I need a DB dump of my blogs and associated comments

Bug 163824 - I need a DB dump of my blogs and associated comments

Summary: I need a DB dump of my blogs and associated comments

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	[OLD] Unspecified (show other bugs)
Hardware:	All Linux

Importance:	Normal normal (vote)
Assignee:	Steve Dibb (RETIRED)

URL:	http://planet.gentoo.org/developers/s...
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2007-01-25 21:36 UTC by Seemant Kulleen (RETIRED)
Modified:	2007-04-05 20:15 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Seemant Kulleen (RETIRED) gentoo-dev

2007-01-25 21:36:11 UTC

I'd like to move my blog offsite to a custom django-built one.  I would like to relocate all my blog entries and their comments to the new system, so a db dump would be of great help.

Reproducible: Always

Comment 1 Steve Dibb (RETIRED) gentoo-dev

2007-01-25 21:39:00 UTC

I think beu needed one too

Comment 2 Steve Dibb (RETIRED) gentoo-dev

2007-02-01 04:30:08 UTC

get off your lazy butt and fix this bug, punk.

Comment 3 Steve Dibb (RETIRED) gentoo-dev

2007-03-28 13:48:27 UTC

Posts:

SELECT ep.post_ID epid from evo_posts ep INNER JOIN evo_comments ec ON ec.comment_post_ID = ep.post_ID where ep.post_creator_user_ID = 16;

Comments: 

SELECT ep.post_ID epid, ec.* from evo_posts ep INNER JOIN evo_comments ec ON ec.comment_post_ID = ep.post_ID where ep.post_creator_user_ID = 16;

CREATE TABLE test AS SELECT ep.post_ID epid, ec.* from evo_posts ep INNER JOIN evo_comments ec ON ec.comment_post_ID = ep.post_ID where ep.post_creator_user_ID = 16;