Sync module db memory issue

Gumster

I've just tried using the Fuel Sync module for the 1st time, and I've run into this issue immediately:
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 81 bytes) in \fuel\codeigniter\database\drivers\mysql\mysql_result.php on line 153

This is on my local server with a generous 512mb allowance in php. Admittedly there are some substantial tables in the target db (one at 45k rows), but even when these are omitted using the ignore array, the same error occurs. If I try mysqli, the same error results.

If I only check "assets" when syncing, then there is no error, but nothing appears to happen.

I'm not sure if my expectations are too high? What are the conditions that this module might work well? Eg typical assets transfer, db size?

admin

It really depends on the servers setting and the size of the database and what it's setup to handle. It sounds like it may be choking on the database backup part due to the size of your database and the memory allocated on the server. The code used for that is the DBUtil::backup method in the fuel/modules/sync/libraries/Fuel_sync::local_data() method
http://www.codeigniter.com/user_guide/database/utilities.html?highlight=backup#CI_DB_utility::backup