Not download all rows in Excel

eayvl · Post by **eayvl** » Tue May 14, 2019 7:44 am

Hi, i have more of 1,100 rows and 20 columns in my mysql database and only 997 rows are downloaded in Excel. Does anyone know why everything is not downloaded?

Thanks.

arbei · Post by **arbei** » Tue May 14, 2019 11:40 am

You may try to configure your php.ini to increase the memory limit and maximum execution time, read:
http://www.php.net/manual/en/ini.core.p ... mory-limit
http://www.php.net/manual/en/info.confi ... ution-time

eayvl · Post by **eayvl** » Tue May 14, 2019 11:38 pm

I made the following changes, but it did not work, just download 997 rows.

realpath_cache_size = 4M
memory_limit=256M
max_execution_time=0
session.cookie_httponly= 1

try the following:

report of 1,100 rows, just download 997
report of 2,500 rows, just download 997

Any idea or configuration is appreciated, Thanks.

arbei · Post by **arbei** » Wed May 15, 2019 9:29 am

Make sure you export "All pages" not "Current Page" and try to increase the memory limit (256M may not be enough).

eayvl · Post by **eayvl** » Thu May 16, 2019 6:17 am

I have configured "Selected records" but it does not work with bases of more of 1000 rows,

The solution was "All pages".

Thanks.

whynick · Post by **whynick** » Thu May 16, 2019 8:31 pm

sofar i can remember, there was something with

max_input_vars = 3000

hope this help.

eayvl · Post by **eayvl** » Thu May 16, 2019 10:02 pm

whynick wrote:

max_input_vars = 3000

Thank you I try.