Apache Friends Support Forum

hello,

i am trying to import a large SQL file - 450mb. i turned up the upload_max_filesize, memory_limit and post_max_size settings, restarted apache, and still am encountering error. is this because my XAMP is 3.2.2?

i will happily update but wanted to make sure and ask the best way to update - i have had some traumatic experiences in the past including losing data in WAMP, doing upgrades / updates / moving stuff (i am sure i may have made mistakes then, but regardless, i am wary.) and want to make sure before i try anything!

thanks!

ben

bluedimensional wrote:and still am encountering error. is this because my XAMP is 3.2.2?

Which error?

And 3.2.2 is not a valid release no. of Xampp (its the version number of the Xampp Controldialog). The Xampp version is the same as the PHP version since a couple of years. You will also see the version number in the filename of the installer. But first of all we need to know the fully qualified error message.

thank you for the reply - i ended up finding my php.ini, adjusting the post size and max upload size, and got past where i was.

now, it is successfully beginning the import process of my 400mb SQL file, and then it stops, complaining:
" Script timeout passed, if you want to finish import, please resubmit the same file and import will resume."

So i resume, and get the same message. I have repeated about 8 times now, so i am wondering if there is a better way or something else to tweak to allow this to import? or is this the best way?

For large databases, it is best to import from the command line interface.

Thank you! I will try that.