Adminer Import Sql File Uploads but Does Not Import

13 Answers 13

Aid u.s.a. improve our answers.

Are the answers beneath sorted in a way that puts the best answer at or near the top?

For Upload large size data in using phpmyadmin Do following steps.

1. 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 At present Upload information using import function in phymyadmin. Utilize 2d pace if till not upload information.
   
2. open config.default.php file in c:\wamp\apps\phpmyadmin4.0.iv\libraries (Open this file accoring to phpmyadmin version)
   Find $cfg['ExecTimeLimit'] = 300;Replace to $cfg['ExecTimeLimit'] = 0;
   At present you lot can upload data.

Yous tin also upload large size database using MySQL Panel as beneath.

1. Click on WampServer Icon -> MySQL -> MySQL Consol
2. Enter your database password like root in popup
3. Select database proper name for insert data by writing control USE DATABASENAME
4. Then load source sql file equally SOURCE C:\Folder\database.sql
5. Press enter for insert data.

Annotation: You tin can't load a compressed database file e.k. database.sql.zip or database.sql.gz, you have to extract information technology outset. Otherwise the console will just crash.

Blackness

15.1k 31 gold badges 136 silver badges 227 bronze badges

answered Mar 12, 2014 at vi:00

himansuhimansu

1,587 12 silver badges xiv bronze badges

two

• MySQL Console saved my day!

  Oct 21, 2016 at 13:13

• +1 for mysql console. 600mb database imported in thirty seconds. Using xampp, method: cmd > cd {xampp_dir}/mysql/bin > mysql -h localhost -u root {db_name} > enter countersign then step 4 from to a higher place solution.

  Nov 20, 2020 at sixteen:00

Its due to PHP that has a file size restriction for uploads.

If y'all accept final/shell access then the above answers @Kyotoweb will work.

one mode to get it done is that y'all 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.

answered Mar 6, 2012 at 23:00

iv

• Thanks alot. Information technology worked but I more option was needed, we have to add a variable ($cfg ['ExecTimeLimit'] = 0;)which nosotros have to declare in c:\wamp\apps\phpmyadmin\config.inc.php. I am providing the links hither (john-dugan.com/?p=638)

  Mar 12, 2012 at five:12

• Or you tin edit /etc/php.ini in RedHat 6.6 using the same directives above , ever restart apache such equally: sudo service httpd restart in RedHat.

  Jul 27, 2015 at 21:18

• where this ini file should be created. Is in PHPmyAdmin folder?

  October 3, 2016 at 7:11

1. Fix 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

2. Open config.default file(C:\xampp\phpMyAdmin\libraries\config.default) and set the value as below:

   • $cfg['ExecTimeLimit'] = 0;

3. Then open the config.inc file(C:\xampp\phpMyAdmin\config.inc). and paste below line:

   • $cfg['UploadDir'] = 'upload';

4. Go to phpMyAdmin(C:\xampp\phpMyAdmin) folder and create folder chosen upload and paste your database to newly created upload folder (don't need to cipher)

5. Lastly, go to phpMyAdmin and upload your db (Please select your database in drop-down)

6. That's all babe ! :)

*Information technology takes lot of fourth dimension.In my db(266mb) takes 50min to upload. So exist patient ! *

answered Dec 11, 2017 at 3:31

AnujaAnuja

61 ane silverish badge three bronze badges

Utilise command line :

                mysql.exe -u USERNAME -p Countersign DATABASENAME < MYDATABASE.sql                              

where MYDATABASE.sql is your sql file.

answered Mar 6, 2012 at 22:48

5

• how would you do this if you only had FTP access to the server?

  Mar half-dozen, 2012 at 22:55

• @Kyotoweb There's no space betwixt the -p and Countersign on the command line (I can't edit your post because the change is only one character).

  Mar 6, 2012 at 22:58

• @ninesided He's talking well-nigh WAMP and local. Just gave him the fastest solution to his problem taking in consideration is environment.

  –user926721

  Mar 6, 2012 at 23:02

• aah I didn't spot the WAMP - the OP didn't mention local, only I estimate nearly Windows server providers allow RDP, so that may be largely irrelevant

  Mar 6, 2012 at 23:12

• When using this selection just make sure that you run the script in the folder where the .sql file is stored e.g C: \downloads>mysql.exe -u USERNAME -pPASSWORD DATABASENAME < MYDATABASE.sql

  Jan 27, 2015 at 23:06

to import big database into phpmyadmin in that location are 2 ways ane increase file execution size from php.ini 2 apply command line to import big database.

answered Oct twenty, 2016 at 10:26

Here is what I've done:

1. Gone to my XAMPP installed directoy C:\xampp\php
2. Open the "Configuration Settings" file named php.ini using your text editor, preferably you can also yous Notepad for Windows auto.
3. Somewhere nearby on line no 886, please update it to upload_max_filesize = 128M
4. Similarly on line no 735 post_max_size = 128M
5. On line no 442 max_execution_time = 300
6. On line no 452 max_input_time = 60
7. Restart your Apache from either XAMPP Command Panel or using CMD in Windows https://stackoverflow.com/a/6723485/969092

Washed!

answered Jun 6, 2013 at xi:00

ii

• Had the same problem as the OP. This solution worked for me.

  Jun 11, 2013 at 16:12

• Thanks, saw a whole bunch of other more than complicated answers and this worked great.

  Oct 18, 2017 at 11:34

If y'all are using MySQL in Xampp and so do the steps below.

Find the following in XAMPP control console>Apach-Config> PHP (php.ini) file

• post_max_size = 8M

• upload_max_filesize = 2M

• max_execution_time = xxx
• ut_time = threescoreenter 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                          

answered Apr 10, 2017 at 3:13

for ubuntu xiv.04 use this:

i- open php.ini using gedit or nano:

sudo gedit /etc/php5/apache2/php.ini

2- find 'upload_max_size' and so supercede 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

iii- save php.ini and close editor

4- restart apache2:

sudo service apache2 restart

five- now open

localhost://phpmyadmin/

in browser and uplaod your database.sql

answered Jun 9, 2016 at 10:04

HamidHamid

1,364 2 gold badges 17 silverish badges 30 bronze badges

1

• Thanks, it helped. I accept Ubuntu xviii.04 and for me path to php.ini was /etc/php/seven.2/apache2/php.ini

  May 29, 2019 at 8:55

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

answered Mar 6, 2012 at 22:54

ninesidedninesided

22.8k 14 gold badges 81 silver badges 106 bronze badges

If you do not desire to change the settings or play with command line. There is pick to compress the file and upload in phpMyAdmin. It should bring downward the size considerably.

answered Jan 14, 2021 at ane:54

You no need to edit php.ini or whatsoever thing. I suggest best thing as Only use MySQL WorkBench.

JUST FOLLOW THE STEPS.

Install MySQL WorkBench 6.0

And In "Navigation panel"(Left side) at that place is option call 'Data import' under "Direction". Click that and [follow steps below]

1. click Import Cocky-Contained File and cull your SQL file
2. Go to My Document and create binder call "dump"[uncomplicated].
3. at present you gear up to upload file. Click IMPORT Button on downwards.

Stedy

7,017 14 gold badges 54 silvery badges 73 bronze badges

answered Mar 9, 2015 at four:19

Abdulla NilamAbdulla Nilam

31.6k 15 gold badges 58 silvery badges 79 bronze badges

Yous can too try compressing (zipping) the file. It sometimes works for me if I can't go to php.ini for phpmyadmin. If zipping reduces the file size beneath the maximum file size, information technology only might work!

answered Jan 28, 2017 at 14:36

Y'all have iii options:

• Employ another way to become the file on the server, and use a mysql client on the server
• Use some other 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 equally well.

answered Mar vi, 2012 at 22:fifty

KonerakKonerak

38.1k 12 aureate badges 94 silver badges 116 bronze badges

Not the respond you're looking for? Browse other questions tagged mysql database apache phpmyadmin wampserver or enquire your own question.

lucasriney1966.blogspot.com

Source: https://stackoverflow.com/questions/9593128/cant-import-database-through-phpmyadmin-file-size-too-large

Share this post