i use this for import expot db 250m aprox and works fast


Export

mysqldump -u username -p database_name > dumpfile.sql


Import


mysql -u username -p database_name < dumpfile.sql