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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1611 | 넌센스 퀴즈 | WHRIA | 2016.09.04 | 75 |
1610 | mcnemar | WHRIA | 2019.11.20 | 76 |
1609 | 힘든 하루하루 | WHRIA | 2016.09.30 | 77 |
1608 | 배당세금 | WHRIA | 2015.10.14 | 78 |
1607 | 2016 ilsvrc | WHRIA | 2019.08.31 | 78 |
1606 | tab 구조 html | WHRIA | 2020.06.28 | 79 |
1605 | 인정이자 | WHRIA | 2016.01.23 | 80 |
1604 | add extra raid disk | WHRIA | 2020.01.05 | 80 |
1603 | 도움 | WHRIA | 2016.01.21 | 81 |
1602 | 가끔은 시간을 돌렸으면... | WHRIA | 2016.06.09 | 81 |
1601 | . | WHRIA | 2016.10.01 | 81 |
1600 | kfda [5] | WHRIA | 2020.04.29 | 81 |
1599 | consort , stard | WHRIA | 2020.07.30 | 81 |
1598 | 결극 senet 이 문제 | WHRIA | 2019.07.13 | 82 |
1597 | pytorch mini batch size | WHRIA | 2019.12.19 | 82 |