--Apple-Mail-1--146543609
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit
If upgrading MediaWiki to a version that sup****ts postgres 8.3,
another option could be to ex****t from the old db as XML (using the
Special:Ex****t page) then im****t once the new wiki's installed with a
blank database - that's what I'm going to try, I've had problems
upgrading MediaWiki databases in the past, possibly due to customised
installations. This should hopefully render any database issues
irrelevant.
You need to know the names of the pages to ex****t, but could get those
with a simple query direct to the database like
SELECT pagetitlecolumn FROM tablewherepagetitlesarestored;
- see http://www.mediawiki.org/wiki/Manual:Database_layout
Regards
Oliver
On 30 May 2008, at 22:10, pgsql-general-owner@[EMAIL PROTECTED]
wrote:
> http://www.postgresql.org/docs/8.3/static/textsearch-migration.html
> http://www.postgresql.org/docs/8.3/static/tsearch2.html
>
> I haven't personally tried that procedure with MediaWiki, though.
--Apple-Mail-1--146543609
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; "><div>If upgrading MediaWiki to =
a version that sup****ts postgres 8.3, another option could be to ex****t =
from the old db as XML (using the Special:Ex****t page) then =
im****t once the new wiki's installed with a blank database - that's what =
I'm going to try, I've had problems upgrading MediaWiki databases in the =
past, possibly due to customised installations. This should hopefully =
render any database issues irrelevant.</div><div><br></div><div>You need =
to know the names of the pages to ex****t, but could get those with a =
simple query direct to the database like</div><div><br></div><div>SELECT =
pagetitlecolumn FROM =
tablewherepagetitlesarestored;</div><div><br></div><div>- see <a =
href=3D"http://www.mediawiki.org/wiki/Manual:Database_layout">http://www.m=
ediawiki.org/wiki/Manual:Database_layout</a></div><div><br></div><div>Rega=
rds</div><div>Oliver</div><br><div><div>On 30 May 2008, at 22:10, <a =
href=3D"mailto:pgsql-general-owner@[EMAIL PROTECTED]
">pgsql-general-owner@[EMAIL PROTECTED]
> wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><span =
class=3D"Apple-style-span" style=3D"border-collapse: separate; color: =
rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: =
normal; font-variant: normal; font-weight: normal; letter-spacing: =
normal; line-height: normal; orphans: 2; text-align: auto; text-indent: =
0px; text-transform: none; white-space: normal; widows: 2; word-spacing: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0; "><a =
href=3D"http://www.postgresql.org/docs/8.3/static/textsearch-migration.htm=
l">http://www.postgresql.org/docs/8.3/static/textsearch-migration.html</a>=
<br><a =
href=3D"http://www.postgresql.org/docs/8.3/static/tsearch2.html">http://ww=
w.postgresql.org/docs/8.3/static/tsearch2.html</a><br><br>I haven't =
personally tried that procedure with MediaWiki, =
though.<br></span></blockquote></div><br><div =
apple-content-edited=3D"true"> <span class=3D"Apple-style-span" =
style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: 12px; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; =
white-space: normal; widows: 2; word-spacing: 0px; =
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: =
0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0; "><div style=3D"word-wrap: =
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; "><span class=3D"Apple-style-span" =
style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: 12px; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; =
"><div><br></div></span></div></span></div></body></html>=
--Apple-Mail-1--146543609--
|
