Migrate MySQL... or not...

[ted leslie]

both are easy to export and import data, 
i used to use mysql a tonne
but changed to postgres 5-6 years ago, due to its store procedure language support.
I hate SP, but others on my team needed it.
(fortunetly c# support at the SP level is coming soon, so then i will be very happy).
but mysql is supposed to have decent sp language choice now (i heard).

i have heard one person say the mysql might have an edge on clustering,
and postgres maybe an edge still in language support,
but all in all, i generally think they are very close.
i went from mysql to postgres with almost no learning curve.

googling on eithers export/import ability should give you tonnes of results,
the only issue i have ever had is when you migrate data across versions of either,
especially with respect to SP stuff.

in postgres (and mysql should have same), you can do a text based with full insert
dump, that can then be imported back in, which is good for migration across versions,
or even DB's. 
there is a product called enterprise DB that you can trial, and depending on what features
you like, can even keep for free. I has a data migration process , i can't remember if
it migrates from mysql, it does from oracle. enterpriseDB, is just postgres, with some added
extras and commercial support and indemnity if you need it, it also has some clustering ability,etc.



-tl

On Wed, 19 Aug 2009 12:32:38 -0400
tug <tug.williams-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org> wrote:

> I have a server running at home (actually mandriva 2008 or maybe 2007 :S 
> ), I've migrated tasks away from it to another machine (Gentoo), which 
> was originally my play box, but is now destined to become my server, and 
> I'll install something sensible on my old server and play on that one.
> 
> The only function of the old server is now to provide the MySQL database 
> backend for a phpbb installation that's running on my Gentoo box - I use 
> the bb for single user personal work log / knowledge base. It also has 
> some other data from old projects that I still want to keep, but don't 
> have time to use at the moment.
> 
> I have been intending on migrate the database to the gentoo box, but had 
> some problems copying the DB over - I assumed it would be trivial, but 
> it wasn't... not investigated what the problem is yet (data but no 
> permissions I think), but...
> 
> At TLUG meetings I've heard negative comments about MySQL, and that 
> Postgres is a better option. If I've got to go through hoops (aka read 
> manuals and look at log files) to get the database migrated, should I 
> also consider switching databases?
> 
> I don't need to keep the db server up during migration.
> 
> Tug
> 
> 
> --
> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> 


-- 
ted leslie <tleslie-RBVUpeUoHUc at public.gmane.org>
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists