MySQL dump is too large to upload through phpMyAdmin

[What]

I installed Xampp to test a phpBB install locally. I exported the database and my dump is 160MB. In Xampp, phpMyAdmin limits imports to 2MB. I tried changing those limits in php.ini without success.

Is there any way to import a large MySQL dump? Thanks!

[Wiedmann]

I tried changing those limits in php.ini without success.

How exactly?

[What]

Thanks for answering! I tried to follow those instructions:

http://localhost/phpmyadmin/Documentation.html#faq1_16

I changed:
max_execution_time = 300000
max_input_time = 600000
memory_limit = 210M
post_max_size = 210M
upload_max_filesize = 200M

But in phpMyAdmin it still says:

Location of the text file [choose file] (Max: 2,048 KiB)

EDIT: I restarted Apache and now it says (Max: 205 kKiB) - but it still doesn't seem to work. I get a progress bar in my browser for about one or two minutes, then it stops, and, nothing...

[Wiedmann]

I get a progress bar in my browser for about one or two minutes, then it stops, and, nothing...

Can you see something in the error_log?

Making a large import with phpMyAdmin is not easy.

Maybe the UploadDir feature from phpMyAdmin can help.

Or just use the MySQL command line client. (This works every time).

[What]

Wiedmann, Thanks for the help. I kinda gave up for now as I'm trying to do the update live wihtout having to test it locally. But this is info I'll come back to if (when) I have to do some local testing again.

Thanks!