On Nov 14, Esme <[EMAIL PROTECTED]> wrote:
> I have python 2.4, IMDbPY 2.7 and SQLObject installed, the plain > text files of imdb downloaded and navicat to use mySQL. Hi! If everything is correctly installed (and MySQL is running), you just have to create an empty database (call it "imdb") and then you have to open a shell (a dos prompt if you are on Windows), move in the directory where the imdbpy2sql.py script resides and run: imdbpy2sql.py -d /dir/with/plainTextDataFiles/ -u 'URI' Where the 'URI' argument is a string representing the connection to your database, with the schema: scheme://[user[:[EMAIL PROTECTED]:port]/database[?parameters] Example: mysql://myName:[EMAIL PROTECTED]/imdb If eveything is right, the script will run for about 2/3 hours populating your MySQL database. If you have questions and/or you encounter problems, let me know! > alternative methods/software that can import the whole database; If you need a more "all-in-one" graphic solution, you may take a look at JMDB: http://www.jmdb.de/ PS: it's much better if you use the CVS version of IMDbPY: http://imdbpy.sourceforge.net/imdbpy-cvs.tar.gz -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
