{"issue":{"state":"closed","created_at":"2011-12-03T07:30:27Z","updated_at":"2011-12-07T00:39:39Z","user":{"gravatar_id":"2942e14d6ac0d238d35a514fe27d5a78","id":1237673,"url":"https://api.github.com/users/pwhipp","login":"pwhipp","avatar_url":"https://secure.gravatar.com/avatar/2942e14d6ac0d238d35a514fe27d5a78?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":5,"body":"I initially tried\r\n'schemasync mysql://root:xxx@localhost:3306/magento mysql://root:xxx@localhost:3306/another_db\r\n\r\nThe result was a slew of lines like this:\r\n/usr/local/lib/python2.6/dist-packages/SchemaObject-0.5.3-py2.6.egg/schemaobject/connection.py:63: Warning: Triggers for table `alitoco_development`.`jos_users` have no creation context\r\n  cursor.execute(sql, values)\r\n/usr/local/lib/python2.6/dist-packages/SchemaObject-0.5.3-py2.6.egg/schemaobject/connection.py:63: Warning: Triggers for table `empty_ptp`.`pp_activities` have no creation context\r\n  cursor.execute(sql, values)\r\n...\r\nThese relate to other databases on localhost rather than those specified. I worked around the problem by switching from root to users that can only access the particular db of interest but this looks like a significant bug to me. Output was generated successfully when I used users that only had access to the single relevant db.","assignee":null,"id":2436369,"number":14,"labels":[],"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"title":"script analyses wrong databases","html_url":"https://github.com/mmatuson/SchemaSync/issues/14","closed_at":"2011-12-07T00:39:39Z","url":"https://api.github.com/repos/mmatuson/SchemaSync/issues/14","milestone":null},"action":"created","comment":{"created_at":"2011-12-07T00:39:39Z","updated_at":"2011-12-07T00:39:39Z","user":{"gravatar_id":"b2c96a9ae02aa1819b5a467a0964e5c6","id":63929,"url":"https://api.github.com/users/mmatuson","login":"mmatuson","avatar_url":"https://secure.gravatar.com/avatar/b2c96a9ae02aa1819b5a467a0964e5c6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"The problem appears to be related to your MySQL installation and not SchemaSync, so I am going to close the issue. \r\n\r\n","id":3041454,"url":"https://api.github.com/repos/mmatuson/SchemaSync/issues/comments/3041454"}}