Hello all,
I am looking after the installation of web-based software built using
MySQL with mostly InnoDB tables. The software is currently installed in
over 10 locations and has been running continually for several months in
some of these. These installations vary from several thousand to several
hundred thousand lines in the database, with 100 tables.
Backups are made roughly daily from within the application, which uses
the php 'exec' function to directly call mysqldump.
One server had a problem while creating a backup last week. The routine
normally takes about 30 seconds, but in this case went on for over 30
minutes. During this, the application was responding correctly to other
users. After a reboot, InnoDB has been disabled, which left the data
inaccessible. The database was restored using the most recent backup,
but all tables are now using the MyISAM engine.
The server is running Windows Server 2003 and MySQL version
5.0.24a-community-nt installed using the xampp package.
The relevant sections of the MySQL log file are below, after which it
went into a near endless cycle of 'Incorrect information in file:' errors.
The errors are due to InnoDB being disabled. As far as I can tell, this
has happened as the InnoDB log file ib_logfile0 is the wrong size. This
took me to the description for adding and removing log files at:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
However, something has happened in this case to expand the file
id_logfile0 and instructions are not given on how to clean it out and
start again.
Any help on how to sort this out without a reinstall or, more
importantly, to understand why this may have happened, would be greatly
appreciated.
Best regards,
Andrew Simpson
070403 16:33:53 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Normal shutdown
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6135 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6134 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6133 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6131 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6130 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6129 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6128 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6127 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6099 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 6015 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 5929 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 5928 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 5865 user: 'wasp'
070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing
close of thread 5861 user: 'wasp'
070403 16:33:55 InnoDB: Starting shutdown...
070403 16:33:57 InnoDB: Shutdown completed; log sequence number 0 81792952
070403 16:33:57 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Shutdown
complete
InnoDB: Error: log file C:\www\xampp\mysql\data\ib_logfile0 is of
different size 0 134217728 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
070403 16:35:01 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: ready for
connections.
Version: '5.0.24a-community-nt' socket: '' port: 3306 MySQL Community
Edition (GPL)
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect
information in file: '.\wasp_ke\wasp_settings.frm'
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect
information in file: '.\wasp_ke\wasp_settings.frm'
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect
information in file: '.\wasp_ke\bugs.frm'
-----------------------------------------------------------------------------
This message has been scanned for viruses and
dangerous content by the http://www.orbital.net
MailScanner, and is believed to be clean.
-----------------------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]