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 [old/source/original] 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