Importing directly into the database?

jcostantino · Post by **jcostantino** » Wed Jul 20, 2005 5:28 pm

I have approx. 450 posts to import from LiveJournal and the RSS import only goes back one month. Is there any way to inject my LJ posts directly into the mysql database or import the XML file?

It's not a big deal if I can't but it sure would be nice to have everything (two and a half years) moved over.

kidgoo · Post by **kidgoo** » Wed Jul 20, 2005 6:00 pm

IIRC, there's not a way to export all entries through livejournal...
You can import XML files through s9y, but it won't help if you can only grab one month at a time...

You could write a script to parse the livejournal pages, strip out the non-entry content, and then stuff it into the database....it might not be too terribly difficult. I've never used livejournal to know...

Brett

jcostantino · Post by **jcostantino** » Wed Jul 20, 2005 8:39 pm

I actually found a program (ljbackup) that downloads everything into one file and then can output CSV or XML.

When it outputs XML, how do I import it into s9y? I tried using the MovableType import but that didn't work - not that I was expecting it to, though.

Post by **garvinhicking** » Wed Jul 20, 2005 8:59 pm

You'd need to convert the XML into RSS format. I bet if there's a ljbackup tool there must be a ljbackup->RSS transforming tool available, too...

Regards,
Garvin

jcostantino · Post by **jcostantino** » Wed Jul 20, 2005 9:18 pm

I didn't even think to convert the xml to rss! I'll have to give that a shot, thanks!