We've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're moving the Wiki to a new platform of hardware. My question is the Wiki software (MediaWiki) is the only thing still tied to and using MySQL which we want to decommission but we've been using it for years so I'm worried we will lose the data. I've done some Google'ing to find out how can I change the MySQL database dump and successfully export it into my new PostgreSQL database however I don't know how practical or recommended this process is. I found sites like the following: http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL Can you guys tell me if this is something that will work? I don't mean the exact link above but just in general taking a database from MySQL and successfully migrating it for PostgreSQL use? >From what I can see in the MySQL database, there appears to be 43 tables with lots of column data and who knows what else: mysql> show tables; +----------------------+ | Tables_in_wiki | +----------------------+ | dp_archive | | dp_category | | dp_categorylinks | | dp_change_tag | | dp_externallinks | | dp_filearchive | | dp_hitcounter | | dp_image | | dp_imagelinks | | dp_interwiki | | dp_ipblocks | | dp_ipblocks_old | | dp_job | | dp_langlinks | | dp_logging | | dp_math | | dp_objectcache | | dp_oldimage | | dp_page | | dp_page_props | | dp_page_restrictions | | dp_pagelinks | | dp_protected_titles | | dp_querycache | | dp_querycache_info | | dp_querycachetwo | | dp_recentchanges | | dp_redirect | | dp_revision | | dp_searchindex | | dp_site_stats | | dp_tag_summary | | dp_templatelinks | | dp_text | | dp_trackbacks | | dp_transcache | | dp_updatelog | | dp_user | | dp_user_groups | | dp_user_newtalk | | dp_valid_tag | | dp_validate | | dp_watchlist | +----------------------+ 43 rows in set (0.01 sec) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
