This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Wordpress importer for PieCrust using the SQL database directly

Project Description

This plugin for PieCrust lets you import a Wordpress website directly from its SQL database, unlike the Wordpress importer that ships with PieCrust and can only import from an XML archive.

Most of the time, your SQL database will only accept connections from localhost, in which case you’ll have to make an SSH tunnel between your machine and your server’s machine:

ssh username@myserver.com -L 3307:localhost:3306 -N

Here, username is a user that has SSH access to the machine running the SQL server – not the SQL user.

This command creates a “tunnel” between port 3307 on your local machine and port 3306 on your SQL server’s machine.

Then, you can run the importer by going through the tunnel:

chef import wordpress-sql mysql+pymysql://user:password@localhost:3307/dbname

Here, user and password are the credentials to the user with access to the SQL databse. dbname is the name of the SQL database. You may also want to pass --prefix to specify what table name prefix your Wordpress website is using.

Release History

Release History

This version
History Node

0.1.0

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting