Help - Search - Members - Calendar
Full Version: script to dump entries from MySQL
Movable Type Community Forum > Additional Resources > Tips and Tricks
gavin
Just in case this is helpful for somebody, I thought I'd post it here.

I wanted to make a lot of edits to my blog but I didn't want to go through the web interface, I just wanted to use BBEdit. I wrote these two scripts, the first takes your entries and writes the body out to a file, the second updates the database with the changes.

http://www.estey.com/scripts/mt2dir.pl.txt
http://www.estey.com/scripts/dir2mt.pl.txt

Just make sure you edit the $USER, $PASS, and $DIR variables at the top of each script.

Let me know if these are helpful...
Gavin.
ibarton
Thanks that will be very useful. I use a Blog to keep a personal diary. When I started using MT I imported a whole bunch of stuff from other sources, which I would like to be able to edit outside of MT.

I assume your code exports the whole database. I'll modify the SQL so it only exports the range of entries I am interested in.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.