MySQL Forums
Forum List  »  Newbie

My database seems to be gone ...
Posted by: Henny Sol
Date: March 15, 2012 01:57AM

Hi,

I use MySql5.0. I created a Wiki on my laptop (Windows7 Ultimate) using a MySql database.

Yesterday I found that the MySql service could not start. Message:
Windows could not start the MYSql service on the Local computer. Error 1067: the process terminated unexpectedly

Checking the logfile (LTQUINT.err) I found the following lines (the first lines are ok, I guess, then you'll see a problem with ibdata1; this problem is reported over and over again):

----------------------------------------------------------------------------
120309 9:48:59 InnoDB: Starting shutdown...
120309 9:49:08 InnoDB: Shutdown completed; log sequence number 0 166254849
120309 9:49:08 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
120309 10:00:06 [ERROR] Default storage engine (InnoDB) is not available
120309 10:00:06 [ERROR] Aborting

120309 10:00:06 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
etcetera etcetera etcetera
----------------------------------------------------------------------------

When I check the MySQL Server5.0\data directory I see:
file ib_logfile0 size 55296 kb
file ib_logfile1 size 55296 kb
file ibdata1 size 0 kb

When I check 1 level deeper (the directory of my database) I see lots of frm files but only one MYD and only one MYI file. I know very little about MySql but I guess frm will be the tabledefinition, MYD the data and MYI the index

I'm absolutely sure I inserted some pages in my wiki in februari (2012). So what went wrong?

I have a backup of the database dated august 2011 (stupid me!).

My questions are:
1. Can I do a roll forward in MySql using the logfiles after restoring my backup?
2. What went wrong? What should I do to ensure this will never happen again?

Thanks in advance for you time and attention. It will be highly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
My database seems to be gone ...
March 15, 2012 01:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.