RE: Innodb can't start

[Gavin Towey]

Once you get innodb corruption like this, you generally have to try to dump all 
your data, shutdown mysql, wipe out all innodb tables and files, then restart 
mysql  reimport:

It gives the link http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html, 
to help explain how to start innodb and get your data out.

Regards,
Gavin Towey

-Original Message-
From: Julien Jabouin [mailto:chatlumo@gmail.com]
Sent: Sunday, October 31, 2010 5:27 AM
To: mysql@lists.mysql.com
Subject: Innodb can't start

Hello,

I have a database with tables in innodb and from today database can't be start.

I don't know what to do, if your can help, this my mysql log error :

Oct 31 13:18:16 myserver mysqld[13681]: 101031 13:18:16 [Note]
/usr/sbin/mysqld: Normal shutdown
Oct 31 13:18:16 myserver mysqld[13681]:
Oct 31 13:18:16 myserver mysqld[13681]: 101031 13:18:16  InnoDB:
Starting shutdown...
Oct 31 13:18:18 myserver mysqld[13681]: 101031 13:18:18  InnoDB:
Shutdown completed; log sequence number 6 2573408134
Oct 31 13:18:18 myserver mysqld[13681]: 101031 13:18:18 [Note]
/usr/sbin/mysqld: Shutdown complete
Oct 31 13:18:18 myserver mysqld[13681]:
Oct 31 13:18:18 myserver mysqld_safe[14191]: ended
Oct 31 13:18:19 myserver mysqld_safe[14258]: started
Oct 31 13:18:19 myserver mysqld[14261]: 101031 13:18:19  InnoDB:
Started; log sequence number 6 2573408134
Oct 31 13:18:19 myserver mysqld[14261]: 101031 13:18:19 [Note]
/usr/sbin/mysqld: ready for connections.
Oct 31 13:18:19 myserver mysqld[14261]: Version: '5.0.51a-24+lenny3'
socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14295]: Upgrading
MySQL tables if necessary.
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14300]: Looking for
'mysql' in: /usr/bin/mysql
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14300]: Looking for
'mysqlcheck' in: /usr/bin/mysqlcheck
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14300]: This
installation of MySQL is already upgraded to 5.0.51a, use --force if
you still need to run mysql_upgrade
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14307]: Checking for
insecure root accounts.
Oct 31 13:18:20 myserver /etc/mysql/debian-start[14311]: Triggering
myisam-recover for all MyISAM tables
Oct 31 13:18:22 myserver mysqld[14261]: InnoDB: Database page
corruption on disk or a failed
Oct 31 13:18:22 myserver mysqld[14261]: InnoDB: file read of page 178137.
Oct 31 13:18:22 myserver mysqld[14261]: InnoDB: You may have to
recover from a backup.
Oct 31 13:18:22 myserver mysqld[14261]: 101031 13:18:22  InnoDB: Page
dump in ascii and hex (16384 bytes):
Oct 31 13:18:22 myserver mysqld[14261]:  len 16384; hex
4eafb5eb0002b7d900061aaac14145bf000200ba800500aa00020002000303b0f391000179fbc3213332c3213272010002001b696e66696d756d0004000b73757072656d756d0010001100168000124367e422b00026000265530019001680001245cdc328ce1ead000265540021ffc680001247f7abe58f3de20006329
...
...
...
Oct 31 13:18:22 myserver mysqld[14261]:
000

Oct 31 13:18:22 myserver mysqld[14261]:
007000632e150a1b1aaac141; asc N
  AE   y!32
   !2r infimum  supremum Cg   eS E  (
   eT  

Re: Dev Environment

[Phillip Baker]

Greetings Michael,

Thanks for the info.
I am on a Linux box running Ubuntu.

Blessed Be

Phillip

Never ascribe to malice what can be explained by incompetence
-- Hanlon's Razor


On Thu, Oct 28, 2010 at 1:55 PM, Michael Dykman mdyk...@gmail.com wrote:

 Phillip,

 give us a starting point: what OS do you plan to use? For windows,
 there are monolithic LAMP installs in one big .msi file that I am told
 works fairly well.

 Under various linux disto's, it is usually a matter of installing a
 set of packages via yum or apt-get..  which ones will depend on your
 distro.

  - michael dykman

 On Thu, Oct 28, 2010 at 3:21 PM, Phillip Baker phil...@freewolf.net
 wrote:
  Greetings All,
 
  I am in a new shop and we are redesigning the web site.
  For development I am setting up a
  Development/Staging/Production environment.
  I just realized yesterday that I have never been involved in setting that
 up
  from a database end, only the php coding end for webpages.
 
  What are my options for setting up a D/S/P environment with the MySQL
  database that will be used by us for the site.
  Any suggestions would be helpful.
  Thanks.
 
  Blessed Be
 
  Phillip
 
  Never ascribe to malice what can be explained by incompetence
  -- Hanlon's Razor
 



 --
  - michael dykman
  - mdyk...@gmail.com

  May the Source be with you.