MYSQL :: Windows MySQL Questions

MySQL Questions
I have a few SQL questions..i was hoping you guys could help with!

Example: I have 3 tables, one which is a series of id's, and the other 2 which contain data:

talbe: contacts_pool (just a linking table with id's)
id, pool_id, contacts_id ..

table: client
id, name, pool_id, contact_id .. (every client has a main contact: contact_id and also a pool of contacts: sales, support etc)

table: contacts
id, name, address, tel, fax etc..

1. I want to run a query to show all clients that do NOT have an entry in the contacts pool (pool_id). So far, I havent managed to do this...understandably the following returns *all* values that do not match, clearly not what i want:

"select * from clients, contacts_pool
WHERE clients.contacts_pool != contacts_pool.pool_id;"

So I think I would be looking at finding the ones that DO match, and somehow accessing remaining rows..any ideas?

2. From the results set, i'd like to be able to use the results (in the same way as $x = mysql_fetch_array then $x['id'] in php), but in the sql query window)..is this possible?

3. Also, after putting the results in an array (mysql_fetch_array) how can you differenciate between two fields of the same name, but from different tables? $x['tablename.id'] doesnt work..is there a way to do this, i.e. to define exactly which id I want? A workaround would be to use in the query window: select id AS NEWid, but i want a cleaner way to do it.

New To Mysql. 2 Questions
I am new to mySQL and I have 2 questions:

1. Everytime I login to mySQL:

machine 21:06:32 ~ $ mysql -u root -p
Enter password:

It asks me for password. Since I didn't set a password for root when I
installed mySQL, I can just hit Enter and I will be login. This seems
silly so is there a way to disable the prompt so I am automatically
login without hitting Enter?

2. I want to create a user account with only SELECT privilege from
everywhere (like from other hosts). How can I do that? Will the
following work:

GRANT SELECT PRIVILEGES ON mydb.* TO 'readonly'@'*' IDENTIFIED by
'password'

Do I need to create the 'readonly' user first? Or will the above
automatically create the 'readonly' user if it does not already
exists?

2 Mysql Questions
Got 2 quick questions that i hope some of you people out there can
help me with.
1) I am currently running mysql 5.0 alpha on my server but a few
programs that worked on mysql 4 won't run properly on 5.0, so is it
possible to change some settings in mysql 5 so its backward compatible
with mysql 4 programs?`
2) What is the easiest way of upgrading from 5.0 to 5.0.1 under redhed
linux or webmin without loosing the data in database?

Simple MySQL Questions
I have these two simple questions about MySQL:

1- If a column (id) in a MySQL table holds data of type mediumint (or other int types), when I do an SQL query do I have to put the id number between single quotes like id=õˆ' or just id=875 ?

And the more stupid question :

2- When I do an UPDATE query, does the updated column have to be the same one that identifies the row (after WHERE in the query) to be updated? i.e. is the following query valid?

UPDATE table_name SET col1=1 WHERE col2=10

General MySQL Questions
Im working on a project that involves table full of domains and I wanted to do a search script which searches those domain names based on certain criteria.

I have just a general sql question list so if you would be so kind just to give rough simple queries on how to do them or toss me a link or two that I could read up about it.

Example 1:
Domain: domaintools.com

I figured to search the domain for a word match I would use like?

Select * from table where domain like='%domain%'
Example 2:
Domain: domain-tools.com

I am trying to figure out some way to search for all domains where a - is not present, not sure how to do this one.

Example 3:
Domain: abc.com
Domain: abcabc.com

I am trying to figure out some way to return results based on there length I am not sure how to count in sql to return the length. For example

Select * from table where length(domain) > 8
Example 4:
Domain: search4.com

I am trying to figure out a way to return all results where a number is present or not present, no clue how to do this one.

Basically just a general how to is what im looking for or any resources that could help me on this. Unfortunatly I havent a clue how to do queries like this so I have no Idea what to even start searching for.

Mysql Insert Questions
I want to insert data to a new table from an existing table, but I also want to enter a couple of new fields

I have this query:

INSERT INTO table1 ('field1,'field2') SELECT 'field1','field2' from table2

I want to have something like

INSERT INTO table1 ('field1,'field2','field3','field4') SELECT 'field1','field2' from table2 , 'new value for field3','new value for field4'

Is it possible, if so, what is the correct syntax?

More Questions About The Mysteries Of Time And Dates In Mysql
part of a query I am running goes as follows:
floor(sum(unix_timestamp(dtp.endtime)-unix_timestamp(dtp.starttime))/60) as total.....group by dtp.activityno

dtp.endtime and dtp.starttime are both datetime fields.

I am saving the result into a temporary table and what it gives me is the total number of minutes spent on the selected activitynos...

My question is: if a result from this query is for example 123 (and 123 minutes is the correct number of minutes-2 hrs and 3 minutes) how can I show this result as a date field in MySQL? that is as 02:03:00?
I tried setting the field type to date when creating the temporary table but that just made a mess of the actual number of minutes.
Anybody have any ideas?

New Member "HELLO" : Couple Of MYSQL Questions.
I'VE JUST DISCOVERED TEKTIPS SO HOPEFULLY SOME OF YOU GUYS CAN HELP WITH THIS.

I have 2 problems i'm trying to solve.

1. How to select a random picture from each group of pictures but not repeat the group.

I have 2 tables
- Pictures : contains Id, Thumb (link to the picture location, Exclude, GroupNameId
- GroupName, contains Id, Group, Exclude, newgroup (to show a NEW pic)

The current query is :
SELECT groupname.Group, pictures.Thumb, groupname.ID, groupname.newgroup
FROM rascal.pictures, rascal.groupname
WHERE pictures.Exclude=0 AND groupname.exclude=0 AND pictures.groupnameid = groupname.id and Thumb <> ''
ORDER BY RAND()

This brings back random pictures but sometimes (almost always) the groups are duplicated.

I'd like something to only bring back one random picture per group.

I tried this

select * from rascal.pictures a JOIN rascal.GroupName b on a.groupnameid=b.id Where a.exclude <> 1 and Thumb<>"" Group by b.id order by Rand()

but this brings back the same picture in each group each time, which is not what i want.

Does anyone have any idea how to acheive this is MYSQL ?

2. UK Number One Hits.
I've decided in my wisdom that it would be quite cool to be able to tell someone what was number on the day they were born (by entering a date) ... easy peazy, but I want to also display what was number one on each birthday until the present day.

The file contains the date the record became number one NOT each date for every year.

To get the birth date would be something like

SELECT * from numberones where numberonedate < xdate ORDER by numberonedate DESC LIMIT 1

but how would I return each seperate year into an ASP page and display it

Performance Questions
My company make several flash-based games, and I use php to communicate
with
mysql to provide highscore-lists.

My problem is this:
When I save a player's score in the mysql-table, I want to find which
place
the player got with his score (today). To get this I have tried two
different solutions, which both works, but are very ineffective: (The
Time-field is a DateTime type, and I have Score and Time as Indexes.
The Score-field is a DECIMAL (20,2))

1) SELECT COUNT(*) FROM table WHERE Score>=$score AND Time>CURDATE().
- or -
2) SELECT Score FROM table WHERE Score>=$score AND Time>CURDATE().

.... $place = mysql_num_rows($result)

Both give the right result, but the problem is that when there are many

players playing at the same time, and the table consists of several
million
records, the query is just too heavy for the mysql-server, and it
breakes
down.

So my question is: Are there any better ways of getting a player's
place?

Error 127, Some Questions
We have several tables experiencing table error 127 quite often, sometimes
several times per day. I have read the relevant posts recently, including
http://www.mysql.com/doc/en/Repair.html

Forgive me for my lack of technical expertise in these questions:

1) The SQL statements are all INSERTS (using all fields - see below for
table structure), so is it possible, say when a client server goes down
during an insert, that somehow the data only gets inserted "half-way"?

2) From other posts, it seems that one common column is a date or timestamp
field. Could this be the problem?

3) There are no (very few - once a month for statistical reporting) selects
done on the tables, so we don't know when the problem occurs, so is there a
way to monitor the tables?

4) It only affects my tables with more than 10k-20k inserts per day.

5) Is moving to InnoDB a way to possible solve the above?

6) We occasionally experience "Mysql server has gone away" - due to network
congestion, could this cause problems?

Code:

Installing Questions
I run some websites where i use php scripts to open connections to add and delete info from database tables. I use phpMyAdmin as my interface to the tables. However, all of that resides on my web hosting company. I would like to be able to test my php scripts with my database tables locally, and then ftp them to the website once they work (so I guess I would like a testing environment setup on my computer).

I know I would need to install mySQL and PHP on my computer, but would I need to intall Apache? Could somebody please tell me what I would need to install on my computer in able to run these scripts without having to ftp them to the internet everytime. I also plan on using Navicat as my Administrative Interface for mySQL.

Version Questions
My first question is about which version of MySQL I should download. The server my site is on is running version 3.23.49. I would like to install MySQL on my PC to learn with and to work on prior to uploading to my site. Do I need to load the same 3.23.49 version on my PC?

DB Relationship Questions
I'm trying to set a Primary Key / Foreign Key relation using phpMyAdmin.

1. I assume that the Foreign Key is a Primary Key in its own table, and that really the relationship is between to Primary Keys, one that behaves as a Foreign Key. Is that correct?

2. It seems that if I select a table, I can then select 'Relation view'. That's where I seem to define this relation. Do I define it from the table that has the primary key, or from the table that has the foreign key? Code:

Max Questions Reached
We've had a mysql database running for a few weeks now supporting a simple application. This morning, for the first time ever, I came in and found that the application was erroring out due to max questions reached error. [the value was set to (I think) the default value of 50K].

I'm wondering if anyone can give me a little guidance on what, excactly, constitutes a 'question' in this case.

Is each 'question' a dedicated log in attempt to the database, successful or failed? Or does it represent more of a database ping ala tnsping ? The description reads 'Number of queries sent to the server', but I'm guessing that this does not represent actual select statements, there looks to be another place dedicated to tracking selects and it contains far fewer values than the Questions value.

Also confusing me is that we shut down the server and stopped all applications that were touching it. None the less, after resurrection, if I log into MySqlAdministrator, the number of queries kicks up at approximately 3 / second. The only connection I show to the database is my Administrator session, but the number of queries just keeps rolling.

Is it possible someone else on my network has started toggling the database? If so, will changing the password alleviate this problem?

General Questions
I want to learn PHP but I hear that I need MySQL in order to run PHP. Firstly:
1. What is MySQL??
2. What version should I download???
3. What do I have to learn in MySQL in order to run PHP???
4. Is MySQL difficult to learn???

BIGINT Questions
I have a few questions about using a bigint as primairy key.
1) Does it effect performance, compared using regular INT as key?
2) Can a bigint hold 20 charaters? -> BIGINT(20)
3) Someone told me it would only be usefull on a 64 bit cpu. Is that true?

Database Design Questions
I have 2 questions:
1st How many records can you store in the mysql table and database before you slow it down?(Im not referring about the web server storage)

2nd Having a table of people(contact info) data, is it bad database design to create 50 tables(one for each state) in one database to hold the data. If I can I think it would be fast for the searching of peopleâ€™s info. You can search one state instead of all 50(if you known what state you want).

More Database Structure Questions
i have a site that has products in categories. products have only 1 category. categories have unlimited sub-categories and have a self join on the categories table. categories can contain products, sub-categories or both. i also have merchants for each product. finally, a user can have a product list (list of products they have selected). A user can select 1,000's of products (this is not a shopping cart).

when a user is browsing the categories, merchants and products, i want them to be able to filter their results by merchant, category or if the product is in their list.

what i have so far (see below) is working but i want to know if this is the best way to deal with the problem and if it has potential scalability issues if i were to make more filters based on for example, brand or something else related to the product.

cat2merchant
this table allows me to track the categories a merchant's products exist in because some categories don't have products. more info here. this table would contain a row for every category and sub-category that the product exists in.
category_id
merchant_id

categories
id
name
parent

productlist2product
this keeps track of which products the user has added to their product list associated with their product list id (another table)
productlist_id
product_id

merchants
id
name

products
id
name
merchant_id
category_id

cat2productlist2merchant
this table helps me to filter results if user wants to just view all cats and merchants that contain their selected products. also, if a product exists here: cat1 > subcat2 > subcat3 > product, this table would have 4 rows (1 for each category).
category_id
productlist_id
merchant_id

I have considered combining the cat2productlist2merchant table with the productlist2product table but then that table would be filled with some empty product_id's.

i've also considered making a table for each relationship a productlist_id has with other filterable tables such as merchants, categories (possibly brands).

A Few Questions About Chat Applications
I'm writing a chat app at the moment and it will likely have many rooms(possibly 100). I'm wondering if it would be best to use XML or mysql? If mysql, should i make one large table to hold the message stack for all the rooms or seperate tables for each room? all data within these tables is temporary so it will never be large.. would it be best to use MEMORY tables in this case?

New, Confused, And A Couple Of Questions
i am very new to MySQL and I have a couple questions that I am really confused about on how everything works.

First, I will explain my project: I am designing a site, that is holding a lot of information, a database. I was told MySQL is the easiest way to go, but i have gotten really lost trying to work everything out.

My questions are:

1.) I have a syntax already formed and I would like to put all the information into a database that can be mirrored onto an HTML document.

I was wondering how I am able to call for the information out of the database and into a table in the HTML document. For example, one of the parameters is 'ID'. and there are 3 places in the table: ID, Name, and Description. So i want the ID to be called from the SQL database and put into that spot in the HTML document, but i am confused how i do that.

Some Questions Regarding My Database Project
I actually have a couple of questions regarding this project.

First, I have a pretty good understanding of SQL code. I use to work
with dBase III and IV. I now work with Access 97 and 2000 and can do
simple Query designs.

I have a text file that is about 915mb and consists of records that
are fixed in length of 331 characters. There are no records
delimiters

1. Does anyone know of a good text editor that I can use to insert a
carriage return every 331 spaces?

2. I more familiar woth Access, but can Access handle nearly 2.75
million records?

3. Can MySql handle 2.75million records?

Questions Regarding My Supertype/subtype Setup
I'm doing a supertype/substype setup with one table (opposed to children tables) by using a row type column and allowing columns to contain nothing if they do not apply to that rows type.
Should I be storing null for the columns which do not apply or something other?
I am also wondering about the space my table will take up and any speed issues. The table will have about 20 columns with the majority of the time having data in about 15 columns.

Questions About Pagination Query, Never Been Asked, Must See! :)
My thread title is like a marketplace thread, eh? just an intermezzo

Okay, to the problem:

In a pagination code we need to fetch total rows first, for example using this query:
SELECT COUNT(*) FROM table WHERE somefilter

then, we do a query again to get the real data with a limit:
SELECT * FROM table WHERE somefilter ORDER BY order LIMIT start, rows

My questions:
1. I read that COUNT(*) is very fast because it pulls the count values right from table info (I don't know where mySQL saving this), is it correct? and is it still correct if there's a where condition like the query above?

2. Referring to http://dev.mysql.com/doc/refman/4.1/...functions.html, I want to use SQL_CALC_FOUND_ROWS to optimize the 2 queries into 1, but I read on the comment, someone says:

Quote:

Be aware that using SQL_CALC_FOUND_ROWS and FOUND_ROWS() disables ORDER BY ... LIMIT optimizations

So is it true? I assume if there's no optimization for ORDER BY then the query will go slow.

3. Referring to http://php.net/mysql_num_rows on first note (by Typer85 at gmail dot com), there's an issue if we use SQL_CALC_FOUND_ROWS and FOUND_ROWS() :

Quote:

If two different requests come in through PHP, your going to run into problems. Note than when I mean request, I mean two different clients requesting your PHP page.

---------------
Request 1:
---------------

Execute: SQL_CALC_FOUND_ROWS On Table 1

---------------
Request 2:
---------------

Execute: SQL_CALC_FOUND_ROWS On Table 2

---------------
Request 1:
---------------

Execute: Select FOUND_ROWS( )

At this point, you see the race condition that occurred. While Request 1 was being executed, Request 2 came in.

At this point Request 1 will return the number of Table Records in Table 2 and not Table 1 as expected!

Again, is it correct? If it is, so we can not rely on FOUND_ROWS() function then?

10 Random Encoding And Collation Questions
I have some random encoding and collation questions I feel I need to ask so I call fill in some gaps in my knowledge. Most of them relate to MySQL so I thought this would be the best place for them. If you could help even with one it would be greatly appreciated:

1) What's the difference between the utf8_general_ci and the utf8_unicode_ci collations and are there any advantages to either?

2) Is there a way (In PHPMyAdmin or other) to convert a db along with all its tables, columns and data from one charset/collation to another without having to change each one individually?

3) Is there an easy way to tell what character set a server is sending?

4) What happens if the data in the db uses one encoding and the server is sending another?

5) What happens if a document is saved in one encoding and the server is sending another?

6) What happens if document is saved in one encoding but the db uses another?

Am I right in thinking the following:

7) If you create a db without specifying a charset/collation, the default set will be used which is normally ISO-8859-1 with the Swedish collation.

8) All tables and text based columns created within this db will then use the default collation.

9) If you did specify a charset/collation for the db then all tables and text based columns created within it would use this same set without the need to specify it again.

10) If you changed the charset/collation for the db, this would only affect the db itself and not the tables and columns within it. Meaning that new tables would use the new set but existing ones would carry on using the old one.

INSERT INTO ... SELECT (...) Performance Questions
Using version: 4.0.18-Max-log

We're getting some fairly poor performance when doing an INSERT INTO
temp_table ... SELECT (...). The SELECT is grabbing 2K row chunks from
its table, so the problem is not that the query results are so
monstrous that it's just taking that long to gather them all.

The problem appears to be one of IO. When an INSERT...SELECT is run,
the SELECT part of the query is run first and those results saved in a
temporary table. Then the contents of that temporary table are
inserted into its final destination, which in our case *also* happens
to be a temporary table. All of this table reading and writing is
causing things to drag.

Unfortunately I don't have our MySQL variables handy or our hardware
specs. But I can get them in fairly short order either is needed. I
do know that our hardware is < 6 months old and has a few gig of RAM.
The discs, if I recall, are a RAID array but off the top of my head I
don't know which flavor of RAID.

Our questions:

1) Why does MySQL write to a separate temp table when the destination
table is already a temp?
2) Is there some way to make the results of the SELECT write directly
to the destination table (be it temporary or not)?
3) Are there any other suggestions for resolving this performance
problem? Maybe there's a variable which at least will force the SELECT
to write to a TEMPORARY HEAP table instead and avoid the extra disc IO?

--V. M. Brasseur
Software/Database Engineer
iPost
http://www.ipost.com

Stock Quote Database Questions
I want to create an application which will collect the daily stock quotes everyday and also i will want to maintain historic price for every symbol. there are about 6000 symbols.

MySQL On Windows
I downloaded and installed MySQL for Windows this morning, V4.1. =
Unzipped, installed and started the server as a service, no problems. =
Installed the ODBC driver. A-OK

But, the DOC tells me I have to run "mysql_install_db.sh". So, the =
question is, how am I supposed to run shell scripts on Windows?

Mysql 4.0.20a For Windows
i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine

and heart about that the feature "auto_increment = default value" will work now

now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which means, mysql shoud then auto_increment up from the given value), but this doesn't work

i can only choose between default value or auto_increment but not both any ideas ?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run. Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL 5.0 On Windows 98 SE
I just downloaded MySQL 5.0 and installed it on a machine that I just did a fresh install of Windows 98 Second Edition on.

The install seemed to go smoothly, and when it was done I try to start mysqld from the command line and get this:

C:Program FilesMySQLMySQL Server 5.0in>mysqld --console
051125 21:04:07 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser
ver 5.0shareenglisherrmsg.sys'
051125 21:04:07 [ERROR] Aborting

Also, when I look in the above referenced directory, the file errmsg.sys is there: Code:

Mysql On IIS Windows
I very new to mysql. I would like to get some advise on which release i should install in my windows 2000 server using IIS.

MYSQL In Windows XP Pro Sp2
i get a ERROR 0 when loading the program into my computer. and the servise could not be started, if i go into cmd and type "Net start MYSQL" it says sucsessfull

but when i go into Contrl panel > Administrtor tools > Servise's and click MYSQL it says "error 1067 could be be started"

Can I Use MySQL With A Mac And Windows
I need to share a MySQL database with a guy that uses a Mac, but I don't know anything about the Mac environment. I use WinXP. He has a server that has MySQL loaded on it. I want to create the database, then both of us want to be able to access it or make changes to it via the web.

What type of products do I need? I figure a good MySQL reference book is a necessity. Is there some type of front end application that he can run. I think I can run Access as a front end once it is set up properly. Am I making sense?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run.

Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL On Windows
when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes:

the security settings could not be applied
error number 2003
can't connect to mysql server on 'localhost' (10061)

i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...

Mysql On A Windows Box
there are two options for mysql when it comes to windows...there is a 'windows essentials' and then there is the normal download.
the documentation says the essentials package, (it's almost half the size) is the recommended one because it has all that is needed.
i don't really care if i download the biggest file size, but if i don't need to, i'll take the smaller package.

Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6).

Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me.

As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.

Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

MySQL / Windows XP SP2 Incompatibility
I've been posting the problem earlier on Microsoft newsgroups (cannot use support, because of using OEM Windows):

Windows XP SP2 Security Center stops recognizing antivirus and firewall software when I install MySQL server and GUI tools (MySQL Administrator and MySQL Query Browser).

The only way to make the Security Center recognize the software again is to restart it using Services snap-in.

Is it a bug on Microsoft side or on MySQL team side? Are there any solutions for the problem?

Configuration:
Intel Celeron 1200 MHz / 512 MB RAM
Windows XP Home Edition with Service Pack 2
MySQL 4.1 with the latest versions of GUI tools

Cannot Get MYSQL To Start In Windows
Here are some of the errors I receive when trying to start mysql under windows xp home edition:

When I goto mysql command line client the client start but If I hit a button it shuts down.

When I type this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysql" test
ERROR 2013 (HY000): Lost connection to MySQL server during query

Or I try this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysqld" --console
060323 12:18:24 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
C:>

Also while trying to install I cannot get the security setting to go thru, it give me the error 2013, lost server during query, I've tried to shut off my firewall and still the same, given access to port 3306 and still nothing.

Mysql And Windows 2003
does the latest versions of Mysql work with windows 2003.

Used Mysql On Windows Now Im On Linux Need Help!
Ok iv changed over to linux running ubuntu 6.06 after installing mysql i tried create a database i did "CREATE DATABASE forums" and got this:

./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'DATABASE''

so how do i logging as root? on windows i just used the terminal thing but now i dont have that (well to the point where it asks you to login)

Does MySQL Work On Windows?
I've been trying to get 3.23 to behave on '98. MATCH seems very erratic, and FULLTEXT never works. RELOAD silently fails. Is it worth it to pursue MySQL on Windows?

Install MySQL 4.1 On Windows
I'm trying to install the 4.1 alpha binary version on Windows.

After unzipping the download I don't find a setup.exe file.

MySQL 5.0.45 Windows Install
I am having an issue installing MySQL 5.0.45 on Windows 2003 (VMware). Basically, I extracted the contents of "mysql-5.0.45-win32.zip" to c: emp and double-clicked the setup.exe. However, the install wizard doesn't launch. I get a window with the install options via CLI.

Mysql Dump And Windows
I have installed mysql on windows.

However, due to database corruption issues I would like to perform a backup every hour or so. As a result I plan to schedule a mysql dump at regular intervals(for example using the AT command). The problem is that the user that runs mysql dump has to supply the password. ie: myslqdump -u user -p databasename > backup.sql

My question is: how do I specify (in a .cmd file) the password to enter after the mysql command above? I do not think "echo password" is enough for mysql to pick up the password.