[Wikitech-l] correct way to import SQL dumps into MySQL database in terms of character encoding

2012-04-01 Thread Piotr Jagielski
Hello, I'm trying to import categorylinks.sql dump into my MySQL database. I'm able to import it and query for articles in specific categories as long the category name contains only English-language characters. I don't get any results if I try to query for non-English category name. My

Re: [Wikitech-l] correct way to import SQL dumps into MySQL database in terms of character encoding

2012-04-01 Thread Piotr Jagielski
These options should be equivalent. It does load the data using the below command. It just incorrectly handles non-English characters. Regards, Piotr On 2012-04-01 16:31, Svip wrote: On 1 April 2012 16:04, Piotr Jagielskipiotr.jagiel...@op.pl wrote: mysql --user root --password=root wiki

Re: [Wikitech-l] correct way to import SQL dumps into MySQL database in terms of character encoding

2012-04-01 Thread Piotr Jagielski
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 On 2012-04-01 17:30, Platonides wrote: On 01/04/12 17:05, Piotr Jagielski wrote: These options should be equivalent. It does load

Re: [Wikitech-l] correct way to import SQL dumps into MySQL database in terms of character encoding

2012-04-01 Thread Piotr Jagielski
Sorry, I made a mistake in the e-mail. I had the database set to the same name in both places. My problem is actually opposite because I don't get any result where I use UTF-8 string as an input in the query. But I verified that I don't get correct results where using the query you provided

Re: [Wikitech-l] snapshot of categories content and template usage

2012-01-16 Thread Piotr Jagielski
It looks like exactly what I was looking for. Thank you! Piotr On 2012-01-16 17:17, Petr Kadlec wrote: Hi, On 15 January 2012 12:26, Piotr Jagielskipiotr.jagiel...@op.pl wrote: Is there any easier option? Is there a dump of categorization and template usage kept somewhere? Yes, it is.

[Wikitech-l] snapshot of categories content and template usage

2012-01-15 Thread Piotr Jagielski
Hello, I'm trying to get information from Wikipedia dump based on categorization or template usage. I first query MediaWiki API with embeddedin or categorymembers query to get a list of articles I'm interested in. Then I retrieve them from the dump and extract the information I need. The