Skip to content

Instantly share code, notes, and snippets.

@loe
Created February 5, 2009 20:54
Show Gist options
  • Save loe/58997 to your computer and use it in GitHub Desktop.
Save loe/58997 to your computer and use it in GitHub Desktop.
InnoDB: Error: data file ./ibdata1 is of a different size
InnoDB: 9344 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 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!
090205 12:40:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/vol/lib/mysql/mysql.sock' port: 3306 Source distribution
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment