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

Note: If you get a message "Error: Cannot find module 'mysql'". npm install mysql You may need to do this for a number of different packages, including ueberDB and async.