Hi,
J Trahair wrote:
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
re-formatted.
I am trying to install MySQL using the same installation files and method as before.
MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed
OK.
However, I cannot complete the MySQL Server Instance Configuration Wizard
1.0.8. After removing the previous attempt, I choose:
Detailed configuration
Developer machine
Transactional Database Only
Decision Support
Tick Enable TCP/IP Port number 3306 and tick Enable Strict Mode
Standard Character Set
Tick Install As Windows Service
Tick Bin Directory...
Service Name: MySQL
New root password entered correctly twice
Not tick Create Anonymous
When I execute, it ticks the Prepare and the Write items, puts a red x in Start
service then says 'Could not start the service MySQL. Error: 0.
The error log says:
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 18874368 bytes!
070505 15:28:54 [ERROR] Default storage engine (InnoDB) is not available
070505 15:28:54 [ERROR] Aborting
The error message about the size is the place to look deeper. If you already
have existing InnoDB data or log files, and they don't match the InnoDB
configuration, InnoDB will complain and refuse to start.
I can't tell for sure, but it sounds like you are trying to keep your existing
data from before the crash. If not -- if you want to start with an empty
database -- ignore the following paragraphs, and just delete your InnoDB data
and log files, and then try restarting; InnoDB will create new ones of the right
size of it doesn't find any existing ones.
Otherwise, if you are trying to recover data, I suggest reading the section in
the MySQL manual about InnoDB, especially the parts about configuration and
recovery/troubleshooting. (But browse the table of contents for these sections,
as there is a lot of material there; otherwise you might go down a rabbit hole
of unrelated material and never finish!)
You will probably have to get your hands dirty with the InnoDB configuration
files.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
