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 | 회귀분석 종류 | WHRIA | 2020.04.14 | 44 |
183 | 의료영상분석장치 분류 코드 | WHRIA | 2020.04.22 | 52 |
182 | zerohq encryption [5] | WHRIA | 2020.04.23 | 58 |
181 | image encryption [1] | WHRIA | 2020.04.24 | 79 |
180 | php 세션 로그인 | WHRIA | 2020.04.24 | 72 |
179 | mysql 암호화 [2] | WHRIA | 2020.04.24 | 54 |
178 | mysql python reconnect [2] | WHRIA | 2020.04.24 | 196 |
177 | kfda [5] | WHRIA | 2020.04.29 | 93 |
176 | exif javascript orientation | WHRIA | 2020.04.30 | 52 |
175 | conflict of interest | WHRIA | 2020.05.03 | 48 |
174 | annotation service | WHRIA | 2020.05.03 | 52 |
173 | acquihire [1] | WHRIA | 2020.05.05 | 54 |
172 | 개명 | WHRIA | 2020.05.05 | 78 |
171 | startup | WHRIA | 2020.05.08 | 72 |
170 | software validation [1] | WHRIA | 2020.05.10 | 54 |