Paul,
- Original Message -
From: "Paul W" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 25, 2004 11:33 AM
Subject: Cloned machine mysql startup problem with innodb
For backup purposes I have what amounts
to a complete clone of a live server.
During the process of copying
everything, the MySQL data was copied
over in its entirety. My problem is that
the mysqld won't start now on this
second machine. I don't need the
databases to be preserved here (intend
to rebuild them later then dump data
into them). Therefore I can delete the
database files themselves and start
again if need be, but I'm not sure what
would be a correct way to do this with
the innodb error shown below. Somebody
know if it's safe to delete most things
from /var/lib/mysql? Could I just delete
libdata1?
As to the line saying I should edit
innodb_data_file_path back to what it
was - I have no idea what it was :-(
I'm after the simplest way to get it
started, the rest is easy.
from the startup errors:
InnoDB: Error: data file
/var/lib/mysql/ibdata1 is of a different
size
InnoDB: 6656 pages (rounded down to MB)
InnoDB: than specified in the .cnf file
128000 pages!
the error means that your my.cnf does not match to the ibdata1 file size. In
my.cnf you have specified ibdata1 to be 2000 MB, but the actual size of
ibdata1 is only 104 MB.
Obviously, you have not 'cloned' the server properly. Besides my.cnf and the
database directories under the datadir of MySQL, you must copy also ibdata
files an ib_logfiles in order to copy the InnoDB tablespace as is.
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!
041019 13:05:25 Can't init databases
041019 13:05:25 Aborting
TIA,
Paul W
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
