Phpmyadmin Import file size

Question

I’m having trouble importing a 600mb . sql file.

My PHP is already authorized to receive files of this size:

memory_limit =1000M
post_max_size = 1000M
upload_max_filesize = 1000M
max_execution_time = 30000
max_input_time = 30000

but still in Phpmyadmin the limit is 128mb:

When I try to import it results in the following error:

I do not understand why this happens, I thank you in advance.

Answer 1

I suggest you do the import from the database, accessing mysql by command prompt, is much faster and you will not have problems with the size of your file and will not need to change your PHP settings.

Example:

mysql -u username -p nome_banco < nome_do_arquivo.sql