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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1774 | Hausa - Hausa | WHRIA | 2024.05.24 | 8 |
1773 | Kazakh - қазақ тілі | WHRIA | 2024.05.24 | 8 |
1772 | Malagasy - Malagasy | WHRIA | 2024.05.24 | 8 |
1771 | Nyanja - Nyanja | WHRIA | 2024.05.24 | 8 |
1770 | Punjabi - ਪੰਜਾਬੀ | WHRIA | 2024.05.24 | 8 |
1769 | Xhosa - isiXhosa | WHRIA | 2024.05.24 | 8 |
1768 | Azerbaijani - azərbaycan | WHRIA | 2024.05.24 | 9 |
1767 | Croatian - hrvatski | WHRIA | 2024.05.24 | 9 |
1766 | Georgian - ქართული | WHRIA | 2024.05.24 | 9 |
1765 | Korean - 한국어 | WHRIA | 2024.05.24 | 9 |
1764 | Latin - Lingua latina | WHRIA | 2024.05.24 | 9 |
1763 | Luxembourgish - Lëtzebuergesch | WHRIA | 2024.05.24 | 9 |
1762 | Sindhi - سنڌي | WHRIA | 2024.05.24 | 9 |
1761 | Tajik - тоҷикӣ | WHRIA | 2024.05.24 | 9 |
1760 | Albanian - shqip | WHRIA | 2024.05.24 | 10 |