how to import one large data into mysql database

when we import data from file into database, there is usually restriction for the file size. For example, if we want to import file into mysql, which is larger than 128 M. Then we cann't import file by UI, we need import it through command line.

For windows, you need to type the flowing command line：
mysql -h localhost -r root password databasename<infile.sql;