Hi, I am working on an Adobe Air project(using JavaScript and HTML). Users can install application and can enter customer details. The central server(PHP + MySQL) contains all the customer data and air applications sends customer data to that server and request for new data from the server. This process is working fine. But now I want one more option, the user can export customer table from live and import in Air application's SQLite database. The customer table has millions of records a the sql data dump of customer table is 100MB +. We can create csv or xml file and download it as a zip file using PHP so the data file size will be less than 20MB.
Which is the best format for exporing the data and the best method for parsing this file and inserting the data in to the SQLite database?