forked from ether/etherpad-lite
-
Notifications
You must be signed in to change notification settings - Fork 0
How to migrate the database from Etherpad to Etherpad Lite
johnyma22 edited this page Sep 6, 2011
·
4 revisions
Etherpad Lite provides a script to convert the Etherpad MySQL database into a Etherpad Lite MySQL database.
- Go into your Etherpad Lite bin folder
- Copy the convertSettings Template
cp convertSettings.json.template convertSettings.json - Set the parameters of your Etherpad [old/source/original] database in convertSettings.json
- 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 - Prepare MySQL like described here
- 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