sqlite to mysql
2016.10.18 10: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 | 722 |
1518 | windows faster rcnn | WHRIA | 2017.02.10 | 4718 |
1517 | inception | WHRIA | 2017.01.23 | 7254 |
1516 | fast rcnn | WHRIA | 2017.01.08 | 146 |
1515 | fast rcnn cudnn 5.0 | WHRIA | 2017.01.08 | 180 |
1514 | jquery java | WHRIA | 2016.12.13 | 1850 |
1513 | % 빼고 center crop | WHRIA | 2016.10.22 | 361 |
1512 | 이미지를 정사각형으로 만드는 batch | WHRIA | 2016.10.22 | 1222 |
1511 | 이미지 size 줄이는 batch | WHRIA | 2016.10.19 | 169 |
1510 | caffe | WHRIA | 2016.10.19 | 145 |
» | sqlite to mysql | WHRIA | 2016.10.18 | 182 |
1508 | KMA 연수교육 주소 | WHRIA | 2016.10.05 | 184 |
1507 | . | WHRIA | 2016.10.01 | 120 |
1506 | 만기까지 끌어 올림. | WHRIA | 2016.09.30 | 116 |
1505 | youtube | WHRIA | 2016.09.30 | 81 |