Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Change maximum file import size
Posted by: Harshadewa (124.43.57.---)
Date: December 15, 2007 04:44PM

Hi,

Can anyone tell me is there any way to change the max file import size (= 2,048 Kicool smiley in phpMyAdmin? Step-by-step help would be greatly appreciated because I'm new to this field.

Harshadewa

Options: Reply•Quote
Re: Change maximum file import size
Posted by: yfastud (Moderator)
Date: December 15, 2007 06:00PM

In php.ini, this is the one:

upload_max_filesize

However, change only this line won't help you to restore big db, so you have to setup some other factors as well

Try these different settings in C:\wamp\bin\apache\apache2.2.6\bin\php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

And add this to C:\wamp\bin\mysql\mysql5.0.45\my.ini:

max_allowed_packet = 200M

Then restart wamp

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Change maximum file import size
Posted by: Harshadewa (124.43.42.---)
Date: December 16, 2007 03:25AM

Regarding:

memory_limit = 8M
to
memory_limit = 1000M

Problem: I have 512 MB RAM. I hope changing this memory_limit to 1000 won't be a problem.

_________________________________________________________________________________________

Regarding:

max_allowed_packet = 200M
in
C:\wamp\bin\mysql\mysql5.0.45\my.ini:

I can't find anything named max_allowed_packet.


I'm using the latest version of WAMP:

WampServer 2.0 [11/21/2007]
Includes :
- Apache 2.2.6
- MySQL 5.0.45
- PHP 5.2.5

At last but not least I must thankful to you very much for your quick reply. Really appreciate that.

Thanks.

Harshadewa.

Options: Reply•Quote
Re: Change maximum file import size
Posted by: yfastud (Moderator)
Date: December 17, 2007 03:02AM

Quote

Regarding:

memory_limit = 8M
to
memory_limit = 1000M

Problem: I have 512 MB RAM. I hope changing this memory_limit to 1000 won't be a problem.
Quote

Oh!!! So you have double the memory I have in my backup system which is pentium 3 and 256mb that I picked up from the garbage, and I still use that setup w/o any problem since it use the space in your hard drive, not on your memory stick

Quote

Regarding:

max_allowed_packet = 200M
in
C:\wamp\bin\mysql\mysql5.0.45\my.ini:

I can't find anything named max_allowed_packet.

Quote

And add this to C:\wamp\bin\mysql\mysql5.0.45\my.ini:

max_allowed_packet = 200M

Since it's not there, that's why I stated "ADD THIS LINE"

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Change maximum file import size
Posted by: Harshadewa (124.43.48.---)
Date: December 17, 2007 06:05AM

Oh thanks mate.

But to which position I add this:

max_allowed_packet = 200M

After or before where. (tell me the location as in MOD Packages)

THanks.

Harshadewa



Edited 1 time(s). Last edit at 12/17/2007 06:08AM by Harshadewa.

Options: Reply•Quote
Re: Change maximum file import size
Posted by: yfastud (Moderator)
Date: December 17, 2007 01:33PM

Any where is fine, normally I've added in the end so I know what I've added

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: Change maximum file import size
Posted by: Harshadewa (124.43.59.---)
Date: December 17, 2007 04:18PM

OK Thanks.

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login