Import a 1.7MB Excel file in phpMyadmin

[kamal213]

Hi Guys,

 

I'm try to import a 1.7MB excel file in phpmyadmin but to no avail as it exceeds the max limit. I also have tried converting it to an CSV file but it says my field names are too long.

 

Is there a way I increase the limit size in phpmyadmin to help me or any other ideas or am I just pretty much doomed?

 

Thanks.

[kamal213]

Apologies I forgot to add that am using a xampp server as well.

 

Thanks for you help

[Muddy_Funster]

I am not aware of any file size restrictions on PHPMyAdmin for imports.  What's the error you're getting?

[kamal213]

Thanks for your reply.

 

Heres the error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 69 bytes) in C:\xampp\phpMyAdmin\libraries\PHPExcel\PHPExcel\Worksheet.php on line 983 

[Muddy_Funster]

ok, that error relates to 256MB of memory space, so it's likely a buffer issue.  I don't know what it would be using anything like that for a 1.7MB file insert though.

 

Check you buffer size settings in your php.ini file and see if thjere is anything in there, be carefull though, you could bugger performance if you set them to crazy sizes.

[kamal213]

Kool I'll give it a go - fingers crossed it works

 

Thanks

[The Little Guy]

you don't change max size through phpmyadmin, it is done in your ini file, you need to change your php ini file to allow for larger imports, and you will need to change the php max memory in there too.

 

Once you save your ini file, shut down Apache and start it back up, your settings should not take affect.