[vox-tech] Need your help in recovering database.

Wed, 30 Apr 2003 05:58:20 -0700 (PDT)

--0-43626370-1051707500=:61814
Content-Type: text/plain; charset=us-ascii

Thanks Jeff, 

My database as well as mysqld started working. But I am not sure how did it start working. What I did is I moved the ibdata1 and other log files from /var/lib/mysql to some other place. and then I put it back. After this it started working, I can get all the datas now. I am not sure where was the error. The file size (ibdata1) is still more than 2GB, could you please tell me how did I get back the data, and how it is running now.

I am putting the tail portion of the mysqld file for your considerations here bellow:

030512 20:07:26 mysqld started

InnoDB: syntax error in innodb_data_file_path

030512 20:07:28 Can't init databases

030512 20:07:28 mysqld ended

030512 23:13:36 mysqld started

InnoDB: Error: data file ./ibdata1 is of a different size

InnoDB: than specified in the .cnf file!

030512 23:13:42 InnoDB: Database was not shut down normally.

InnoDB: Starting recovery from log files...

InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 3373783761

InnoDB: Doing recovery: scanned up to log sequence number 0 3373783761

030512 23:13:44 InnoDB: Flushing modified pages from the buffer pool...

030512 23:13:45 InnoDB: Started

/usr/local/mysql/bin/mysqld: ready for connections

030512 23:17:53 /usr/local/mysql/bin/mysqld: Normal shutdown

030512 23:17:53 InnoDB: Starting shutdown...

030512 23:17:54 mysqld started

InnoDB: Error: data file ./ibdata1 is of a different size

InnoDB: than specified in the .cnf file!

030512 23:18:11 InnoDB: Shutdown completed

030512 23:18:11 /usr/local/mysql/bin/mysqld: Shutdown Complete

030512 23:18:13 InnoDB: Started

Number of processes running now: 0

030512 23:18:16 mysqld restarted

/usr/local/mysql/bin/mysqld: ready for connections

030512 23:18:17 Can't start server: Bind on TCP/IP port: Address already in use

030512 23:18:17 Do you already have another mysqld server running on port: 3306 ?

030512 23:18:17 Aborting

030512 23:18:17 /usr/local/mysql/bin/mysqld: Shutdown Complete

030512 23:18:17 mysqld ended

030512 23:19:35 mysqld started

030512 23:19:35 Can't start server: Bind on TCP/IP port: Address already in use

030512 23:19:35 Do you already have another mysqld server running on port: 3306 ?

030512 23:19:35 Aborting

030512 23:19:35 /usr/local/mysql/bin/mysqld: Shutdown Complete

030512 23:19:35 mysqld ended

030512 23:26:51 /usr/local/mysql/bin/mysqld: Normal shutdown

030512 23:26:51 InnoDB: Starting shutdown...

030512 23:26:53 InnoDB: Shutdown completed

030512 23:26:53 /usr/local/mysql/bin/mysqld: Shutdown Complete

030512 23:26:53 mysqld ended

030513 04:58:14 mysqld started

InnoDB: syntax error in innodb_data_file_path

030513 4:58:16 Can't init databases

030513 04:58:16 mysqld ended

030513 05:00:07 mysqld started

InnoDB: Error: data file ./ibdata1 is of a different size

InnoDB: than specified in the .cnf file!

030513 5:00:30 InnoDB: Started

/usr/local/mysql/bin/mysqld: ready for connections

030513 11:54:06 /usr/local/mysql/bin/mysqld: Normal shutdown

030513 11:54:07 InnoDB: Starting shutdown...

030513 11:54:08 InnoDB: Shutdown completed

030513 11:54:08 /usr/local/mysql/bin/mysqld: Shutdown Complete

030513 11:54:10 mysqld ended

030514 07:45:54 mysqld started

InnoDB: syntax error in innodb_data_file_path

030514 7:45:55 Can't init databases

030514 07:45:55 mysqld ended

030514 17:41:08 mysqld started

InnoDB: syntax error in innodb_data_file_path

030514 17:41:09 Can't init databases

030514 17:41:09 mysqld ended

030514 17:45:41 mysqld started

InnoDB: Error: data file ./ibdata1 is of a different size

InnoDB: than specified in the .cnf file!

030514 17:45:55 InnoDB: Started

/usr/local/mysql/bin/mysqld: ready for connections

-----------------------------------------------------------

I am highly grateful to you for your kind cooperations and suggestions. 

With best of my regards, 
Soumyadeep

---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
--0-43626370-1051707500=:61814
Content-Type: text/html; charset=us-ascii

<DIV>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<P>Thanks Jeff, </P><FONT size=2>
<P>My database as well as mysqld started working. But I am not sure how did it start working. What I did is I moved the ibdata1 and other log files from /var/lib/mysql to some other place. and then I put it back. After this it started working, I can get all the datas now. I am not sure where was the error. The file size (ibdata1) is still more than 2GB, could you please tell me how did I get back the data, and how it is running now.</P>
<P>I am putting the tail portion of the mysqld file for your considerations here bellow:</P>
<P>030512 20:07:26 mysqld started</P>
<P>InnoDB: syntax error in innodb_data_file_path</P>
<P>030512 20:07:28 Can't init databases</P>
<P>030512 20:07:28 mysqld ended</P>
<P>030512 23:13:36 mysqld started</P>
<P>InnoDB: Error: data file ./ibdata1 is of a different size</P>
<P>InnoDB: than specified in the .cnf file!</P>
<P>030512 23:13:42 InnoDB: Database was not shut down normally.</P>
<P>InnoDB: Starting recovery from log files...</P>
<P>InnoDB: Starting log scan based on checkpoint at</P>
<P>InnoDB: log sequence number 0 3373783761</P>
<P>InnoDB: Doing recovery: scanned up to log sequence number 0 3373783761</P>
<P>030512 23:13:44 InnoDB: Flushing modified pages from the buffer pool...</P>
<P>030512 23:13:45 InnoDB: Started</P>
<P>/usr/local/mysql/bin/mysqld: ready for connections</P>
<P>030512 23:17:53 /usr/local/mysql/bin/mysqld: Normal shutdown</P>
<P>030512 23:17:53 InnoDB: Starting shutdown...</P>
<P>030512 23:17:54 mysqld started</P>
<P>InnoDB: Error: data file ./ibdata1 is of a different size</P>
<P>InnoDB: than specified in the .cnf file!</P>
<P>030512 23:18:11 InnoDB: Shutdown completed</P>
<P>030512 23:18:11 /usr/local/mysql/bin/mysqld: Shutdown Complete</P>
<P>030512 23:18:13 InnoDB: Started</P>
<P>Number of processes running now: 0</P>
<P>030512 23:18:16 mysqld restarted</P>
<P>/usr/local/mysql/bin/mysqld: ready for connections</P>
<P>030512 23:18:17 Can't start server: Bind on TCP/IP port: Address already in use</P>
<P>030512 23:18:17 Do you already have another mysqld server running on port: 3306 ?</P>
<P>030512 23:18:17 Aborting</P>
<P>030512 23:18:17 /usr/local/mysql/bin/mysqld: Shutdown Complete</P>
<P>030512 23:18:17 mysqld ended</P>
<P>030512 23:19:35 mysqld started</P>
<P>030512 23:19:35 Can't start server: Bind on TCP/IP port: Address already in use</P>
<P>030512 23:19:35 Do you already have another mysqld server running on port: 3306 ?</P>
<P>030512 23:19:35 Aborting</P>
<P>030512 23:19:35 /usr/local/mysql/bin/mysqld: Shutdown Complete<BR></P>
<P>030512 23:19:35 mysqld ended</P>
<P>030512 23:26:51 /usr/local/mysql/bin/mysqld: Normal shutdown</P>
<P>030512 23:26:51 InnoDB: Starting shutdown...</P>
<P>030512 23:26:53 InnoDB: Shutdown completed</P>
<P>030512 23:26:53 /usr/local/mysql/bin/mysqld: Shutdown Complete</P>
<P>030512 23:26:53 mysqld ended</P>
<P>030513 04:58:14 mysqld started</P>
<P>InnoDB: syntax error in innodb_data_file_path</P>
<P>030513 4:58:16 Can't init databases</P>
<P>030513 04:58:16 mysqld ended</P>
<P>030513 05:00:07 mysqld started</P>
<P>InnoDB: Error: data file ./ibdata1 is of a different size</P>
<P>InnoDB: than specified in the .cnf file!</P>
<P>030513 5:00:30 InnoDB: Started</P>
<P>/usr/local/mysql/bin/mysqld: ready for connections</P>
<P>030513 11:54:06 /usr/local/mysql/bin/mysqld: Normal shutdown</P>
<P>030513 11:54:07 InnoDB: Starting shutdown...</P>
<P>030513 11:54:08 InnoDB: Shutdown completed</P>
<P>030513 11:54:08 /usr/local/mysql/bin/mysqld: Shutdown Complete</P>
<P>030513 11:54:10 mysqld ended</P>
<P>030514 07:45:54 mysqld started</P>
<P>InnoDB: syntax error in innodb_data_file_path</P>
<P>030514 7:45:55 Can't init databases</P>
<P>030514 07:45:55 mysqld ended</P>
<P>030514 17:41:08 mysqld started</P>
<P>InnoDB: syntax error in innodb_data_file_path</P>
<P>030514 17:41:09 Can't init databases</P>
<P>030514 17:41:09 mysqld ended</P>
<P>030514 17:45:41 mysqld started</P>
<P>InnoDB: Error: data file ./ibdata1 is of a different size</P>
<P>InnoDB: than specified in the .cnf file!</P>
<P>030514 17:45:55 InnoDB: Started</P>
<P>/usr/local/mysql/bin/mysqld: ready for connections</P>
<P>-----------------------------------------------------------<BR><BR></FONT>I&nbsp;am highly grateful to you for your kind cooperations and suggestions. </P>
<P>With&nbsp;best of my regards, <BR>Soumyadeep</P></BLOCKQUOTE></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New Yahoo! Search</a> - Faster. Easier. Bingo.
--0-43626370-1051707500=:61814--