sqlite to mysql
2016.10.18 09:41
HowTo: Migrate a database dump from SQLite to MySQL
Grab the (sqlite) sql dump an fire up your editor:
sqlite3 db/development.sqlite .dump .quit > dump.sql
You have to make these replacements:
- replace all double-quotes (") with grave accents (´) (in vim just type :%s/"/´/)
- replace "autoincrement" with "auto_increment"
- remove "BEGIN TRANSACTION;" from the beginnig of the dump
- remove "COMMIT;" from the end of the dump
- remove all lines containing "sqlite_sequence"
Now you can simply import your new MySQL dump.
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1819 | 이건 비밀글이얍 | J | 2004.04.23 | 2 |
1818 | Odia - ଓଡ଼ିଆ | WHRIA | 2024.05.24 | 2 |
1817 | 아저씨에게 [1] | ^&^ | 2004.04.25 | 3 |
1816 | Russian - русский | WHRIA | 2024.05.24 | 3 |
1815 | Malay - bahasa Malaysia | WHRIA | 2024.05.24 | 4 |
1814 | Maltese - Malti | WHRIA | 2024.05.24 | 4 |
1813 | Norwegian - norsk | WHRIA | 2024.05.24 | 4 |
1812 | 아저씨~ [1] | ^&^ | 2004.05.15 | 5 |
1811 | Galician - galego | WHRIA | 2024.05.24 | 5 |
1810 | Gujarati - ગુજરાતી | WHRIA | 2024.05.24 | 5 |
1809 | Macedonian - македонски | WHRIA | 2024.05.24 | 5 |
1808 | Hungarian - magyar | WHRIA | 2024.05.24 | 6 |
1807 | Latvian - latviešu | WHRIA | 2024.05.24 | 6 |
1806 | Māori - te reo Māori | WHRIA | 2024.05.24 | 6 |
1805 | Nepali - नेपाली | WHRIA | 2024.05.24 | 6 |