How to execute large MySql data-insert script file?

Trying to use PHPMyAdmin doesn't allow me to execute 150Mb d开发者_StackOverflow社区ata script file. Do you have any work-around for me?

Update

My script is utf-8 encode.

I've update php.ini but all still get error as the below snapshot.

[php.ini]

upload_max_filesize = 256M    
max_execution_time = 0    
memory_limit = 256M

Try this: http://www.ozerov.de/bigdump/

Bigdump also provides you changing character set

Use split on linux or a windows split program to split your script in multiple parts. And then load them one by one.

Give max_execution_time = 1500 (Which means 25 minuets)

Default execution time is 30sec, http://php.net/manual/en/info.configuration.php

Use native mysql console client. To import that file use

mysql -u [username] -p[password] [database_name] < [your_sql_file]