On Sat, Apr 30, 2011 at 4:29 AM, Greg Smith wrote:
> I wouldn't fight with this too much though. Unless you have some really
> customized stuff in your wiki, there really is nothing wrong with the idea
> of dumping everything into XML, creating a blank PostgreSQL-backed MediaWiki
> install, then
On 04/28/2011 12:19 PM, Carlos Mennens wrote:
It seems that the 'mysql2postgres.pl' tool has instructions embedded
into the file so I ran the command as instructed to take the output
file and insert it into my PostgreSQL server and got the following
error message:
$ psql -p 5432 -h db1 -U wiki -
It seems that the 'mysql2postgres.pl' tool has instructions embedded
into the file so I ran the command as instructed to take the output
file and insert it into my PostgreSQL server and got the following
error message:
$ psql -p 5432 -h db1 -U wiki -f mediawiki_upgrade.pg
Password for user wiki:
B
I was able to export the Wiki database into a single file using the
conversion tool mentioned previously.
root@ideweb1 postgres]# ./mediawiki_mysql2postgres.pl --db=wiki
--user=mediawiki --pass=**
Writing file "mediawiki_upgrade.pg"
As you can see above that generated a new file in my
On Tue, Apr 26, 2011 at 4:34 PM, Alban Hertroys
wrote:
> I don't know much about mediawiki (except for how to use it), but it's not
> unusual for modern web-apps to have some functionality to dump their contents
> in a consistently formatted file (often XML) that it can subsequently import
> in
On 26 Apr 2011, at 19:24, Carlos Mennens wrote:
> 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 s
On 04/26/11 12:24 PM, Carlos Mennens wrote:
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@db_old postgres]# pwd
/var/www/html/int/main/wiki/maintenance/postgres
[root@db_old postgres]# ls -l
total 60
drwxr-xr-x 2 roo
On Tue, Apr 26, 2011 at 3:06 PM, Greg Sabino Mullane 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
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Just to be clear and make sure I understand correctly, I can export
> the Wiki info using the MediaWiki XML export tool (which I found) or I
> can try to use the MediaWiki tool referenced as
> 'mediawiki_mysql2postgres.pl', right? I think from
On Tue, Apr 26, 2011 at 1:44 PM, Greg Sabino Mullane wrote:
> In general, yes. For your specific use case, it might be best to use
> MediaWiki's XML dump and restore. You could also use the conversion
> script that comes with MediaWiki, at:
>
> maintenance/postgres/mediawiki_mysql2postgres.pl
>
>
On Apr 26, 2011, at 10:24 AM, Carlos Mennens wrote:
> 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 th
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> 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
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 decommissio
13 matches
Mail list logo
