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
