Convert large JSON file to MySQL

Question

I have a ~1MB JSON file that needs to be converted to MySQL. The file has close to 400 records. What is the best way to do this using PHP ?

If i try to add 400 records in a single pass, I either get the memory or execution time error. Whats the best way around this ?

Kalium · Accepted Answer · 2010-07-09 06:58:18Z

1

Try a multi-stage approach. Use json_decode() to turn the records into INSERT statements. Then you can use the FILE command in the mysql client to run all the inserts.

answered Jul 9, 2010 at 6:58

Kalium

4,6922 gold badges20 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert large JSON file to MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related