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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1744 | Shona - chiShona | WHRIA | 2024.05.24 | 0 |
1743 | Sindhi - سنڌي | WHRIA | 2024.05.24 | 0 |
1742 | Sinhala - සිංහල | WHRIA | 2024.05.24 | 0 |
1741 | Slovak - slovenčina | WHRIA | 2024.05.24 | 0 |
1740 | Slovenian - slovenščina | WHRIA | 2024.05.24 | 0 |
1739 | Somali - Soomaali | WHRIA | 2024.05.24 | 0 |
1738 | Southern Sotho - Southern Sotho | WHRIA | 2024.05.24 | 0 |
1737 | Spanish - español | WHRIA | 2024.05.24 | 0 |
1736 | Sundanese - Basa Sunda | WHRIA | 2024.05.24 | 0 |
1735 | Swahili - Kiswahili | WHRIA | 2024.05.24 | 0 |
1734 | Swedish - svenska | WHRIA | 2024.05.24 | 0 |
1733 | Tajik - тоҷикӣ | WHRIA | 2024.05.24 | 0 |
1732 | Tamil - தமிழ் | WHRIA | 2024.05.24 | 0 |
1731 | Telugu - తెలుగు | WHRIA | 2024.05.24 | 0 |
1730 | Thai - ไทย | WHRIA | 2024.05.24 | 0 |