(MySQL 5.1.51 Page 8 of 8)

MySQL TroubleShooting:

If you encountered an error here. The most likely cause is that you have had a previous installation of MySQL and there are config files interfering with your new setup. Windows XP has a folder in Documents and Settings with your old MySQL setup info. Win Vista, 2008 and 7 like to keep this in the newer location, ProgramData. In either case, those files should be deleted or backed up. Using the Windows uninstaller (though recommended) does not catch all files. Always back-up before deletion if you have a functioning database you have been using and would like to keep. You may need to check path and program settings. This type of scenario always dictates you use extreme care. Read to the end of this section before attempting to debug your error. There is a very good debug link listed in this section.

If upgrading, ensure your version is compatible to this upgrade as noted on page one of this tutorial under the section: Preliminary MySQL 5.1 Installation Steps.

Of course, UAC can interfere too. Check our other install guides for more data on handling the UAC or review the Microsoft link given on page one of this guide..

MySQL 5.1 Troubleshooting
(Fig. 20)

Your first resource to use when troubleshooting MySQL 5.1 server issues is to check the error log. Check the file errmsg.sys in the shared/english (or other language) folder. Toggle hex modes in your hex reader (eg. ultra edit) if you have any difficulty reading the file. It will be located in a path similar to C:\Program Files\MySQL\MySQL Server 5.1\data or in C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default.

Also, a great troubleshooting resource for MySQL 5.1 under Windows is the mysql trouble shooting page.

Module Completion

If you are confident with what you have learned here, then you have also gained a couple of very basic entry level skills in mastering your PHP Software. Pat your self on the back, you have completed this course module.

Module Length:

• 1 Hour

Pre-requisites:

The website administrator has previously attained the following computer skills:

• Ability to download an installation file and execute it.
• Ability to code a basic .php script (and/or)
• Ability to navigate a Dos session

Applicable OS Platforms :

• Windows 7
• Windows 2008
• Windows Vista
• Windows 2003
• Windows XP (SP3)

Hardware-requisites: (on Windows OS)

• x86 family processor - All (eg. Intel, AMD)
• x64 family processor - All (eg. Intel, AMD)