Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Increasing Import Limits
Posted by: charlesbw (---.hsd1.md.comcast.net)
Date: November 09, 2007 06:49PM

How can I increase import limits in phpmyadmin? So I can import relatively large databases.



[www.brainworksweb.com]

Options: Reply•Quote
Re: Increasing Import Limits
Posted by: yfastud (72.236.169.---)
Date: November 09, 2007 09:30PM

Make sure file_uploads is ON and try these different settings in c:\wamp\apache2\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\mysql\my.ini:

max_allowed_packet = 200M


Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

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