l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
November 4: Social gathering
Next Installfest:
TBD
Latest News:
Oct. 24: LUGOD election season has begun!
Page last updated:
2003 Apr 30 09:50

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Need your help in recovering database.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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.

LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.