[Catalyst] SQLite -> MySQL

[Aaron Peterson]

On 11/14/05, Will Smith <willbelair at yahoo.com> wrote:
> hi,
> could i move myapp Catalyst from SQLite to MySQL ? WHat do I need to do? Can
> I copy the whole app over (of course there is one database in MySQL exactly
> the same) and just change the config ?
>
>  ________________________________
>  Yahoo! FareChase - Search multiple travel sites in one click.
>
>
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst

It is conceivable that you could simply change the connection string
in your base model class to point to your mysql database instead of
the sqlite database.  If other modifications were necessary I would
think they would be minor unless you have very customized model
classes using features specific to sqlite.  You will need to be sure
you have DBD::mysql and perhaps a few other mysql related perl modules
installed.  Catalyst should tell you which ones are missing when you
start the test server.

Aaron