PhpMyAdmin Import file size

Navigation
1

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:


HomeWhenItrytoimportititgivesmethefollowingerror:

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

    
asked by anonymous 28.12.2015 / 20:46

1 answer

0

I suggest that you import the database, accessing mysql from the command prompt, it is much faster and you will not have problems with the size of your file.

Example: 

mysql -u username -p nome_banco < nome_do_arquivo.sql
    
28.12.2015 / 21:42
My chrome theme image does not fill the entire screen. What is wrong? How to find out all objects on a JoyStick?