IMDB to MySQL: Insert IMDB data into MySQL database

php python mysql sql imdb
Emil Devantie Brockdorff picture Emil Devantie Brockdorff · Aug 30, 2011 · Viewed 19k times · Source

I’m looking for a solution to import all the IMDB data into my own MySQL database. I’ve downloaded all the IMDB data files from their homepage which are all in the file format *.list (in Windows).

I want to retrieve and that information and insert it correctly into my MySQL database so I can do some test and query searches.

I followed a guide but about half I realized that it was a 2004 guide and the way things works now did not go well with the tools from seven years ago.

I’ve browsed the net for applications, php-scripts, python-script and what not to find a solution but with no luck. The W32 tool that IMDB themselves references to don’t work either.

Is there anyone who knows a solution or a way to do this task?

Answer

Ernestas Stankevičius picture Ernestas Stankevičius · Aug 30, 2011

There is some nice py script, witch helped me. Just make connection and run it. ~1hr to work around everything.

EDIT: Use this readme file for making script.

Related questions

Whether to use "SET NAMES"

In reading "High performance MySQL" from O'Reilly I've stumbled upon the following Another common garbage query is SET NAMES UTF8, which is the wrong way to do things anyway (it does not change the client library's character set; it affects …

Read More
How to Implement A Recommendation System?

I've Collective Intelligence book, but I'm not sure how it can be apply in practical. Let say I have a PHP website with mySQL database. User can insert articles with title and content in the database. For the sake of …

Read More
Running a Python script from PHP

I'm trying to run a Python script from PHP using the following command: exec('/usr/bin/python2.7 /srv/http/assets/py/switch.py arg1 arg2'); However, PHP simply doesn't produce any output. Error reporting is set to E_…

Read More