Out Of Memory error while executing mysqldump
Posted
by Nishaz Salam
on Stack Overflow
See other posts from Stack Overflow
or by Nishaz Salam
Published on 2010-04-20T12:10:46Z
Indexed on
2010/04/20
12:13 UTC
Read the original article
Hit count: 348
mysql
Hi,
I am getting the following error when trying to backup a database using mysqldump from the command prompt.
C:\Documents and Settings\bob>C:\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
© Stack Overflow or respective owner