Cannot move mediawiki to another server

List overview All Threads
Download

newer

older

Template expansion in extension...

Adding additional text to monobook...

Fernando M. M.

24 Feb 2007 24 Feb '07

4:27 p.m.

Show replies by date

Fernando M. M.

24 Feb 24 Feb

4:34 p.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

Just adding some information. I'm NOT using the "Experimental charset support for MySQL 4.1/5.0." and i have moved the database using a dump from phpmyadmin. On Sat, 24 Feb 2007 14:27:03 -0200, Fernando M. M. <list(a)fernandomarcelo.com> wrote:

...

Hello, I'm trying to move mediawiki to another server. Everything was fine until i discovered that all special characters on wiki_page table were messed up. I really don't know what is going on because on the other tables all those special characters like ã or ó are ok. On the old server i'm using MySQL 5.0.24 and on the new server i have 5.0.27. What should i do? Thanks! _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Tels

4:52 p.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Moin, On Saturday 24 February 2007 17:34:07 Fernando M. M. wrote:

...

Just adding some information. I'm NOT using the "Experimental charset support for MySQL 4.1/5.0." and i have moved the database using a dump from phpmyadmin.

Did you pay attention to the charset upon import? I found that depending on the charset in your wiki, you need to use "Latin1" for the import to work correctly. best wishes, tels - -- Signed on Sat Feb 24 17:52:12 2007 with key 0x93B84C15. View my photo gallery: http://bloodgate.com/photos PGP key on http://bloodgate.com/tels.asc or per email. "A Thaum is the basic unit of magical strength. It has been universally established as the amount of magic needed to create one small white pigeon or three normal-sized billiard balls." -- Terry Pratchett

...PGP SIGNATURE...

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iQEVAwUBReBtaXcLPEOTuEwVAQKWsAf/SCtrgIfJ98c49jfTQNyJxAOLiTXQMo3z xomIwuM2T0T4bxS0WqmqTHrRY1OvwIkJcxfovJ6dkVumV5msKFqJQ7mfKgB9HFge +JJzFWCCi88P7ks6joNgvSLiTgFDJBe+ugF9T19Dvf80wUFnRujL/BLl8BqFPNDo zTN4PmcT++ASzkGAXbjtBFfwkRsByYrdsbsw79zPwKvVddtmkiDccl+I9HYUO/lu jQiMs4uG2586oyOgOFaDcte0YyFeP8jD4jWCfDC96K/RE2Lwi/NIW+d6XxQxXIbw qh77eIq5tnqYD6ZWS+Y0aSskzqYo/o3FNAG8ddApdGbveG9mhAAeiw== =XcR2 -----END PGP SIGNATURE-----

Rob Church

5:34 p.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

On 24/02/07, Fernando M. M. <list(a)fernandomarcelo.com> wrote:

...

I'm trying to move mediawiki to another server. Everything was fine until i discovered that all special characters on wiki_page table were messed up. I really don't know what is going on because on the other tables all those special characters like ã or ó are ok.

When exporting, ensure that the character set is kept as latin1. When importing, ensure that the character set is kept as latin1. MySQL will "helpfully" try to convert, and this will usually break things. Rob Church

Fernando M. M.

6:25 p.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

On Sat, 24 Feb 2007 17:34:23 +0000, "Rob Church" <robchur(a)gmail.com> wrote:

...

On 24/02/07, Fernando M. M. <list(a)fernandomarcelo.com> wrote:

I'm trying to move mediawiki to another server. Everything was fine

until i discovered that all special characters on wiki_page table were messed up. I really don't know what is going on because on the other tables all those special characters like ã or ó are ok. When exporting, ensure that the character set is kept as latin1. When importing, ensure that the character set is kept as latin1. MySQL will "helpfully" try to convert, and this will usually break things. Rob Church _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Hello, Here is what i'm trying. I go to phpmyadmin on the old server. Click on export and save it as a .zip package on my computer. Them i go to phpmyadmin on the new server. Click on import, select 'latin1', select the .zip file on my computer and import it. That's not working. On the old server looking directly into the database i see PÃ¡gina_principal On the wiki_page table. When i view at mediawiki i see Página principal (which means Main Page and that's correct). But when i view into the database at the new server i see PÃƒÂ¡gina_principal And on the wiki i see PÃ¡gina principal

Juliano F. Ravasi

7 p.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

Fernando M. M. wrote:

...

Here is what i'm trying. I go to phpmyadmin on the old server.

Forget phpMyAdmin. The export function completely breaks non-ASCII encodings for MediaWiki. I think this happens because MediaWiki uses a Latin1 charset to store UTF-8. All my problems regarding export/import MediaWiki databases were fixed once I started using mysqldump command-line utility to do the dumps. -- Juliano F. Ravasi ·· http://juliano.info/ 5105 46CC B2B7 F0CD 5F47 E740 72CA 54F4 DF37 9E96 "A candle loses nothing by lighting another candle." -- Erin Majors * NOTE: To contact me directly, replace "ml" with "contact" on my e-mail address. * AVISO: Para me contatar diretamente, troque "ml" por "contact" no endereço de e-mail.

Fernando M. M.

25 Feb 25 Feb

12:42 a.m.

New subject: [Mediawiki-l] Cannot move mediawiki to another server

Hello, It worked! That was a problem in phpmyadmin. Also i have seen some entries on the wiki that tells the user to backup using phpmyadmin. I guess this should be removed since, like me, he won't be able to restore his backup without breaking non-ASCII characters. Thank you! On Sat, 24 Feb 2007 17:00:07 -0200, "Juliano F. Ravasi" <ml(a)juliano.info> wrote:

...

Fernando M. M. wrote:

Here is what i'm trying. I go to phpmyadmin on the old server.

6268

days inactive

6269

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

6 comments

4 participants

tags (0)

participants (4)

Fernando M. M.
Juliano F. Ravasi
Rob Church
Tels