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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1639 | image encryption [1] | WHRIA | 2020.04.24 | 79 |
1638 | zerohq encryption [5] | WHRIA | 2020.04.23 | 58 |
1637 | 의료영상분석장치 분류 코드 | WHRIA | 2020.04.22 | 52 |
1636 | 회귀분석 종류 | WHRIA | 2020.04.14 | 44 |
1635 | fcitx | WHRIA | 2020.04.05 | 59 |
1634 | chatbot | WHRIA | 2020.04.03 | 54 |
1633 | kernel load | WHRIA | 2020.04.03 | 46 |
1632 | plum | WHRIA | 2020.04.03 | 64 |
1631 | zmq async client server [1] | WHRIA | 2020.03.12 | 67 |
1630 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 70 |
1629 | multiple NIC ubuntu [6] | WHRIA | 2020.03.10 | 50 |
1628 | calendar javascript dropdown | WHRIA | 2020.03.01 | 39 |
1627 | sql replication 성공 [1] | WHRIA | 2020.02.20 | 49 |
1626 | sql 중복제거 | WHRIA | 2020.02.10 | 48 |
1625 | airplane | WHRIA | 2020.02.10 | 197 |