Migration from SQLite to MySQL: Difference between revisions

Latest revision as of 13:44, 5 March 2024

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

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

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

Revision as of 17:36, 15 April 2013 (edit) 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...")		Latest revision as of 13:44, 5 March 2024 (edit) (undo) Video8 (talk \| contribs) No edit summary Tag: wikieditor
Line 17:		Line 17:
	* Import the SQL using '''phpMyAdmin'''		* Import the SQL using '''phpMyAdmin'''

	[[Category:SQLite]] [[Category:MySQL]] [[Category:Django]] [[Category:Web Development]]		[[Category:SQLite]] [[Category:MySQL]][[Category:MariaDB]][[Category:Django]] [[Category:Web Development]]