List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:June 20 2013 8:33am
Subject:Re: help: innodb database cannot recover
View as plain text  

Am 20.06.2013 10:11, schrieb Peter:
> 130620 00:47:08 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> InnoDB: Error: tablespace size stored in header is 456832 pages, but
> InnoDB: the sum of data file sizes is only 262080 pages
> InnoDB: Cannot start InnoDB. The tail of the system tablespace is
> InnoDB: missing
> 
> is there a way to start the database again?
> Thanks for your help in advance

restore your backups

that is one reason why replication exists to have a slave which
a) does not die with the master at a complete crash and b) have
a machine where offline backups could be pulled from without
any downtime


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
help: innodb database cannot recoverPeter20 Jun
  • Re: help: innodb database cannot recoverReindl Harald20 Jun
  • Re: help: innodb database cannot recoverManuel Arostegui20 Jun
    • Re: help: innodb database cannot recoverPeter20 Jun
      • Re: help: innodb database cannot recoverManuel Arostegui20 Jun
        • Re: help: innodb database cannot recoverPeter20 Jun
          • Re: help: innodb database cannot recoverPeter20 Jun
            • Re: help: innodb database cannot recoverReindl Harald20 Jun
              • Re: help: innodb database cannot recoverPeter21 Jun
                • Re: help: innodb database cannot recoverJohan De Meersman21 Jun
      • Re: help: innodb database cannot recoverReindl Harald20 Jun
        • Re: help: innodb database cannot recoverPeter20 Jun
          • Re: help: innodb database cannot recoverPeter20 Jun