Make sure that the UNIX or Linux Admins have added you to the User Group that will be writing data and making folders in the data directory of MySQL
----- Original Message ----- From: Mário Gamito <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Thursday, November 2, 2006 8:06:13 AM GMT-0500 US/Eastern Subject: Can't create database Hi, I've installed MySQL 5.0.27, but can't create databases. I get "ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)" In the log file i have this: "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!" Any ideas on how to solve this issue ? Any help would be appreciated. Best Regards, MG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
