Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem while starting Mysql server

Praveen Lawrence
Esteemed Contributor

Problem while starting Mysql server

I have moved the data directory of mysql from one one directory to other. Now I was not able to start the server. It is showing the following error message:

InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 64 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!
060422 9:15:46 Can't init databases
060422 9:15:46 Aborting

060422 9:15:46 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
060422 9:15:46 mysqld: Shutdown Complete

Please help me in resolving the same
அகர முதல எழுத்தெல்லாம் ஆதி பகவன் முதற்றே உலகு.
4 REPLIES
Stuart Browne
Honored Contributor

Re: Problem while starting Mysql server

Did you do anything that it said ? Did you modify your '/etc/my.cnf' at all?

Did you modify the permissions on '/var/lib/mysql', or whatever 'innodb_data_file_path' is set to?

Verify that the owner of this directory is the same as what your MySQL server is running as. As it says, don't delete the old/original data files.

If in doubt, take a backup first.
One long-haired git at your service...
Steven E. Protter
Exalted Contributor

Re: Problem while starting Mysql server

Shalom PRavenn,

You have probable corruption of a mysql database, or the mysql user no longer owns the database files.

Check permissions and latest backup because you may need to restore from it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Praveen Lawrence
Esteemed Contributor

Re: Problem while starting Mysql server

Dear All,

There were three log files that were missing, once I replaced them the problem got solved.

Regards,
Palani Kumar
அகர முதல எழுத்தெல்லாம் ஆதி பகவன் முதற்றே உலகு.
Praveen Lawrence
Esteemed Contributor

Re: Problem while starting Mysql server

Dear All,

There were three log files that were missing, once I replaced them the problem got solved.

Regards,
Palani Kumar
அகர முதல எழுத்தெல்லாம் ஆதி பகவன் முதற்றே உலகு.