Migration from SQLite to MySQL

From Littledamien Wiki
Revision as of 17:36, 15 April 2013 by Video8 (talk | contribs) (Created page with "== Overview == Steps for exporting SQLite data and objects and importing them into a MySQL database. == Exporting from SQLite == <syntaxhighlight lang="dos"> > sqlite3 mySq...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

Steps for exporting SQLite data and objects and importing them into a MySQL database.

Exporting from SQLite

> sqlite3 mySqliteDatabase.db .dump >> myDumpFile.sql

Importing into MySQL

  • Edit the dump file to make the SQL compatible with MySQL.
    • Replace double-quotes with back-ticks
    • Remove BEGIN TRANSACTION, COMMIT and lines related to sqlite_sequence
    • Replace autoincrement with auto_increment
  • Import the SQL using phpMyAdmin
Retrieved from "https://wiki.dbarchowsky.com/index.php?title=Migration_from_SQLite_to_MySQL&oldid=476"