How do I make mysql support a larger DB?
Posted by: Scottiesr1 (---.mia.bellsouth.net)
Date: July 12, 2011 05:50PM

I have a table that is 2M to import. How can I increase the size that the DB supports?


Thanks,

Susan

Re: How do I make mysql support a larger DB?
Posted by: yfastud (Moderator)
Date: July 12, 2011 10:26PM

Hi Susan, to import big db, try these settings in C:\wamp\bin\apache\apache2.2.x\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

Also add this line in file c:\wamp\apps\phpmyadmin\config.inc.php
$cfg ['ExecTimeLimit'] = 0;

Then restart wamp to take effect

Have fun,

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

Re: How do I make mysql support a larger DB?
Posted by: Scottiesr1 (---.mia.bellsouth.net)
Date: July 13, 2011 05:46PM

Thank you yfastud!! You guys are awesome!!

Re: How do I make mysql support a larger DB?
Posted by: shirishpatil (---.shashank.net)
Date: April 14, 2012 11:24AM

Set the following in ur php.ini

upload_max_filesize = 2M OR 32M

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