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.
These are my system details Microsoft Windows Server 2003, Enterprise Edition SP2 Intel Pentium 4, 2.80GHZ , 1.99 GB RAM. When i run the backup using the MYSQL Administrator i get a 11gb backup file
Thanks, Nishaz Salam