Out Of Memory error while executing mysqldump
- by Nishaz Salam
Hi,
I am getting the following error when trying to backup a database using mysqldump from the command prompt.
C:\Documents and Settings\bobC:\Adobe\LiveCycle8.2\mysql\bin\mysqldump --quick
--add-locks --lock-tables -c --default-character-set=utf8 --skip-opt -pxxxx -u
adobe -r C:\Adobe\LiveCycle8.2\configurationManager\working\upgrade\mysql\adobe.
sql -B adobe --port=3306 --host=localhost
mysqldump: Out of memory (Needed 10380928 bytes)
mysqldump: Got error: 2008: MySQL client ran out of memory when retrieving data
from server
As you can see i am using the --quick and --skip-opt too; cannot figure out what is causing the issue.
The server log has the following messages
100420 15:16:39 InnoDB: Error: cannot allocate 4814100 bytes of memory for
InnoDB: a BLOB with malloc! Total allocated memory
InnoDB: by InnoDB 33427880 bytes. Operating system errno: 2
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
100420 15:16:40 InnoDB: Warning: could not allocate 3814100 + 1000000 bytes to retrieve
InnoDB: a big column. Table name adobe/tb_form_data
Any help on this regard is highly appreciated
P.S: The backup works fine without any issues when i use the MYSQL Administrator, but since an external app( adobe livecycle installer) uses the above command to backup the database during install, i need to get this working.
Thanks,
Nishaz Salam