On 4 Oct 2011, at 10:01pm, Alberto Larotonda wrote: > Hello. It was recommended to me that I ask for assistance on this mailing > list. > > I have a very large (600 mb) SQLite database file > I'm trying to convert it to MySql (.sql) file format on a windows platform. > Does anyone know of a free conversion utility?
Use any MySQL utility to dump the database as SQL commands into a text file. On a Mac I use 'Sequel Pro' but I don't know what platform you're using. Use a text editor to remove any LOCK and UNLOCK commands from the text file and make any other changes you want. Put a BEGIN before all the INSERT commands and a COMMIT after all the INSERT commands. Use the sqlite3 shell tool to '.read' the text file making your SQLite database. http://www.sqlite.org/download.html http://www.sqlite.org/sqlite.html I recommend a file extension of '.sqlite' for your SQLite database file if you haven't already picked one. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
