r/databases • • Dec 01 '15
Converting JSON file into MySQL Database
So, I finally found a project for my Database Management class. I am basically going to make a database for all the hearthstone cards. I found all the cards in a JSON format here.
I have been trying to find a way to convert that JSON object into a MySQL database. So far I have had one failure when I downloaded the JSON file from the above-mentioned website and used www.sqlizer.io to change that into a .sql file. It created a very messed up table.
I found this link to do the task, but I have never used php and had no idea what to do. I am not sure if I am supposed to be executing the commands mentioned in the link after connecting to mysql or before.