Install problem with MySQL

If you could just point me in the right direction I'll sure
appreciate it! Running Win XP Home, purchased a Sams book entitled
PHP,MYSQP and Apache. Did all the installs as directed and since
ver 4.0.21 of MySQL was provided on the CD with book, I went to the
site and downloaded 4.0.26 - unzipped the file in a folder and
clicked on setup.exe, followed all the prompts with no exceptions,
no changes, taking all defaults in the install, and very very early
in the install it aborted with the following message:

Error occurred during the move data process: -103
Component: Servers
File Group:
File:



That's it - while "Component" did include the words "Servers"
the next two items were blank as shown above. Will appreciate any
guidance! Wish I could help more but hope to learn how to use this
software, but need it installed first and have no idea what to do
now. Thanks in advance for any assistance. And I did look through
the forum archives, did several searches, but found nothing like
this. Hope it's something simple!


Gene McCutchen
Chadds Ford, PA
USA

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Install problem with MySQL

On 10/10/05, Gene McCutchen wrote:
> If you could just point me in the right direction I'll sure
> appreciate it! Running Win XP Home, purchased a Sams book entitled
> PHP,MYSQP and Apache. Did all the installs as directed and since
> ver 4.0.21 of MySQL was provided on the CD with book, I went to the

Too old, many bugs, you should get the last stable version, is it
still 4.1.14? Guess so. Between 4 and 4.1 there was major changes and
fixes.

> site and downloaded 4.0.26 - unzipped the file in a folder and
> clicked on setup.exe, followed all the prompts with no exceptions,

Try the zipped 4.1.xx (last) version and unzip it, read the Manual
following the install instruction (setting up your mt.ini or my.cnf,
creating and running the service). The MySQL Manual is complete and
exaustive on installation issues. You always have the choice to get
the MSI essential package and install it, but IMHO its more trouble
later when you use wizards and don't know exactly what you're doying.

> no changes, taking all defaults in the install, and very very early
> in the install it aborted with the following message:
>
> Error occurred during the move data process: -103
> Component: Servers
> File Group:
> File:
>
>
>
> That's it - while "Component" did include the words "Servers"
> the next two items were blank as shown above. Will appreciate any
> guidance! Wish I could help more but hope to learn how to use this
> software, but need it installed first and have no idea what to do
> now. Thanks in advance for any assistance. And I did look through
> the forum archives, did several searches, but found nothing like
> this. Hope it's something simple!
>

Its a problem with the setup.exe, not MySQL, and its an old version,
so, no support probably, get the latest version and come back to us if
you have any issues.

Good luck,

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

SQL help

I have a table with 5 fields . I want to do a select to get the row with min
score

table is as below
Name row_id score Grade Status
abc 1 98 A 1
abc 2 97 B -1
abc 3 96 c 1

I want to return one row for same name. The row with minimum score and
status <> -1

so the returned row should be
abc 3 96 c 1

Help is appreciated

Regards
Harpreet


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

SV: SQL help

SELECT * FROM table WHERE Status <> -1 ORDER BY score DESC LIMIT 1

Terje

-----Opprinnelig melding-----
Fra: Harpreet [mailto:harpreet@crispincorp.com]
Sendt: 12. oktober 2005 05:04
Til: MySQL Win32 List
Emne: SQL help


I have a table with 5 fields . I want to do a select to get the row with
min score

table is as below
Name row_id score Grade Status
abc 1 98 A 1
abc 2 97 B -1
abc 3 96 c 1

I want to return one row for same name. The row with minimum score and
status <> -1

so the returned row should be
abc 3 96 c 1

Help is appreciated

Regards
Harpreet


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=tk@webon.net


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org