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.
