For Upload large size data in using phpmyadmin Do following steps.
Problem:
I have been trying to import Database through phpMyAdmin. My database file is a.sql and it’s size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying:
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.Solutions:
XAMPP
Here is what I’ve done:
- Gone to my XAMPP installed directoy
C:\xampp\php - Open the “Configuration Settings” file named
php.iniusing your text editor, preferably you can also you Notepad for Windows machine. - Somewhere nearby on line no 886, please update it to
upload_max_filesize = 128M - Similarly on line no 735
post_max_size = 128M - On line no 442
max_execution_time = 300 - On line no 452
max_input_time = 60 - Restart your Apache from either XAMPP Control Panel or using CMD in Windows https://stackoverflow.com/a/6723485/969092
Done!
WAMPP
For Upload large size data in using phpmyadmin Do following steps.
- Open php.ini file from C:\wamp\bin\apache\Apache2.4.4\bin Update following lines
max_execution_time = 259200 max_input_time = 259200 memory_limit = 1000M upload_max_filesize = 750M post_max_size = 750Mthan after restart wamp server or restart all services Now Upload data using import function in phymyadmin. Apply second step if till not upload data.
- open config.default.php file in c:\wamp\apps\phpmyadmin4.0.4\libraries (Open this file accoring to phpmyadmin version)
Find$cfg['ExecTimeLimit'] = 300;Replace to$cfg['ExecTimeLimit'] = 0;
Now you can upload data.
You can also upload large size database using MySQL Console as below.
- Click on WampServer Icon -> MySQL -> MySQL Consol
- Enter your database password like
rootin popup - Select database name for insert data by writing command
USE DATABASENAME - Then load source sql file as
SOURCE C:\FOLDER\database.sql - Press enter for insert data.
Note: You can’t load a compressed database file e.g. database.sql.zip or database.sql.gz, you have to extract it first. Otherwise the console will just crash.
Use command line:
mysql.exe -u USERNAME -p PASSWORD DATABASENAME < MYDATABASE.sqlwhere MYDATABASE.sql is your sql file.