Write a PHP script to migrate our project’s Mixpanel data into a MySQL database


- PHP (expert-level)

- MySQL (intermediate)

- Must have experience integrating third-party APIs, traversing *A LOT* of data & then doing something with the data (e.g. storing it in a database)


5 hours

Expected turn-around time:

24 hours


Write a PHP script that traverses our JSON-formatted Mixpanel data and inserts it into a MySQL database table.

The PHP script must:

1. implement Mixpanel's PHP client library ([url removed, login to view]),

2. export our project's raw data ([url removed, login to view]),

3. traverse its results (API returns one JSON-formatted object per line),

4. insert each object's data as a row into the MySQL table (matching the object's values to its corresponding table column)

Goal is to migrate our data currently stored within Mixpanel (stored in JSON format) into a MySQL database that reflects an object model that we can then run MySQL computations on.

We will provide you with a blank MySQL database with the appropriate table/column structure

Skills: Database Administration, MySQL, PHP

See more: traversing in data structure, traversing data structure, table data structure, mysql documentation, data, c data structure library, the hours script, project object model, mixpanel api, write a project, migrate mysql, json script, json and mysql, json mysql insert php, raw object, insert json php, traverse, php script mysql export, php mysql model, mysql inserted, mysql library, php json write, format project documentation, mysql object, php model mysql

About the Employer:
( 0 reviews ) United States

Project ID: #5843252

18 freelancers are bidding on average $24/hour for this job


Hello, Here with like to make you sure, that i am scrutinizing the work scope from every pin point to well elaborated aspects & gleaning the necessary information to discuss you promptly, when we have a quick chat. More

$21 USD / hour
(154 Reviews)

Hello, My name is Adrian. I own a software development company. I can provide you a dedicated full time senior web developer with over 7 years experience in web development for an hourly rate of 20$ per hour. More

$21 USD / hour
(33 Reviews)

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$25 USD / hour
(72 Reviews)

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

$41 USD / hour
(492 Reviews)

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [url removed, login to view] More

$20 USD / hour
(124 Reviews)

Expert in PHP and mySQL. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level Please see my reviews [url removed, login to view] More

$51 USD / hour
(10 Reviews)

Hello, We have some couple of questions..Could you please respond back,. so that we can clarify our queries. Can we have a discussion? We are an ISO 9001-2008 certified [url removed, login to view] are very good in mobile app More

$20 USD / hour
(32 Reviews)

Hello Sir I can help you ...................................... Best Bill ....................................

$25 USD / hour
(45 Reviews)

Hello Hiring manager, Greetings from Evidcomm!!! Happy to have your attention on our proposal.. We have gone through your requirements and would be pleased to work on.I have read your all project detail and as More

$15 USD / hour
(43 Reviews)

Dear sir, I will complete your project within 0 day and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "Write a PHP script to migrate our project’s Mixpanel data into a MySQL d More

$23 USD / hour
(70 Reviews)

I can help you with this in few hours starting now. I have done similar migration projects, some of them here on freelancer. Send me a message if interested. Thanks.

$25 USD / hour
(35 Reviews)

Hello,i can do what you need. If you are planning to do this only one time then i can download everything you want and return the mysql database in a zip format, or i can leave the php code on your server with informa More

$27 USD / hour
(43 Reviews)

I'll work on it. Please come on chat for further discussion, so that I can start the work right away. Features: 1. 2 months post delivery tech support free of cost. 2. My code will be W3C compliant, so it will help More

$22 USD / hour
(15 Reviews)

Hi Sir, "I UNDERSTOOD ALL YOUR REQUIREMENTS 100%", 24*7 On Skype Support. Dear Sir, We are having a team of technologies expert working in different technologies like php, woirdpress, Joomla, Smarty,.net, Magento More

$18 USD / hour
(11 Reviews)

I've experience on PHP-Mysql-Javascript-AJAX nearly two years at corporational companies.I've written your project description very well and I can develop it.I've experience on APIs that Could you please check my compl More

$15 USD / hour
(16 Reviews)

A proposal has not yet been provided

$22 USD / hour
(7 Reviews)

We are '3stechmind' team of dedicated software professionals developing the web projects for our [url removed, login to view] area of expertise is design the web site and implement the functional aspects in software technolgies like ph More

$21 USD / hour
(2 Reviews)

Hi, I have experience in php and mysql and also in json data processing. And ready to start work now. I think i can handle this with their php library Regards

$15 USD / hour
(1 Review)

I'm an expert in Database Development. I can provide expertise in DataBases like MySql, Oracle and Sybase. I really interested in your project as it is exactly within scope of my expertise. I can provide inside knowle More

$22 USD / hour
(0 Reviews)

Hello I have just reviewed your job description and attachment carefully. ALL SKILLS you need have never been problem for me. Anyhow, I can solve any problem there as I have long years experience in web developme More

$21 USD / hour
(0 Reviews)