List:General Discussion« Previous MessageNext Message »
From:Gerald L. Clark Date:November 2 2006 2:33pm
Subject:Re: Can't create database
View as plain text  
Mário Gamito wrote:
> 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
>
perror 28
  Error code  28:  No space left on device

You need more disk space.

-- 
Gerald L. Clark
Supplier Systems Corporation
Thread
Can't create databaseM├írio Gamito2 Nov
  • Re: Can't create databaseRolando Edwards2 Nov
  • Re: Can't create databaseGerald L. Clark2 Nov