I have a huge database of 2M rows of data in localhost phpmyadmin. Data is about different countries. I want to export data related to USA from column named country (about 400k). But with the options available in phpmyadmin I can not do it. it either exports all data which is near 1.5gb (which cannot be imported into my online shared server) or just 500 rows with select and export option. Is there a way to export it country wise?

It would be good if exported data is in a format where 1 insert has 5000 rows in it.

So how can I export data that I have in

`SELECT * FROM `data` WHERE `country` LIKE 'United States'`

This options exports all data.

This option exports only 500 selected data or second one exports all data.