Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-15 Thread Adarsh Sharma
Thanks Andrew , I got my schema back :-) . But Is it possible to get back all procedures that are created on these tables. Thanks once again. Andrew Moore wrote: You should be able to get the table structure again using the frm files http://www.mysqlperformanceblog.com/2008/12/17/recovering

Re: problem with INNODB tables

2012-03-15 Thread Reindl Harald
Am 15.03.2012 17:31, schrieb Malka Cymbalista: > We are running MySQL version 5.0.45 on a Linux machine. Most of our tables > are MyIASM but we have recently installed drupal 7 and drupal 7 requires > INNODB tables. Every now and then when we restart MySQL using the commands > /etc/init.d/mys

Re: Free tickets to MySQL conference

2012-03-15 Thread Baron Schwartz
Probably someday, but no plans yet. On Thu, Mar 15, 2012 at 7:37 AM, Johan De Meersman wrote: > - Original Message - >> From: "Baron Schwartz" >> >> If you want to go to this year's MySQL conference like all the cool >> kids, now's your chance. Percona is giving away free tickets (and >

Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-15 Thread Adarsh Sharma
Thanks baron , below are the contents of my error.log :- 120315 17:17:51 [Note] Plugin 'FEDERATED' is disabled. 120315 17:17:51 InnoDB: Initializing buffer pool, size = 8.0M 120315 17:17:51 InnoDB: Completed initialization of buffer pool InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on InnoDB

Re: Free tickets to MySQL conference

2012-03-15 Thread Johan De Meersman
- Original Message - > From: "Baron Schwartz" > > If you want to go to this year's MySQL conference like all the cool > kids, now's your chance. Percona is giving away free tickets (and Bit far, but please tell me there's gonna be another Percona Live in London or another bit of Europe

Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

2012-03-15 Thread Baron Schwartz
It sounds like InnoDB itself might have failed to start, but there is not enough information to know for sure. Please check the server's error log. On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma wrote: > Dear All, > > Is there any way to recover data or only schema of corrupted innodb > tables.My

Re: Free tickets to MySQL conference

2012-03-15 Thread Claudio Nanni
Gr! Too far, too busy! Good stuff! Claudio On Mar 15, 2012 2:52 AM, "Baron Schwartz" wrote: > If you want to go to this year's MySQL conference like all the cool > kids, now's your chance. Percona is giving away free tickets (and free > books)! Details here: > > http://www.mysqlperformance