On 01/04/12 17:37, Piotr Jagielski wrote:
I don't have MediaWiki installed. I'm just trying to import the dump into a standalone database so I can do some batch processing on the data.
Regards, Piotr
It inserts the data fine for me. I suspect your java code is failing to appropiately read them. Try reading the table with a different tool, such as phpMyAdmin.
mysql> select * from categorylinks limit 20; +---------+---------------------------------------+-------------------------------------+---------------------+-------------------+--------------+---------+ | cl_from | cl_to | cl_sortkey | cl_timestamp | cl_sortkey_prefix | cl_collation | cl_type | +---------+---------------------------------------+-------------------------------------+---------------------+-------------------+--------------+---------+ | 0 | Ekspresowe_kasowanko | Golembiovski Andzey | 2009-07-09 21:01:30 | | | page | | 2 | Języki_skryptowe | AWK AWK | 2011-01-18 01:11:23 | Awk | uppercase | page | | 4 | Specjalności_lekarskie | ALERGOLOGIA | 2008-04-25 10:31:22 | | uppercase | page | | 6 | Formaty_plików_komputerowych | ASCII | 2011-09-23 11:01:05 | | uppercase | page | | 6 | Kodowania_znaków | ASCII | 2011-09-23 11:01:05 | | uppercase | page | | 7 | Artykuły_na_medal | ATOM | 2010-12-01 16:40:37 | | uppercase | page | | 7 | Artykuły_wymagające_dopracowania | ATOM | 2011-08-16 15:53:43 | | uppercase | page | | 7 | Atomy | ATOM | 2011-08-09 00:56:39 | | uppercase | page | | 8 | Logika_matematyczna | AKSJOMAT | 2007-11-10 08:18:06 | | uppercase | page | | 10 | Arytmetyka | ARYTMETYKA | 2011-10-17 02:36:39 | | uppercase | page | | 11 | Artykuły_pod_opieką_Projektu_Chemia | AMINOKWASY | 2011-08-19 02:48:21 | | uppercase | page | | 12 | Alkeny | * ALKENY | 2006-08-07 17:23:22 | * | uppercase | page | | 13 | Multimedia | ACTIVEX | 2007-05-24 20:20:15 | | uppercase | page | | 13 | Windows | ACTIVEX | 2007-05-24 20:20:15 | | uppercase | page | | 14 | Interfejsy_programistyczne | ! APPLICATION PROGRAMMING INTERFACE | 2011-04-27 11:33:17 | ! | uppercase | page | | 15 | Amiga | AMIGAOS | 2007-09-09 17:19:11 | | uppercase | page | | 15 | Systemy_operacyjne | AMIGAOS | 2007-09-09 17:19:11 | | uppercase | page | | 16 | Organizacje_międzynarodowe | ASSOCIATION FOR COMPUTING MACHINERY | 2011-10-19 15:52:28 | | uppercase | page | | 18 | Funkcje_boolowskie | ALTERNATYWA | 2007-03-23 17:43:05 | | uppercase | page | | 19 | Logika_matematyczna | AKSJOMAT INDUKCJI | 2007-08-31 22:54:55 | | uppercase | page | +---------+---------------------------------------+-------------------------------------+---------------------+-------------------+--------------+---------+ 20 rows in set (0.00 sec)