From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Switching Database Engines |
Date: | 2011-04-26 19:24:45 |
Message-ID: | BANLkTin=zBR3m2ccRsEq+K2Z=BnzboHFtQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 26, 2011 at 3:06 PM, Greg Sabino Mullane <greg(at)turnstep(dot)com> wrote:
> Correct. Keep in mind I don't think the XML route will convert the users
> table, just the wiki data itself. As someone else mentioned, the
> wiki itself will work fine, but support for any MediaWiki extensions
> is hit or miss because MediaWiki was a MySQL only shop for so long
> (and Wikimedia still uses it, and they influence a lot of the MW
> development).
So what is the ideal or best suggested approach on tackling this task?
I built the new Apache server and installed the new (latest) version
of MediaWiki on it. I then pointed the installation of the new server
to my existing PostgreSQL database server. I created a user and
database for MediaWiki to use but it self generated a new table schema
during the installation. Should I proceed or do I somehow need to
blast what the new installation did and migrate my old data in it's
place. I guess there just isn't a clean understanding on my part on
what I need to do in what particular order.
I tried running the tool as suggested before and unless I'm doing
something wrong, I have no idea why it didn't work:
[root(at)db_old postgres]# pwd
/var/www/html/int/main/wiki/maintenance/postgres
[root(at)db_old postgres]# ls -l
total 60
drwxr-xr-x 2 root root 4096 Jul 13 2009 archives
-rw-r--r-- 1 root root 13988 Mar 12 2009 compare_schemas.pl
-rw-r--r-- 1 root root 14063 Nov 22 2008 mediawiki_mysql2postgres.pl
-rw-r--r-- 1 root root 23596 Mar 19 2009 tables.sql
[root(at)db_old postgres]# sh mediawiki_mysql2postgres.pl
mediawiki_mysql2postgres.pl: line 12: use: command not found
mediawiki_mysql2postgres.pl: line 13: use: command not found
mediawiki_mysql2postgres.pl: line 14: use: command not found
mediawiki_mysql2postgres.pl: line 15: use: command not found
mediawiki_mysql2postgres.pl: line 17: syntax error near unexpected token `('
mediawiki_mysql2postgres.pl: line 17: `use vars qw(%table %tz %special
@torder $COM);'
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-04-26 19:31:26 | Re: Switching Database Engines |
Previous Message | Greg Sabino Mullane | 2011-04-26 19:06:58 | Re: Switching Database Engines |