CODEWITHSUNDEEP
phpmysqlphpmyadmin
reju
reju

Reputation: 11

Unable to import large size of data to database phpmyadmin

I'm unable to import large size of data to database phpmyadmin

m edited php.ini file for importing large amount of file. But a message showing after some time 

Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

please help me

Upvotes: 1

Views: 4975

Answers (5)

sumanchalki
sumanchalki

Reputation: 1467

Edit the file: config.inc.php inside phpmyadmin and add the following line (or edit if it exists):

$cfg['ExecTimeLimit'] = 0;

This timeout value is used at the time of import for phpmyadmin which is defined at libraries/config.default.php which is recommended to not to edit. This should solve the script timeout error.

Upvotes: 0

Gustek
Gustek

Reputation: 3760

Instead of using phpmyadmin use command line tool

open terminal and write

mysql -h host -u username -p

provide password

source /path/to/file

and no time out problem now

Upvotes: 2

jeroen
jeroen

Reputation: 91734

If your data comes from another database, you can use the database synchronization tool / tab that is available in newer versions of phpmyadmin.

That way you won't have to export and then import and you won´t run into the limit file-size limit for phpmyadmin imports.

Upvotes: 0

Spencer Hakim
Spencer Hakim

Reputation: 1553

Give this a try, it did the job for me in the past. http://www.ozerov.de/bigdump.php

Upvotes: 1

powtac
powtac

Reputation: 41050

If you want to finish import, please resubmit same file and import will resume.

Belive it or not, phpmyadmin can handle this.

Upvotes: 3

Related Questions