Solution:1
Then you should consider a Database transfer/backup 🙂
It’s the wiser, safer, faster choice for large sites.
PS: For a tool that does this easily, google ‘Navicat’.
Might work with the MySQL Workbench too, but I don’t use it.
Solution:2
WordPress has it’s own default value for the maximum memory usage and it sets it admin.php with an ini_set call.
See here WordPress 3.5.2 /wp-admin/admin.php:109
@ini_set( 'memory_limit', apply_filters( 'admin_memory_limit', WP_MAX_MEMORY_LIMIT ) );
To fix the problem, you’ll need to adjust the value. I set mine to an arbitrarily high number to quickly get the export
@ini_set( 'memory_limit', apply_filters( 'admin_memory_limit', '4096M' ) );
A value of “-1” should make that memory limit uncapped completely.