Hi there! I'm trying to import the whole IMDB database into mySql, but here and there this error appears importing movies, and later on other tables too:
SCANNING movies: "Studio Luma" (2014) {Bye Bye Blondie (#4.2)} (movieID: 2190001) * FLUSHING MoviesCache... * TOO MANY DATA (100000 items in MoviesCache), recursion: 1 * SPLITTING (run 1 of 2), recursion: 1 * FLUSHING MoviesCache... * TOO MANY DATA (50000 items in MoviesCache), recursion: 2 * SPLITTING (run 1 of 2), recursion: 2 * FLUSHING MoviesCache... * TOO MANY DATA (25000 items in MoviesCache), recursion: 3 * SPLITTING (run 1 of 2), recursion: 3 * FLUSHING MoviesCache... * TOO MANY DATA (12500 items in MoviesCache), recursion: 4 * SPLITTING (run 1 of 2), recursion: 4 * FLUSHING MoviesCache... * TOO MANY DATA (6250 items in MoviesCache), recursion: 5 * SPLITTING (run 1 of 2), recursion: 5 * FLUSHING MoviesCache... * TOO MANY DATA (3125 items in MoviesCache), recursion: 6 * SPLITTING (run 1 of 2), recursion: 6 * FLUSHING MoviesCache... * SPLITTING (run 2 of 2), recursion: 6 * FLUSHING MoviesCache... * TOO MANY DATA (1563 items in MoviesCache), recursion: 7 * SPLITTING (run 1 of 2), recursion: 7 * FLUSHING MoviesCache... * SPLITTING (run 2 of 2), recursion: 7 * FLUSHING MoviesCache... * TOO MANY DATA (782 items in MoviesCache), recursion: 8 * SPLITTING (run 1 of 2), recursion: 8 * FLUSHING MoviesCache... * SPLITTING (run 2 of 2), recursion: 8 * FLUSHING MoviesCache... * TOO MANY DATA (391 items in MoviesCache), recursion: 9 * SPLITTING (run 1 of 2), recursion: 9 * FLUSHING MoviesCache... * TOO MANY DATA (195 items in MoviesCache), recursion: 10 * SPLITTING (run 1 of 2), recursion: 10 WARNING recursion level exceded trying to flush data WARNING this batch of data is lost (MoviesCache). * SPLITTING (run 2 of 2), recursion: 10 * SPLITTING (run 2 of 2), recursion: 9 * SPLITTING (run 2 of 2), recursion: 5 * SPLITTING (run 2 of 2), recursion: 4 * SPLITTING (run 2 of 2), recursion: 3 * SPLITTING (run 2 of 2), recursion: 2 * SPLITTING (run 2 of 2), recursion: 1 I searched on google and I found a comment on this suggesting to increase the max_allowed_packet value in mysql server. I did it (brought up to 500M) but still the problem represent itself. Any other hint? Many many thanks Giovanni ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help