How to import big sql file in Phptheadmin

phpmyadmin

I am having a big sql file( 16mb) and all i need is to upload it to the Phpmyadmin to work with it in my localhost. I'm a newbie here in Php/MySql and i want to know about the details regarding the work.So, please suggest me the best.

Cheers and waiting for response.

Best Answer

Maximum file size you can upload is specified in your php.ini [ the configuration file for php ]. You would like to look for upload_max_filesize = 2M and change it to something else, for example 20M. You can also try to compress your file size, phpadmin accepts many different archives, like zip, gz etc.

Related Solutions

Mysql – phpMyAdmin and thesql not showing the same database

The database server that you are accessing using phpmyadmin and the mysql monitor (command line client) are different. If you look at the versions, phpmyadmin is accessing a 5.5.1-m2-community version, while you are accessing 5.6.17-community on the command line.

Either you are accessing a remote server or you have two separate installations of mysql on the server. If the later, use netstat -aon | more or the Task Manager to locate the mysql processes running on your machine (and on which port they are listening).

PhpMyAdmin Import Error – Fixing MySQL Server Has Gone Away/Unrecognized Keyword Error

Changing the MySQL settings worked. This is what I changed, exactly:

In php.ini

Find:

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

In my.ini (MySQL File)

Under mysqld add: max_allowed_packet = 500M

Best Answer

Related Solutions

Mysql – phpMyAdmin and thesql not showing the same database

PhpMyAdmin Import Error – Fixing MySQL Server Has Gone Away/Unrecognized Keyword Error

Related Question