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.
Please help I really need this to work.
For Upload large size data in using phpmyadmin Do following steps.
max_execution_time = 259200 max_input_time = 259200 memory_limit = 1000M upload_max_filesize = 750M post_max_size = 750M
than after restart wamp server or restart all services Now Upload data using import function in phymyadmin. Apply second step if till not upload data.$cfg['ExecTimeLimit'] = 300;
Replace to $cfg['ExecTimeLimit'] = 0;
You can also upload large size database using MySQL Console as below.
root
in popupUSE DATABASENAME
SOURCE C:\FOLDER\database.sql
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With