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?