jm3

i just wrote a script to generate the SQL for bulk loading all the entries and category data, and set up the post-category associations in post2cat. it was easier for me than the import-mt script, (which failed for me on even the simple test case from mt’s documentation of their import format.) dunno.

If the post_password is optional, why is it a NOT NULL field?

mysql> insert into blog_posts values( … );
ERROR 1048: Column ‘post_password’ cannot be null

I’m kind of impatient to get started; is there any reason why i shouldn’t just bulk load the entries directly into the database?

Ah, I should have noted that: I’m running WordPress 1.2.2 a€?Mingusa€?, downloaded January 1, 6:55 AM. (the readme.html says Version 1.2 but I assume that’s out of date).

That’s the format i tried but wordpress isn’t importing posts in that format, at least, not for me. I used the super-simple example from the MTImport documentation page, you can see the test file here: https://jm3.net/blog/wp-admin/test-data.txt . (i changed the author name to me; that’s it.)

But when I point import-mt.php to the test file and import it, import-mt *says* it imported the posts but they don’t show up in the admin console or on https://jm3.net/blog/

Am I missing a step where i have to approve the posts or something?