well i´m having another problem now... I changed innodb_force_recovery for 1 and mysql is not running due the following error:
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of innodb: memory with malloc! total allocated memory innodb: by inndodb 16975556 bytes. Operating system errno: 8 innodb: Cannot continue operation! innodb: check if you should increase the swap file of ulimits innodb: of your operating system innodb: On freeBSD check you have compiled the OS with innodb:a big enough maximum process size .... got signal 11. Aborted! --- Can anyone help me with this new problem? thanks! [´z] Carlos On Tue, 23 Nov 2004 15:33:08 -0200, Carlos Augusto <[EMAIL PROTECTED]> wrote: > I appreciate your help, but now i can´t get those error logs because i > need access to this database that im not having at the moment. > As fast as i can i´ll paste the full error log for you. > Thanks for the help. > [´z] > > On Mon, 22 Nov 2004 23:09:41 +0200, Heikki Tuuri > > > <[EMAIL PROTECTED]> wrote: > > Carlos, > > > > ----- Original Message ----- > > From: "Carlos Augusto" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.myodbc > > Sent: Monday, November 22, 2004 10:37 PM > > Subject: Innodb corrpution. Very Urgent > > > > > Hello, i=B4m having a problem with a large database... > > > at ibdata1.My ibdata1 is corrupted and i saw other postings and all of > > > them asks to use mysqldump, but in my case there=B4s a problem... > > > I can=B4t run mysqld since ibdata1 is corrupted.=20 > > > Those anyone have a tip for me? > > > in logfile says that mysqld can=B4t run because this corruption. > > > When I make a new instalation of mysql whithout my 4 gb ibdata1, the > > > daemon runs ok...and when i paste my corrupted ibdata1 at /data > > > (shutting down the service) and turn on the service again, it don=B4t > > > turns on. > > > I don=B4t know what to do... > > > > please post the COMPLETE .err log of mysqld. Do not cut anything off. What > > does mysqld print when you try to start it? > > > > Which MySQL version this is, and what operating system? > > > > The following section: > > http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html > > contains instructions how you can start mysqld, even though the ibdata file > > is corrupt. > > > > > Thanks > > > Carlos > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > Foreign keys, transactions, and row level locking for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > > tables > > http://www.innodb.com/order.php > > > > Order MySQL technical support from https://order.mysql.com/ > > > > -- > > 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]
