Can t import database through phpmyadmin file size too large

Question

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

User · Answer

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 = 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.
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 root in 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.

User · Answer

to import big database into phpmyadmin there are two ways  1 increase file execution size from php ini 2 use command line to import big database

User · Answer

If you do not want to change the settings or play with command line  There is option to compress the file and upload in phpMyAdmin  It should bring down the size considerably

User · Answer

for ubuntu 14 04 use this   1- open php ini using gedit or nano          sudo gedit  etc php5 apache2 php ini 2- find  upload max size  then replace this single line with these lines          max execution time   259200         max input time   259200         memory limit   1000M         upload max filesize   750M         post max size   750M 3- save php ini and close editor 4- restart apache2         sudo service apache2 restart 5- now open localhost   phpmyadmin  in browser and uplaod your database sql

User · Answer

If you are using MySQL in Xampp then do the steps below   Find the following in XAMPP control panel Apach-Config  PHP  php ini  file   post max size   8M upload max filesize   2M  max execution time   30  ut time   60enter code here memory limit   8M   And change their sizes according to your need   I m using these values  post max size   30M upload max filesize   30M max execution time   4500 max input time   4500 memory limit   850M

User · Answer

Use command line    mysql exe -u USERNAME -p PASSWORD DATABASENAME  lt  MYDATABASE sql   where MYDATABASE sql is your sql file

User · Answer

You no need to edit php ini or any thing  I suggest best thing as Just use MySQL WorkBench    JUST FOLLOW THE STEPS   Install MySQL WorkBench 6 0  And In  Navigation panel  Left side  there is option call  Data import  under  MANAGEMENT   Click that and  follow steps below    click Import Self-Contained File and choose your SQL file Go to My Document and create folder call  dump  simple   now you ready to upload file  Click IMPORT Button on down

User · Answer

Its due to PHP that has a file size restriction for uploads    If you have terminal shell access then the above answers  Kyotoweb will work   one way to get it done is that you create an  htaccess ini file file to change PHP settings to get the sql file uploaded through PHPmyAdmin   php value upload max filesize 120M   file size php value post max size 120M php value max execution time 200 php value max input time 200   Note you should remove this file after upload

User · Answer

You have three options    Use another way to get the file on the server  and use a mysql client on the server Use another client to connect to the server and load the data Change your PHP settings to allow such huge files  Don t forget to increment the execution time as well

User · Answer

Here is what I ve done    Gone to my XAMPP installed directoy C  xampp php Open the  Configuration Settings  file named php ini using 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

User · Answer

You can also try compressing  zipping  the file   It sometimes works for me if I can t get to php ini for phpmyadmin   If zipping reduces the file size below the maximum file size  it just might work

User · Answer

Another option that nobody here has mentioned yet is to do a staggered load of the database using a tool like BigDump to work around the limit  It s a simple PHP script that loads a chunk of the database at a time before restarting itself and moving on the the next chunk

User · Answer

Set the below values in php ini file  C  xampp php     max execution time   0 max input time 259200 memory limit   1000M upload max filesize   750M post max size   750M  Open config default file C  xampp phpMyAdmin libraries config default  and set the value as below     cfg  ExecTimeLimit     0   Then open the config inc file C  xampp phpMyAdmin config inc   and paste below line     cfg  UploadDir      upload    Go to phpMyAdmin C  xampp phpMyAdmin  folder and create folder called upload and paste your database to newly created upload folder  don t need to zip  Lastly  go to phpMyAdmin and upload your db  Please select your database in drop-down       That s all baby         It takes lot of time In my db 266mb  takes 50min to upload  So be patient

[mysql] Can't import database through phpmyadmin file size too large

Examples related to mysql

Examples related to database

Examples related to apache

Examples related to phpmyadmin

Examples related to wampserver