Unable to start xampp after upgrade

[lmolenaar]

Dear support guys,

I upgraded my xampp installation using the installation (executable) method from 1.6.8 to 1.7 but now mySQL is no longer able to start.
I found a topic where someone had the exact same problem: Link

In that topic it was advice to comment out the "skip-bdb" line in the my.cnf file.
After I did this and start the mysql the following was returned:

C:\Program Files\xampp>mysql_start
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)
090226 15:57:53 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
090226 15:57:53 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
090226 15:57:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090226 15:57:53 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090226 15:57:53 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50015, now running 50130. Please use mysql_upgrad
e to fix this error.
090226 15:57:53 [ERROR] mysql.user has no `Event_priv` column at position 29
090226 15:57:53 [ERROR] Cannot open mysql.event
090226 15:57:53 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090226 15:57:53 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)

The service is not started though according to the services window.
When I press CTRL-C it is displaying:

090226 15:59:42 [Note] mysql\bin\mysqld: Normal shutdown

090226 15:59:42 [Note] mysql\bin\mysqld: Shutdown complete

Terminate batch job (Y/N)?

Please help me out as the site I host with xampp is used frequently.

Many thanks for your help.

[Wiedmann]

090226 15:57:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Stop any MySQL service.
First start MySQL with "mysql_start.bat"

Code: Select all

cd \xampp\mysql\bin
mysql_upgrade --force -u root -p -t "%TEMP%"

Stop MySQL with "mysql_stop.bat"

[lmolenaar]

That resolved my issue, many thanks for your swift reply!

I hope you could help me with the second problem I encounter
It seems PHP pages are no longer loading?
The server keeps loading the PHP file while when I try to access an image that image is displayed immediatly

Thanks in advance

[Wiedmann]

It seems PHP pages are no longer loading?

- Anything in Apaches error.log?
- The XAMPP demo pages are also not working?

[lmolenaar]

It seems the problem is not related to PHP, as the phpinfo() page is working.
I hope my mediawiki DB is still intact.

I will keep you updated, thanks for your help

[lmolenaar]

However, http://127.0.0.1/phpMyAdmin/index.php is also no longer loading...still a database error?

[Wiedmann]

However, http://127.0.0.1/phpMyAdmin/index.php is also no longer loading

3 additional things to do:
- Rename/copy "libmysql_5.1.51a.dll" to "libmysql.dll" in "\xampp\apache\bin" and "\xampp\php".
- Rename/copy "php_mysql_5.0.51a.dll" to "php_mysql.dll" in "\xampp\php\ext".
- Rename/copy "php_mysqli_5.0.51a.dll" to "php_mysqli.dll" in "\xampp\php\ext".

[lmolenaar]

That did it! Many many thanks!