A step by step tutorial teaching you how to create your own chat client and chat server easily in C#, for local networks or the Internet.
A C# tutorial showing you how to make use of WMI to extract information on disk drives, such as model, capacity, sectors and serial number.
This tutorial will teach you how to calculate the shipping cost based on the weight, height, length and depth of the box, the distance and the UPS service type.
How to Upgrade from MySQL v 3.x to MySQL 4.x
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine. I am going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine.
On Thursday, September 9th 2004 at 09:03 AM
By Nabeel Akhtar (View Profile)
(Rated 4.5 with 6 votes)
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine.
I am going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine. If you are not sure what version of
MySQL you are running, log into MySQL using DOS prompt and it will display the version information at the very beginning. If you have phpmyadmin, you can also look up the version information there.
Time to Back it up!
Time to Download the new MySQL version 4.x!!
While you are there, also download the MySQL Administrator (Graphical Client) from http://dev.mysql.com/downloads/administrator/index.html
Time to Take It OFF!!
If you are not the root user, but have admin privileges, you can type in your username and password to shutdown the service:
C:\mysql\bin>mysqladmin --user=sql --password=sql shutdown
Next REMOVE the service like this:
You will see a confirmation that the service has been removed:
Service successfully removed.
If you still see the Traffic Light in the taskbar, right click on it, choose Win NT and click on "Shutdown this tool"
Click on "YES" when prompted.
Rename the c:\mysql directory to something like c:\mysql_OLD. I did not delete the directory because in case my installation fails, I can always come back to old MySQL.
Also rename the file "my.ini" which resides under c:\windows\. I renamed this file to "my_OLD.ini".
Time to Bring it ON!!
Now open Windows Explorer and double-click on mysqld.exe located in the bin folder of MySQL (C:\mysql\bin)
A command prompt window will open and automatically close after it installs the service. Now double-click on winmysqladmin.exe located in the "bin" folder
Once the application starts, it will ask you to enter a username and password. You MUST enter this information in order to proceed. Once you enter the password and click "OK" you will see a Traffic Light in the taskbar. If it is green, it means you are good to go!
Time to Take it to the STREETS!!!
|Digg It! Del.icio.us Reddit StumbleIt Newsvine Furl BlinkList|
Rate this tutorial
There are no related tutorials.
Related Source Code
There is no related source code.
SQL Job Search