Re: [sqlite] Conversion of SQLite Database to MySql format

2011-10-05 Thread Donald Griggs
Hello, Alberto, Simon's initial reply was full of helpful facts, but I'm thinking he might have misread and you are asking about conversion in the opposite direction: I.e., from an sqlite database into a MySQL database (or perhaps just into MySQL-compatible text statements to perform an impor

Re: [sqlite] Conversion of SQLite Database to MySql format

2011-10-05 Thread Simon Slavin
On 5 Oct 2011, at 2:03pm, Swithun Crowe wrote: > Hard though it is to believe, the OP wants to go in the other direction. Hah ! I completely missed that. Thanks for pointing it out, sorry to the OP. Oh well, same tools, opposite directions. Use '.dump' instead of '.read' in the SQLite shell

Re: [sqlite] Conversion of SQLite Database to MySql format

2011-10-05 Thread Swithun Crowe
Hello SS> > I have a very large (600 mb) SQLite database file SS> > I'm trying to convert it to MySql (.sql) file format on a windows platform. SS> > Does anyone know of a free conversion utility? SS> Use any MySQL utility to dump the database as SQL commands into a text SS> file. On a Mac I u

Re: [sqlite] Conversion of SQLite Database to MySql format

2011-10-05 Thread Simon Slavin
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 fre

[sqlite] Conversion of SQLite Database to MySql format

2011-10-05 Thread Alberto Larotonda
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? Thanks in advance. Alberto