MySQL to SQLite conversion issues

[osabate]

Hi Andrew,

I've been following the instructions on this wiki page and when I execute the mysqldump commands I get this error:

mysqldump: Error: 'Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'information_schema.FILES.TOTAL_EXTENTS' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' when trying to dump tablespaces

I'm using the sample files you have here, so things should just work. I'm on OS X 10.10 and I use MySQL 5.7.11.

Any clues?

Greatly appreciated!

[componavt]

Hi!

Do you used enwikt20140908_parsed.sql?

mysqldump in (1) Tables' structure preparations or (2) Data conversion caused the error?

[osabate]

Thanks for getting back to me Andrew.

Yes I used enwikt20140908_parsed.sq and it was on instruction (1) Table structure preparation.

Would you mind also sharing the end result of the SQLite file?