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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1804 | Croatian - hrvatski | WHRIA | 2024.05.24 | 0 |
1803 | Czech - čeština | WHRIA | 2024.05.24 | 0 |
1802 | Danish - dansk | WHRIA | 2024.05.24 | 0 |
1801 | Danish - dansk | WHRIA | 2024.05.24 | 0 |
1800 | Esperanto - esperanto | WHRIA | 2024.05.24 | 0 |
1799 | Estonian - eesti | WHRIA | 2024.05.24 | 0 |
1798 | Filipino - Filipino | WHRIA | 2024.05.24 | 0 |
1797 | Finnish - suomi | WHRIA | 2024.05.24 | 0 |
1796 | French - français | WHRIA | 2024.05.24 | 0 |
1795 | Galician - galego | WHRIA | 2024.05.24 | 0 |
1794 | Georgian - ქართული | WHRIA | 2024.05.24 | 0 |
1793 | German - Deutsch | WHRIA | 2024.05.24 | 0 |
1792 | Greek - Ελληνικά | WHRIA | 2024.05.24 | 0 |
1791 | Gujarati - ગુજરાતી | WHRIA | 2024.05.24 | 0 |
1790 | Haitian Creole - Haitian | WHRIA | 2024.05.24 | 0 |