On 7/26/07, Luke Melia <[EMAIL PROTECTED]> wrote: > Craig Maloney wrote: > >> Is there any easy way to export the Tracks data from MySQL to SQLite? > > > > And vice versa, too... (SQLite to mySQL) > > There's not currently an automated way to do this. Import/Export is on > the feature list, but not implemented yet. > > I bet you could probably script dumping the data out of MySQL as SQL > statements and running those against sqlite, possibly tweaking them a > bit in between if necessary. There might even be examples or tools > available to do this. > > Let us know what you figure out! > > Cheers, > Luke
It's been a while, but the process is as simple as: mysql ... open <database> dump <output_file> exit to create a file full of SQL commands to recreate your database (including data). I don't know SQLite, but from mysql the restore is something like: mysql source <output_file> exit I'm sure the above is not exactly correct, but it should give you somethings to try. Greg -- Greg Freemyer The Norcross Group Forensics for the 21st Century _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
