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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1686 | ubuntu cuda nvidia-smi | WHRIA | 2020.08.29 | 850 |
1685 | concat network [3] | WHRIA | 2020.08.27 | 147 |
1684 | GPT2 [1] | WHRIA | 2020.08.03 | 250 |
1683 | scopus [1] | WHRIA | 2020.08.02 | 344 |
1682 | melafind | WHRIA | 2020.08.01 | 771 |
1681 | nvidia dali [1] | WHRIA | 2020.08.01 | 265 |
1680 | pytorch optimize | WHRIA | 2020.08.01 | 126 |
1679 | startup , 미국 | WHRIA | 2020.07.30 | 134 |
1678 | consort , stard | WHRIA | 2020.07.30 | 81 |
1677 | model split [1] | WHRIA | 2020.07.30 | 142 |
1676 | FTC [1] | WHRIA | 2020.07.28 | 238 |
1675 | 암호화 | WHRIA | 2020.07.26 | 1000 |
1674 | raid 6 | WHRIA | 2020.07.23 | 43 |
1673 | asyncio | WHRIA | 2020.07.23 | 286 |
1672 | amp distributed pytorch [1] | WHRIA | 2020.07.14 | 51 |