Steven J Tighe

I think that fixed it. I followed the guidance here: https://stackoverflow.com/questions/36647058/removing-duplicates-with-unique-index Replaced this around line 125 ALTER IGNORE TABLE mlb.tGames ADD UNIQUE INDEX idx_temp (gameName); with CREATE TABLE mlb.tGames_t SELECT * FROM mlb.tGames; TRUNCATE TABLE mlb.tGames; ALTER TABLE mlb.tGames ADD UNIQUE INDEX idx_temp (GameName); INSERT IGNORE INTO mlb.tGames SELECT * FROM mlb.tGames_t; DROP TABLE mlb.tGames_t; and around line 200 ALTER IGNORE TABLE...

Here's the answer: https://dba.stackexchange.com/questions/143862/mysql-alter-ignore-add-index-removed-in-mysql-5-7-4-what-to-use-instead The IGNORE clause for ALTER TABLE ( http://dev.mysql.com/doc/refman/5.6/en/alter-table.html ) is now deprecated and will be removed in a future version of MySQL. ALTER IGNORE TABLE causes problems for replication, prevents online ALTER TABLE for unique index creation, and causes problems with foreign keys (rows removed in the parent table). I'm using 5.7.20. I'll...

So I ran the sql script again today and had a LOT more luck, though not complete success. I wonder if there was some data that just didn't get picked up out of gameday the first couple times I ran the bbos.py script? At the moment, as best I can tell, here are what appear to be the "permanent" tables (i.e. not like mlb.tpitches or something) that the script doesn't put in the database: pitches hits atbats atbatresults pitchlocation pitchresult batterhand Also the four temp tables t<base>Umps are...

So for the record I fixed the "group by" error - the server was set to have very strict group-by restrictions. I reset the default: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Not sure about the syntax errors tho.

So for the record I found the "group by" error - the server was set to have very strict group-by restrictions. I reset the default: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Not sure about the syntax errors tho.

Ah ok, thanks. I didn't realize that I should expect those "table does not exist" errors as normal. The other errors look like "ERROR 1055 (42000): Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmp.abbreviation' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" and "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version...

I'm just getting BBOS set up now. This is great, and is exactly what I was looking for (Baseball Hacks had a script to do this but I couldn't get it to work). I am running this on Ubuntu. I'm generally a MySQL noob and even less than a noob in Python. I was able to work around a few things to get things installed and import Gameday data using BBOS. I'm running into a problem running the NormalizeIntoMLB script, which I think is related to the fact that the script thinks I'm in Windows. In the bbos...