On Feb 01, Bjørn von Rimscha <b.vonrims...@gmail.com> wrote: > * SPLITTING (run 1 of 2), recursion: 1 [...] > File "C:\Python26\lib\site-packages\MySQLdb\connections.py", line 36, in > defaulterrorhandler raise errorclass, > errorvalue_mysql_exceptions.IntegrityError: (1062, "Duplicate entry '262918' > for key 'PRIMARY'") > > Does that mean splitting created dupicates?
Something like that. :-/ It goes without saying that it shouldn't. :-) > Or is there a mistake in the imdb data Improbable: the plain text data files contain some crap, but imdbpy2sql.py is supposed to work around these problems. Moreover, the IDs used as primary key in the 'title' (and other) tables are made up by imdbpy2sql.py itself, and not taken from the plain text data files. > I also increased the max_allowed_packet value as suggested in the read > me file only with the same result. [...] > MySQL 5.1 > Python 2.6.4 > Windows 7 Honestly, I'm getting a lot of bug reports about MySQL on Windows 7 or Vista. It's crazy that nobody is able to make it work: splitting the data we're sending to the database is just a fail-safe measure, and as you can imagine it would be better if it never happens. Under Linux I've never seen these problems: tomorrow I'll try to set up my own MySQL to reproduce the problem, if I can (as you can guess the code used to split the data set is not extensively tested). I have some solutions you can try (beside moving to a sane Unix environment, I mean ;-) : 1. use CSV files, as described in the README.sqldb file. Basically, add to your command line something like: -c C:/path/to/an/empty/directory/ But also read the notices in README.sqldb about CSV files and Windows paths. PS: right now in the SVN, I'm improving support for CSV handling, so that you can decouple the creation of the CSV file from the insertion of the data in the database. 2. use PostgreSQL or another supported database. In the meanwhile, if someone has any idea about why MySQL on Vista/7 accepts so few data at a time, is solicited to share his thoughts. :-) Let me know if/how you fix the problem! -- Davide Alberani <davide.alber...@gmail.com> [GPG KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help