Saravanan wrote:
Yes , Version is mysql-3.23.47 -win.zip
which exe file i should run mysqld.exe or mysql.exe ?
First, before you read further, do this:
%%%%%
IF you installed mysql to the default directory (C:\mysql) , then copy this URL and stick it in a browser window.
file:///C:\mysql\Docs\manual.html
there is also the manual_toc.html
These are very helpful.
%%%%
If you installed default from the setup progam , then all you need to know is that the myslqd <-- daemon, will be loaded as a service when you start windows. (right click the taskbar and chose Task Manager and goto the processes tab. You should see mysqld-nt.exe running. This is the daemon that runs in the background as the service.
The mysql.exe is the executable that you can run at the command line. Open a command window and type cd c:\mysql\bin and hit [ENTER]. You should then get the MySql message and prompt, like this:
C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.47-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
congrats, everything is working ok.
i should call this exe from dos /win application?
Yes, a command screen, but not a dos/win app¡Kmore about that in a few minutes.
Do know that command line DBA - administration takes place by calling the mysql.exe via the command line. You can also call different options:
C:\mysql\bin> mysql my_db
//calls the server set to the my_db fictional database
You will place the name of the db you want to use.
or C:\mysql\bin> mysql -u root
//and then call the database you want to use with ¡§use my_db;¡¨ from the
mysql> prompt.
You have to configure all the options regarding security eventually, but first get used to how it works... the security options are listed in the manual and explain in more detail what I was just talking about. Of course don¡¦t work on real data, names or passwd¡¦s while ur getting used to how mysql works.
Do know that when you connect in a default install, that you are logging onto the "server" as root@localhost in the above example. if you do not specify, then you are logged on a ODBC@localhost. Read the Manual for all the explanations about ¡§how¡¨ you are connected via command line, versus connecting from a script.
should i execute all shell commands in dos window?
That¡¦s a trick question. ƒº the answer being, yes/no.
In winXP there is no such thing as DOS anymore, it is emulated, but what you¡¦re calling the DOS window ¡V a command line window is how you will do your DB administration.
You will most likely ¡§call¡¨ the db/server from a PHP, yes? If that is the case, then you are really calling the mysqld-nt daemon which is the real server working in the background, and w/ the script you are calling the server w/ the variables/data that you send to it.
This is ticky tacky , but its crucial in understanding how things are working, or more likely , like in my case¡K, not working ƒº
I HIGHLY suggest this book.
This link has support info for the book/authors:
http://www.samspublishing.com/catalog/product.asp?product_id={D766DE0D-D3B7-42B8-A421-3BCFDD08B32D}
Buy it for cheaper at Amazon:
http://www.amazon.com/exec/obidos/ASIN/0672317842/qid=1012992792/sr=8-1/ref=sr_8_67_1/002-6795007-8522419
However, there are some quirks about using Apache 1.3.22 / PHP 4.1.1/ MySQL 3.23.47
Some get clarified by the book, some get clouded. But just lemme know, and ill be more than happy to help out¡Kw/ my VERY limited knowledge.
