... | ... | @@ -3,7 +3,7 @@ Shutdown Lstu to avoid URL creation while migrating. |
|
|
Install some dependencies:
|
|
|
```
|
|
|
apt-get install sqlite3 libsqlite3-mod-impexp
|
|
|
sqlite3 /var/www/lutim/lutim.db
|
|
|
sqlite3 /var/www/lstu/lstu.db
|
|
|
```
|
|
|
|
|
|
In SQLite prompt, do this to export data:
|
... | ... | @@ -15,7 +15,7 @@ SELECT export_sql('/tmp/lstu.sql','1'); |
|
|
|
|
|
Modify the export file (the export format is close to PostgreSQL's SQL but not quite):
|
|
|
```
|
|
|
sed -e "s@^INSERT OR REPLACE @INSERT @" -i /tmp/lstu.sql
|
|
|
sed -e "s@^INSERT OR REPLACE @INSERT @" -e 's@INSERT INTO "mojo_migrations".*@@' -i /tmp/lstu.sql
|
|
|
```
|
|
|
|
|
|
Create PostgreSQL database:
|
... | ... | |