* Gussimulator <[EMAIL PROTECTED]> [2006-11-12 18:00]: > what are the available tools to convert a mysql db onto this > engine ( sqlite3 ) ? thanks - i can take scripts (php, phyton, > perhaps ruby although i dont have it installed now) but any > tool for windows would suffice too!
SQL databases have a decently (though not perfectly) standardised exchange format: SQL. Just dump the MySQL database via mysqldump then feed the result to the sqlite shell. You’ll want to peruse the mysqldump docs to turn off as much MySQL-specific SQL syntax used in the dump as possible. Then hopefully you’ll only have to edit the CREATE TABLE statements but will otherwise be able to feed it to SQLite verbatim. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------