MySQL will not start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL will not start

Postby bvoltz » 25. January 2009 01:16

After the installation, when I go to the c:\xampp directrory and run c:\xampp\mysql_start.bat I get the following: and can not get mysql to start:

Below is what is in the DOS window:

Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090124 18:10:38 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090124 18:10:38 InnoDB: Started; log sequence number 0 46409
090124 18:10:38 [Note] Event Scheduler: Loaded 0 events
090124 18:10:38 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)

Anyone have any ideas how to correct tis problem?
bvoltz
 
Posts: 7
Joined: 24. January 2009 08:00

Re: MySQL will not start

Postby Izzy » 25. January 2009 01:28

Did you do a fresh install or an upgrade?

The above console window result is saying the MySQL is started and ready for connections.

Is MySQL started or not or does it stop shortly after starting?

Your main issue looks to be with InnoDB

So a forum search for InnoDB found these results, see if any are helpful.

Also a search for mysql can't start or similar may find the answers you need.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL will not start

Postby bvoltz » 25. January 2009 02:00

Izzy wrote:Did you do a fresh install or an upgrade?

The above console window result is saying the MySQL is started and ready for connections.

Is MySQL started or not or does it stop shortly after starting?

Your main issue looks to be with InnoDB

So a forum search for InnoDB found these results, see if any are helpful.

Also a search for mysql can't start or similar may find the answers you need.


I will do a search, what has happened here, is I installed 1.7, then had to uninstall it and install 1.68, to be able to use PHP4 for oscommerce, then found out that oscommerce will support PHP5, but not all pages... so I removed 1.68, and reinstalled 1.7. I did all this into different directories, and did a restart of my computer after each install, and uninstall.

Mysql will not start, it gives me the following error in XAMPP control panel, MySQL service not started [-1], so I found that I need to run the .bat file, and that is where I get this error. I'm not able to start mysql if I leave the bat window open.
bvoltz
 
Posts: 7
Joined: 24. January 2009 08:00

Re: MySQL will not start

Postby Izzy » 25. January 2009 02:05

Did you remove the xampp folders before trying to reinstall again?

Try and follow this post to remove any services that may be a hindrance:
viewtopic.php?p=134114#p134114
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL will not start

Postby bvoltz » 25. January 2009 02:38

Nope, non of these steps helped.

In fact now I'm getting a pop error, that will not away.

"Access violation at address 1000A1F7 in module 'LIBMYSQL.dll". Read of address 00000000."

:?

How do completely remove this product, so I can reinstall it, because the uninstall is leaving something from getting deleted?
bvoltz
 
Posts: 7
Joined: 24. January 2009 08:00

Re: MySQL will not start

Postby Izzy » 25. January 2009 02:55

bvoltz wrote:"Access violation at address 1000A1F7 in module 'LIBMYSQL.dll". Read of address 00000000."

In Explorer find your Startup folder in XP it is here C:\Documents and Settings\[Logged in username]\Start Menu\Programs\Startup and remove the link to WinMySQLAdmin

Open Task Manager>Processes tab and find and End Process of the above exe file.

Reboot your PC so that the file is no longer started after a reboot.

Or search for access violation

bvoltz wrote:How do completely remove this product, so I can reinstall it, because the uninstall is leaving something from getting deleted?

Follow the above procedure in my last post to make sure all components are stopped including the XCP and all the services uninstalled.

Check in Task Manager there are no apache or mysql processes running and End Process if you find any.

No Delete your xampp folder.

Then reboot.

Check again in Task Manager for any running processes of apache or mysql.

If you find any and before installing XAMPP again post back here and we can then proceed to remove any services that may be sticking.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL will not start

Postby bvoltz » 25. January 2009 03:15

Ok this has solved a number of issue, now the only way I can start the services, is by using the .bat files in the c:\xampp only...
bvoltz
 
Posts: 7
Joined: 24. January 2009 08:00

Re: MySQL will not start

Postby Izzy » 25. January 2009 03:27

Do you really need to install the services?

Do you need to have the components start after every reboot automatically?

Are you getting confused what are services and what are starting Apache and MySQL components.

What is wrong with the Xampp Control Panel (XCP)?

When installing did you answer yes to installing the services?
Don't answer yes if you don't need to have the components start automatically after each reboot.


Try uninstalling again and this time try the EXE(7zip) version by extracting to the C: drive which will put all the files into C:\xampp folder.

Then simply run the setup_xampp.bat file in the xampp folder to have it set your paths.

Then proceed to your XCP and Start Apache and MySQL but don't tick any of the Svc boxes until or if you need to have Apache or any other components start automatically every time you boot your PC.

Then go to http://localhost select your language and test your installation by exercising all the demos listed in the menu.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL will not start

Postby bvoltz » 25. January 2009 03:39

I did not check the box when installing for the service to setup.

I know that this is not the place for support, but I'm new to this and I'm really just trying to get to the point I can play with PHP and work with oscommerce.

Many thanks for all your help.
bvoltz
 
Posts: 7
Joined: 24. January 2009 08:00

Re: MySQL will not start

Postby Izzy » 25. January 2009 03:48

bvoltz wrote:I did not check the box when installing for the service to setup.

I know that this is not the place for support, but I'm new to this and I'm really just trying to get to the point I can play with PHP and work with oscommerce.

Many thanks for all your help.
Your very welcome and yes this is the place for support for XAMPP for Windows and I do hope you feel that so far we have made progress in what is a very difficult troubleshooting processes, when all we can rely on is what you tell us about your issues as we can't possibly know unless you give as much detail as possible. :)

I am sure if we keep plugging away at this you will have osCommerce up and running and anything else you may wish to try out on your server.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 74 guests