imdbpy2sql.py getting stuck on FLUSHING MoviesCache

Question

I finally got imbdpy2sql running on Windows 7 with Python 2.7 minGW and pymsql, and it connects to the database fine and creates all the tables but it keeps getting stuck on Flushind MoviesCache and never moves past it. This is its output:

SAVING ImdbID values for ... DONE
DROPPING current database ... DONE
CREATING New tables ... DONE
SCANNING movies

and it lists 10001 and then 20001 and so on until 90001 and then it says * FLUSHING MoviesCache

but it never moves past it. How long should I let it sit there like this? I've left it for at least an hour with no progress if not two hours. Is there anything I can do to get it working? Or is it working and I just need to let it sit for hours and hours?

Also in case this helps i run it by opening command prompt, cding to C:\Python27\Scripts\bin\ and then using this command :

imdbpy2sql.py -d C:\USers\Jordan\DEsktop\IMDB -u mysql://root:lookool@localhost/IMDB

Answer 1

No, it's not normal: the flush must take at most some tens of seconds.

I'll try to reproduce it; in the meanwhile, you can try using the CSV import system: run imdbpy2sql.py again with the same options, adding "-c C:\Temp" (no quotes - or something like that: maybe it requires two backslashes, for the directory separator, on a Windows system).

If you have access to a linux/unix environment, you can also do some experiment with partial sets of data, using the reduce.sh script in the docs/goodies/ directory.