How to migrate the database from Etherpad to Etherpad Lite

How to migrate the database from Etherpad to Etherpad Lite

Etherpad Lite provides a script to convert the Etherpad MySQL database into a Etherpad Lite MySQL database.

1. Go into your Etherpad Lite bin folder
2. Copy the convertSettings Template cp convertSettings.json.template convertSettings.json
3. Set the parameters of your Etherpad Lite database in convertSettings.json
4. start the convertScript with node convert.js convertSettings.json output.sql. This script will read all data from your database and outputs a SQL file for creating a Etherpad Lite database. This may take a while
5. Prepare MySQL like described here
6. Pipe the SQL into mysql mysql -u $YOUREPLITEUSER -p$YOUREPLITEPWD -h $YOURMYSQLHOST $YOUREPLITEDATABASE < output.sql