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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
184 | 이사 감사 3년 변경등기 | WHRIA | 2015.12.02 | 76 |
183 | 참고 또 참고 | WHRIA | 2020.01.03 | 76 |
182 | 식약청 메뉴 | WHRIA | 2020.05.14 | 76 |
181 |
pstools
![]() | WHRIA | 2016.07.31 | 74 |
180 | retinanet nvidia [3] | WHRIA | 2020.01.12 | 74 |
179 | rsynccp | WHRIA | 2023.02.20 | 74 |
178 |
증시의 허풍 예언들
![]() | WHRIA | 2015.11.20 | 73 |
177 | php 세션 로그인 | WHRIA | 2020.04.24 | 72 |
176 | startup | WHRIA | 2020.05.08 | 72 |
175 | chat GPT | WHRIA | 2023.02.16 | 72 |
174 | MDR - PL | WHRIA | 2023.05.11 | 72 |
173 | CIDR 표기법 [1] | WHRIA | 2020.03.12 | 70 |
172 | center % crop | WHRIA | 2018.12.27 | 69 |
171 | 정량화 논문들 | WHRIA | 2023.02.16 | 69 |
170 |
psexec
![]() | WHRIA | 2016.07.28 | 68 |