Problem in importing database size into phpMyAdmin
Posted by: slide (---.gdj-co.client.bresnan.net)
Date: November 28, 2009 05:29AM

For over a year now I have been downloading my live site to test. Now the database is too big and can't test it because phpMyAdmin is only set to 2 Meg. How do I change the size to 5 Meg?
Thanks

Options: ReplyQuote
Re: Problem in importing database size into phpMyAdmin
Posted by: toumimi (---.107.116-78.rev.gaoland.net)
Date: November 28, 2009 07:46AM

You need to modify values in php.ini (from wamp menu -> PHP -> php.ini)
upload_max_filesize (Default 2M)
memory_limit (Default 16M)
post_max_size (Default 8M)

If its not enough, PhpMyAdmin contains a param for execution time of a php script (open config.inc.php file) :
$cfg['ExecTimeLimit'] = 300;

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: ReplyQuote
Re: Problem in importing database size into phpMyAdmin
Posted by: slide (---.gdj-co.client.bresnan.net)
Date: November 29, 2009 12:05AM

toumimi Wrote:
-------------------------------------------------------
> You need to modify values in php.ini (from wamp
> menu -> PHP -> php.ini)
> upload_max_filesize (Default 2M)
> memory_limit (Default 16M)
> post_max_size (Default 8M)
>
> If its not enough, PhpMyAdmin contains a param for
> execution time of a php script (open
> config.inc.php file) :
> $cfg['ExecTimeLimit'] = 300;

Do these self adjust?
upload_max_filesize 8M
memory_limit = 128M.
post_max_size = 15M
I put the 8M there, but did not change the others from the default.
I did nothing with the
$cfg['ExecTimeLimit'] = 300;
Do I just copy and paste that to the PhpMyAdmin config.inc somewhere? If, so where?
Thanks

Options: ReplyQuote
Re: Problem in importing database size into phpMyAdmin
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: November 29, 2009 08:08AM

yes add it into the config about 3 lines from the top


but only so this if you get a php time out error when trying again..

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 11/29/2009 08:08AM by stevenmartin99.

Options: ReplyQuote
Re: Problem in importing database size into phpMyAdmin
Posted by: slide (---.gdj-co.client.bresnan.net)
Date: November 29, 2009 02:48PM

Thank you sir.

Options: ReplyQuote


Sorry, only registered users may post in this forum.