Migration from SQLite to MySQL: Difference between revisions

From Littledamien Wiki
Jump to navigation Jump to search
(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...")
(No difference)

Revision as of 17:36, 15 April 2013

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"