On Mar 14, Karen Hartley <[EMAIL PROTECTED]> wrote: > I am trying to run imdbpy2sql to import the entire imdb into a > MySQL db.
Hi! > I get the schema created, and the smaller tables are populated... as > you can see by my console copied below, some sort of limitation > error occurs and processing stops. Is there a solution that will > get the larger tables populated? [...] > _mysql_exceptions.OperationalError: (2006, 'MySQL server has > gone away') At a very first sight, it seems that the problem can be in your MySQL configuration. Check your value for option max_allowed_packet; if it's too low (mine is set to 16M) try increasing it. The situation is: IMDbPY try to send a large amount of data at a single time to the database server (for performance reasons); if it receives back an error (ANY KIND of error, to be precise) it tries to split this large set of data in two, sendings these pieces separately. This operation is run recursively (if there're still errors) up to five times, after that it give up. Normally the problem is that MySQL accepts too small packets; your case can be a bit different: error 2006 "MySQL server has gone away" appears to be related to lost network connections; if possible try running the mysql server with the --disable-reconnect argument, to see if this (or another) error reappears. Unfortunately I'm not a database/MySQL expert, so this may requires some trial on your part, to spot the problem. Can you think of any good reason for a client (IMDbPY in this case) to lose connection with your MySQL server? PS: if possible, use the latest CVS version of IMDbPY, fetching the "newdesign" branch from CVS: cvs -z3 -d:pserver:[EMAIL PROTECTED]:/cvsroot/imdbpy co -r newdesign imdbpy Hope this helps, -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
