Magento 2.3 Export – Export File Problem in Magento 2.3

FTPing or copying and pasting innodb tables from one filesystem to another isn't going to work. Try this to restore innodb tables:

[http://egil.biz/how-to-recover-mysql-data-from-innodb/][1]

Better yet, do nightly dumps of your magento database:

mysqldump -u david -h localhost -pmypassword mymagentodatabase > mymagentodatabase.sql | gzip mymagentodatabase.sql 

To restore, open up mysql on the command line:

use mymagentodatabase
source /home/david/mymagentodatabase.sql 

Restoring from the mysql command line is way faster than using a client like navicat or phpmyadmin.

In my work environment, I also have a clone of the production code base on my development machine, such as: http://dev.magentowebsite.com. When I have to, I restore the last dump to my local mysql, then go into core_config_data and change the secure and nonsecure urls to http://dev.magentowebsite.com. Then I have the live site on my local machine and can test things without breaking the live site.

Ah hah!

According to the Apache error log:

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 84 bytes) in /Zend/Db/Statement/Pdo.php on line 290

So apparently Magento needs over 256MB of memory to export customers. OK the store in question has about 20,000 customers but that still sounds like quite a lot. Plus, this even happens when I filter down to a single surname. My guess is it's not about the size of the generated file (which needn't be held in memory all at once anyway) but that Magento is doing something grossly inefficient at the processing stage (surely not!)

I increased PHP's memory_limit to 512M and problem solved.

I hope this helps some poor wretch in future...