If you are planning to use MySQL on Windows small business web hosting server there wont be any issues and you can use it easy, all you have to do is to install MySQL by following download instructions provided at mysql.com you just have to dump collection of and directories into the c:\mysql directory. You can visit c:\mysql\bin and list the .exe files to see what is available.
You can use following commands for more details :
c:\mysql\bin>mysqld-nt –install
c:\mysql\bin>mysql
Once you run the above commands, you will have command line prompt where you can enter all your SQL statements. If you need to exit from prompt you need to fire ‘exit’ command.
MySQL always run in the background which never gets stopped, even resum itself even after rebooting Windows.
You have ‘net’ command using which you can control windows services, to get list of all services currently installed you just need to use
c:\mysql\bin>net start
You can see MySQL as one of the running services and even if you reboot NT this service will be continued. If you want to stop the service you can do so easily using following command.
c:\mysql\bin>net stop MySql
c:\mysql\bin>mysql-nt –remove
once MySQL is stopped you may want to start it again with different version of MySQL like mysql-max-nt, in this case you will use following command
c:\mysql\bin>mysql-max-nt –install
c:\mysql\bin>net start MySql
Thus, you can use MySQL efficiently even on windows NT and can start/stop it easily using few commands. You can also manage email hosting services through Windows Plesk hosting packages.
Posted under email hosting
This post was written by admin on April 28, 2010
