[LRUG] Migrating SQLlite to MySQL

[Alexander Bienz]

Oh Glenn, I found an article about this, thanks for posting a github link :)

On Mon, Nov 16, 2009 at 12:52 PM, Glenn @ Ruby Pond Ltd
<glenn at rubypond.com>wrote:

> > I would now like to use a MySQL database, as is typical for most Rails
> > webapps, but I want the changeover to be seamless, I don't want to lose
> any
> > data or connections.
> > Can anyone point me in the direction of the best practice for this kind
> of
> > migration?
>
> I wont claim this is best practice, but whenever a production
> environment db doesn't match what I use locally for dev (postgres)
> I've got a cap/rake task that pulls down the data and loads it using
> yaml_db:
>
> http://github.com/adamwiggins/yaml_db
>
> Not great if you've got loads of data on production, but handy when
> trying to debug problems. May suit your needs too.
>
> Glenn
> --
> Ruby Pond Ltd
> 7 Clarence Pde, Cheltenham, GL5 03NY
> United Kingdom
>
> T: 0207 183 2224
> F: 0207 183 2223
> W: http://rubypond.com/
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20091116/871c225b/attachment-0003.html>