I have about 30,000 very short posts to make in Wordpress. I built them using a SQLlite database and python script, and was uploading them via the wordpress_xmlrpc library in python. But my site goes down after 100-200 posts, because the server thinks this is a DoS attack.
My server is a linux box to which I have SSH access. I'm looking for a way to easily upload the posts into Wordpress more directly, say by interacting directly with its database, or using a local process that happens directly on the server. Can anyone offer any ideas?
Found another way, in case anyone else stumbles on this. Dump all the posts to a csv file and use a "csv to post" widget. I'm using Ultimate CSV Importer Free. Very simple.
Uploading 30,000 posts into Wordpress without causing an XML-RPC crash