Unix Technical Forum

Troubles starting MySQL

This is a discussion on Troubles starting MySQL within the MySQL General forum forums, part of the MySQL category; --> Hi, I'm having a hard time starting MySQL 4.1.21 I get: "Starting mysqld daemon with databases from /usr/local/mysql-4.1.21/var STOPPING ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 05:08 AM
=?ISO-8859-1?Q?M=E1rio_Gamito?=
 
Posts: n/a
Default Troubles starting MySQL

Hi,

I'm having a hard time starting MySQL 4.1.21

I get:
"Starting mysqld daemon with databases from /usr/local/mysql-4.1.21/var
STOPPING server from pid file /tmp/mysql.pid
061102 14:06:13 mysqld ended"

In the logs, i have:
"061102 14:07:25 mysqld started
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!
061102 14:07:25 [ERROR] Can't init databases
061102 14:07:25 [ERROR] Aborting"

Now, if i add the line
innodb_data_file_path = /usr/local/mysql-4.1.21/var/ibdata1:100M:autoextend

i get:
"061102 14:08:25 mysqld started
061102 14:08:25 InnoDB: Operating system error number 2 in a file
operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: File name .//usr/local/mysql-4.1.21/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
061102 14:08:25 mysqld ended"

What's going on here ?
This never happened to me in years.

What is teh problem and how to solve it ?

Thanks in advance.

Mário Gamito

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:00 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com