Hi everybody, I installed imbdpy and downloaded the imdb files to install a mysql database of it. I ran " ./imdbpy2sql.py -d /mnt/win_h/video/imdb_data/ --mysql-innodb -u 'mysql://user:passw...@localhost/base' " and everything went fine. It took about 5 hours to complete. At the end, i got the innodb tables created but the foreign keys weren't created. Here is the end of the logs:
* FLUSHING SQLData... SCANNING complete crew: Behind Blue Eyes (2009) SCANNING complete crew: Nora inu (1973) * FLUSHING SQLData... # TIME completeCast() : 0min, 8sec (wall) 0min, 7sec (user) 0min, 0sec (system) RESTORING imdbID values for movies... DONE! (restored 0 entries out of 0) RESTORING imdbID values for people... DONE! (restored 0 entries out of 0) # TIME fushing caches... : 0min, 3sec (wall) 0min, 1sec (user) 0min, 0sec (system) # TIME TOTAL TIME TO INSERT/WRITE DATA : 66min, 31sec (wall) 54min, 48sec (user) 0min, 30sec (system) building database indexes (this may take a while) # TIME createIndexes() : 36min, 23sec (wall) 0min, 0sec (user) 0min, 0sec (system) adding foreign keys (this may take a while) # TIME createForeignKeys() : 49min, 26sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "END:FOR_EVERY_TABLE:ALTER TABLE %(table)s ENGINE=InnoDB;"... EXECUTING "ALTER TABLE aka_name ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 35sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE aka_title ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 19sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE cast_info ENGINE=InnoDB;"... DONE! # TIME END command : 105min, 52sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE char_name ENGINE=InnoDB;"... DONE! # TIME END command : 3min, 39sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE comp_cast_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE company_name ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 23sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE company_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE complete_cast ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 5sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE info_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE keyword ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 6sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE kind_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE link_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE movie_companies ENGINE=InnoDB;"... DONE! # TIME END command : 1min, 30sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE movie_info ENGINE=InnoDB;"... DONE! # TIME END command : 11min, 58sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE movie_info_idx ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 51sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE movie_keyword ENGINE=InnoDB;"... DONE! # TIME END command : 1min, 37sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE movie_link ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 37sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE name ENGINE=InnoDB;"... DONE! # TIME END command : 5min, 47sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE person_info ENGINE=InnoDB;"... DONE! # TIME END command : 1min, 56sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE role_type ENGINE=InnoDB;"... DONE! # TIME END command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) EXECUTING "ALTER TABLE title ENGINE=InnoDB;"... DONE! # TIME END command : 2min, 9sec (wall) 0min, 0sec (user) 0min, 0sec (system) # TIME FINAL : 289min, 44sec (wall) 54min, 48sec (user) 0min, 30sec (system) I don't know if i did something wrong but i suspect that creating the foreign keys before having tables in innodb format is the problem because in myisam, we can't have foreign keys. Right now i'm generating the foreign keys 1 by 1 so i have some time to report the problem :) ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
