Migration between IIS & Apache failing.

Note: Existing Install > Install being Upgraded (Via Advanced as moving servers)

Web Server: IIS 6 > Apache 2.26
PHP: 5.20 > 5.24
Operating System: Windows Server Std 2003 SP2 > Mac OS Server 10.5.2
MySQL version: 5.0.22 > 5.0.45
MODx Version: 0.9.6 rev 2767 > 0.9.6.1 (Downloaded today)

Browser/Client: Internet Explorer 7 > Safari 3.1.1
Operating System and version: Windows XP SP3 > Mac OS 10.5.3 & Mac OS Server 10.5.2 (Attempted on both Host via Localhost, and remote machine)

Notes:
Latest version downloaded and extracted.
PHPMyAdmin downloaded and installed/configured on both servers from same source.
Database Exported - modx-personal
Database Imported - modx-personal
Files for additional snippets, templates and contents of assets/(images/media/flash/files) migrated into new install.
Clean install check - several permissions errors - relating to the above path - resolved using 777
Database Ok, all Prevalidation checks successful.

Migrate config.inc.php to folder, unlock and reset permissions to 777
Enter in modx-personal as the database, it picked up latin1 as the collation type and the prefix of modx_
Entered in new database authentication details and continued through to pre-validation after checking for a successful connection to the database.

Fails Pre-Validation

Creating connection to the database: OK!

Database could not be selected!
Please check the database permissions for the specified user and try again.

Checking table prefix `modx_`: Failed! - Table prefix does not exist in this database!


Tried various prefixes, and even connecting to the database as mysql root - with no effect. Attempted these steps on both Server and Mac Client.

Attached is a copy of the config file, with username/passwords altered.

Any Ideas?

As it says:

Database could not be selected!
Please check the database permissions for the specified user and try again.

Tried various prefixes, and even connecting to the database as mysql root - with no effect.    Attempted these steps on both Server and Mac Client.

I have already tried that.   And reset all permissions in the database for the user.
When I entered the new authentication prior to Pre-Validation - it was able to test the connection successfully.

The only error only occurs when config.inc.php is included, and it attempts to Pre-Validate as Advanced Upgrade, as Pre-Validation without this file - meaning a clean install passes the Pre-Validation.

What I am going to try tonight is to edit the config file to store the new authentication details for the database, even though the upgrade path is meant to supply them, and prompts the user for them.

Does it work with a clean install(empty db)?

Clean install works,however needed to run the following commands..

In Assets..

chmod -R 0777 cache
chmod -R 0666 images
chmod -R 0666 files
chmod -R 0666 media
chmod -R 0666 flash
chmod -R 0666 exports

In Manager\Includes

touch config.inc.php
chmod 0666 config.inc.php

Reconfiguring the config.inc.php to support the MySQL root database password = Failed.

Once you have a clean install working
- use phpMyAdmin to populate the db
- replace all the files with the ones you developed with IIS except the config file.

That’s all I can think of.