dataset-examples icon indicating copy to clipboard operation
dataset-examples copied to clipboard

yelp_db.sql has errors when trying to import into MySQL

Open yelp11976 opened this issue 8 years ago • 3 comments

mysql -u root -p yelp_db < yelp_db.sql aborting with the error:

ERROR 1064 (42000) at line 881: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''PvjfVRC_OlmOlIu' at line 1

yelp11976 avatar Oct 03 '17 00:10 yelp11976

@yelp11976 thanks for creating the issue here!

I ran the import script without issues. What version of MySQL are you running?

tomelm avatar Oct 03 '17 17:10 tomelm

Can you advise on how to import the yelp dataset json to MongoDB? Thanks in advance

On Tue, Oct 3, 2017 at 10:35 AM, Tomer Elmalem [email protected] wrote:

@yelp11976 https://github.com/yelp11976 thanks for creating the issue here!

I ran the import script without issues. What version of MySQL are you running?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Yelp/dataset-examples/issues/35#issuecomment-333920697, or mute the thread https://github.com/notifications/unsubscribe-auth/Ae912CB68B8_vABZ9Z_qCC8bllfw8h9Vks5sonBhgaJpZM4PrbdI .

yelp11976 avatar Nov 03 '17 22:11 yelp11976

I'm not too familiar with MongoDB so I don't really know how to import the data there. Sorry @yelp11976!

tomelm avatar Nov 10 '17 08:11 tomelm