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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1519 | JAMA | WHRIA | 2017.02.11 | 668 |
1518 | windows faster rcnn | WHRIA | 2017.02.10 | 4702 |
1517 | inception | WHRIA | 2017.01.23 | 7201 |
1516 | fast rcnn | WHRIA | 2017.01.08 | 133 |
1515 | fast rcnn cudnn 5.0 | WHRIA | 2017.01.08 | 157 |
1514 | jquery java | WHRIA | 2016.12.13 | 1792 |
1513 | % 빼고 center crop | WHRIA | 2016.10.22 | 329 |
1512 | 이미지를 정사각형으로 만드는 batch | WHRIA | 2016.10.22 | 1200 |
1511 | 이미지 size 줄이는 batch | WHRIA | 2016.10.19 | 111 |
1510 | caffe | WHRIA | 2016.10.19 | 124 |
» | sqlite to mysql | WHRIA | 2016.10.18 | 106 |
1508 | KMA 연수교육 주소 | WHRIA | 2016.10.05 | 123 |
1507 | . | WHRIA | 2016.10.01 | 102 |
1506 | 만기까지 끌어 올림. | WHRIA | 2016.09.30 | 86 |
1505 | youtube | WHRIA | 2016.09.30 | 61 |