WampServer

Hi all,
I'm a noob at this. I'm trying to install a wikipedia local repositery in my machine through instructions given at [www.blindedbytech.com] . Everything works fine till I get to the point (from site):-

Quote

You’ll need to edit MySQL’s config file to increase the max_allowed_packet size. If you don’t, the import will most likely choke around the 49,000 article mark. This is quite annoying, because it kills the rest of the import. While you’re add it, you might as well change the innodb_log_file_size, which should modestly increase the import speed. To do so, go to c:\wamp\mysql\, right-click on my.ini, and select Open. This will open up the ini file in a text editor. Find the line innodb_log_file_size, and set this to 512M (was 10M in mine). Scroll to the bottom, and add the following line:

set-variable=max_allowed_packet=32M

As far error logs this is the error report being generated & I'm not able to start mysql :-

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070208 16:44:21 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070208 16:44:22 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070208 16:44:22 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070208 16:44:23 InnoDB: Started; log sequence number 0 0
070208 16:44:24 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070208 16:51:06 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown

070208 16:51:06 InnoDB: Starting shutdown...
070208 16:51:10 InnoDB: Shutdown completed; log sequence number 0 270606
070208 16:51:10 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
070208 16:51:15 [ERROR] Default storage engine (InnoD is not available
070208 16:51:15 [ERROR] Aborting

070208 16:51:15 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

Can anybody help me into knowing what, where I'm going wrong & how to make it work? Thnx in advance



Post Edited (02-08-07 12:44)

did you edit your my.ini ( C:\wamp\mysql\mi.ini ) file as the instructions state?

make sure you edited the file correctly, make sure your innodb_log_file_size setting looks like this:

innodb_log_file_size=512M



CyberSpatium
WAMP English Forum Admin
--------------------------------------

like my free support? help support me by checking out my new Newbie Webmaster Development Forum dedicated to the newbie webmaster here:
www.WebDevNewbie.com

yup did tht the error report I gave is reproduced after tht
also did set-variable=max_allowed_packet=32M but still. I tried an un-install, shut down the comp. & again tried to set it up. The same issues come up, now when I go to 127.0.0.1 I get (MySQL not launched or bad phpmyadmin config) When I try to access my project wikipedia I get this error :-
Can't contact the database server: Can't connect to MySQL server on 'localhost' (10061) (localhost)

The error above is without the round brackets ( ) . Any Wamp experts out there?



Post Edited (02-08-07 19:05)

some more I tried even going through Start > Control Panel > Administrative Tools > Services & starting wampmysqld which is manual but getting error 1067 the process terminated unexpectadely

And if one looks at the error log then these four lines are interesting :-

InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
070208 19:50:52 [ERROR] Default storage engine (InnoD is not available
070208 19:50:52 [ERROR] Aborting


What do they mean & how do I fix it?



Post Edited (02-08-07 20:19)

try this:

when you uninstall wamp, even though you uninstall it,it still leaves some tracks behind. so, try uninstalling again, and then totally delete the c:\wamp folder. restart your computer and then install wamp again.


CyberSpatium
WAMP English Forum Admin
--------------------------------------

like my free support? help support me by checking out my new Newbie Webmaster Development Forum dedicated to the newbie webmaster here:
www.WebDevNewbie.com

How or from where should I un-install again. I do always delete the c:\wamp tolder. No issues just formatted one hard-disk so will try again



Post Edited (02-09-07 16:04)