On Wed, 11 Dec 2013, mikael.schm...@ixx.se wrote:

> Is it possible to migrate from postgresql to mysql  and be able to
> preserve all information? I haven't been able to find any
> documentation/howto's on this. We need to run mysql in order to get
> the reporting module to work

    I've not been able to find anything non-commercial to migrate
data from one to the other, either, and I have a desire to take
things the other way.

    Ultimately, what you'll probably need to do is write a routine
(e.g. in Perl) that extracts stuff from the PostgreSQL database row
by row, table by table, and which writes the same rows into the
MySQL database using the MySQL schema.  Depending on the column-
types there may be some soft massaging of formats to get from one
to the other, but those are likely minor and will probably be in
the time/date-based realm.  It's a pain, but once you have the routine
coded it'll be useful for other things -- especially if the main
database engine is to remain PostgreSQL and you just want to extract
the data into MySQL for the reporting aspect.

+------------------------------------------------+---------------------+
| Carl Richard Friend (UNIX Sysadmin)            | West Boylston       |
| Minicomputer Collector / Enthusiast            | Massachusetts, USA  |
| mailto:crfri...@rcn.com                        +---------------------+
| http://users.rcn.com/crfriend/museum           | ICBM: 42:22N 71:47W |
+------------------------------------------------+---------------------+

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

Reply via email to