[typo] MySQL to SQLite: any pointers?

Tobias Luetke tobias.luetke at gmail.com
Thu Jun 2 13:55:03 EDT 2005


Hey henning,

One thing to try is something like this after creating the sqlite
schema at db/database.db

mysqldump --lock-tables=FALSE --complete-insert=TRUE  -t -u root typo
| sqlite db/database.db

On 6/2/05, Henning Bertram <henning at bertramonline.com> wrote:
> I have bebe running Typo for a while on my TextDrive account. It is a
> great app, but recently the TextDrive servers have had a number of MySQL
> problems. So, I thought: why now use SQLite instead? It is not as if I
> have so much traffic that performance will be an issue (if it is at all,
> under any circumstances...)
> 
> However, I would like to convert my existing db over (holding some 700
> articles). After all: I spent a lot of time moving all the data from TxP...
> 
> Since a SQLite db is cross-platform, I tried doing various conversions
> on my local Windoze machine, using some of the different freely
> available SQLite tools. The closest I got was moving the db from MySQL
> to Access (!!!), and then from Access to SQLite. Worked, sort of: the
> contents of the DATETIME fields did not make it, so no good, in the end.
> 
> However, looking at the converters that come with Typo (and that worked
> great, btw), I have a feeling that something along those lines might be
> the way to go.
> 
> My question is: has anybody done this? That is: moved an existing Typo
> db from MySQL to SQLite, using a ruby script? Loooking at the
> converters, it seems as if it would be trivial. On the other hand: I am
> not (yet?) really an ace Rubyist, so if such a script is already out
> there...
> 
> /Henning
> _______________________________________________
> Typo-list mailing list
> Typo-list at rubyforge.org
> http://rubyforge.org/mailman/listinfo/typo-list
> 


-- 
Tobi
http://www.snowdevil.ca - Snowboards that don't suck
http://typo.leetsoft.com - Open source weblog engine
http://blog.leetsoft.com - Technical weblog



More information about the Typo-list mailing list