Can't Import Large Database
Posted by: Jab (201.237.156.---)
Date: July 09, 2009 06:04PM

I have a live site online, and a local Wamp site where I develop for the live site. I export the live database and then import it into the local Wamp DB. When I do, I get this:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

I follow the FAQ link to: [localhost] where it says:
The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

My upload_max_filesize was at 2megs, so I increased it to 12, everything else is fine. I still get the warning.

Any expience with this problem and how to fix it?

Thanks,

Ben

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 09, 2009 06:46PM

You need to increase the upload_max_filesize setting in your php.ini

After making the change make sure you restart the Apache Service.

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: Jab (201.237.156.---)
Date: July 09, 2009 07:11PM

As mentioned, I have increased my upload_max_filesize setting to 12 mb.
I am trying to import a 3.7 mb file.

; Maximum allowed size for uploaded files.
upload_max_filesize = 12M

I have restarted Apache, and then all services just to make sure, and still I get the warning.

What else might it be?

Ben

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: toumimi (---.237.115-78.rev.gaoland.net)
Date: July 09, 2009 07:21PM

As said in the doc, you can also increase memory_limit and post_max_size, then restart apache...

Florian

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

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: Jab (201.237.156.---)
Date: July 10, 2009 02:04AM

Thanks for the quick responses.

I don't think that I was clear in my original post, but I have increased the size to more than necessary in:
upload_max_filesize
memory_limit
post_max_size

Still no joy.

Any thoughts on what else it might be?

Thanks again for the effort!

Ben

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 10, 2009 06:35PM

What php.ini are you editing? To esure you're edting the correct php.ini go to WAMP tray icon and select PHP > php.ini

Options: ReplyQuote
Re: Can't Import Large Database
Posted by: Jab (201.237.156.---)
Date: July 10, 2009 09:11PM

c2dan,

Good catch. I was evidently editing the wrong php.ini. I had done a local search in the php folder and edited the php.ini file there, which is apparently different than the one in the tray icon.

After restarting all services, it worked.

I appreciate it,

Ben

Options: ReplyQuote


Sorry, only registered users may post in this forum.