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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1609 | lvm 확장 [1] | WHRIA | 2019.12.25 | 54 |
1608 | pytorch object detect / retinanet | WHRIA | 2019.12.22 | 226 |
1607 | kaggle leakage | WHRIA | 2019.12.19 | 46 |
1606 | pytorch - caffe | WHRIA | 2019.12.19 | 80 |
1605 | pytorch mini batch size | WHRIA | 2019.12.19 | 94 |
1604 | windows softraid monitor | WHRIA | 2019.12.19 | 85 |
1603 | raid monitor | WHRIA | 2019.12.15 | 66 |
1602 | SAS controller SAS 9212-4i | WHRIA | 2019.12.08 | 156 |
1601 | Basic tutorial to develop driver on windows | WHRIA | 2019.12.07 | 448 |
1600 | Keratinocytic Skin Cancer Detection on the Face Using Region-Based Convolutional Neural Network | WHRIA | 2019.12.07 | 365 |
1599 | linux raid | WHRIA | 2019.11.30 | 66 |
1598 | Micro- and macro-averages | WHRIA | 2019.11.28 | 153 |
1597 | mcnemar | WHRIA | 2019.11.20 | 102 |
1596 | python pdf writer | WHRIA | 2019.11.04 | 349 |
1595 | distributed training [2] | WHRIA | 2019.10.30 | 113 |