Hi, Yes, I don't actually know if I have very large blogs, but the possibility exists, and is quite large.
I am running FreeBSD so I don't have the ulimit program, the only program I have is called limits and these are what I get when running it: [EMAIL PROTECTED] /home # limits Resource limits (current): cputime infinity secs filesize infinity kb datasize 524288 kb stacksize 65536 kb coredumpsize infinity kb memoryuse infinity kb memorylocked infinity kb maxprocesses 5446 openfiles 10893 sbsize infinity bytes vmemoryuse infinity kb [EMAIL PROTECTED] /home # I have upped my RAM in the unit with 512Mb to 768Mb, so I think I should have enough RAM now. Any other ideas? Thanks, Ian > -----Original Message----- > From: Jeremy Cole [mailto:[EMAIL PROTECTED] > Sent: 09 June 2006 05:01 PM > To: Ian Barnes > Cc: mysql@lists.mysql.com > Subject: Re: Importing 3Gb File > > Hi Ian, > > > I am trying to import a 3.2Gb sql dump file back into my sql server > (4.1.12) > > and im coming across the following error: > > > > mysql: Out of memory (Needed 178723240 bytes) > > mysql: Out of memory (Needed 178719144 bytes) > > That error message comes from some single place trying to allocate 178MB > at a single time. Do you have large BLOBs in your data? > > This error message means that mysqld is beind denied memory by the OS, > either because you are actually out of memory, or because your ulimit > has been reached (more likely). > > Check your ulimits for your system with ulimit -a, and adjust if > necessary in the mysql.server or mysqld_safe script (those both run as > root, so can adjust ulimits upwards). > > Regards, > > Jeremy > > -- > Jeremy Cole > MySQL Geek, Yahoo! Inc. > Desk: 408 349 5104 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
