Linux Calling all wamp experts (Windows, apache, mysql & php5)

S

shirish

Level E
Hi all,
I tried to install WAMP after reading Blinded By Tech » How To: Install Wikipedia For Offline Access I was able to get 1/2 way to the point
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
Click to expand...

[p] After doing this, I stopped the server & tried to restart it but it wouldn't. Going to 127.0.0.1 gives the error :-

"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)

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

Below is the extract from C:\wamp\logs\mysql_error.log

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070208 19:37:49 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070208 19:37:53 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 19:37:53 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 19:37:54 InnoDB: Started; log sequence number 0 0
070208 19:37:54 [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 19:49:52 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown

070208 19:49:52 InnoDB: Starting shutdown...
070208 19:49:56 InnoDB: Shutdown completed; log sequence number 0 270607
070208 19:49:56 [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 19:50:17 [ERROR] Default storage engine (InnoDB) is not available
070208 19:50:17 [ERROR] Aborting

070208 19:50:17 [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 19:50:52 [ERROR] Default storage engine (InnoDB) is not available
070208 19:50:52 [ERROR] Aborting

070208 19:50:52 [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 19:51:07 [ERROR] Default storage engine (InnoDB) is not available
070208 19:51:07 [ERROR] Aborting

070208 19:51:07 [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 23:29:34 [ERROR] Default storage engine (InnoDB) is not available
070208 23:29:34 [ERROR] Aborting

070208 23:29:34 [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 23:51:41 [ERROR] Default storage engine (InnoDB) is not available
070208 23:51:41 [ERROR] Aborting

070208 23:51:41 [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!
070209 0:03:27 [ERROR] Default storage engine (InnoDB) is not available
070209 0:03:27 [ERROR] Aborting

070209 0:03:27 [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!
070209 0:04:30 [ERROR] Default storage engine (InnoDB) is not available
070209 0:04:30 [ERROR] Aborting

070209 0:04:30 [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!
070209 0:04:38 [ERROR] Default storage engine (InnoDB) is not available
070209 0:04:38 [ERROR] Aborting

070209 0:04:38 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete
Click to expand...

Thnx in advance
 
Ugh! I had quite a few problems with this b**ch of a program, except with uniserver, the stink lies within mysql, not WAMP. Find out where MySQLd.exe is located and try to start it with the command line. If you aren't sure of what command to start it then even I am not sure :|

Just look for a batch file in the wamp dir if there's one and open it in notepad, look for something similar to mysqld - start or something similar. Now start it in the command line and it should give you a closer look at the error you are getting. I myself got it running after reinstalling the stupid thing. the error i got in the command line used to be something similar along the lines of 'invalid cnf' or something.
 
Back
Top