Installing Mysql on Windows

Written by Pravin on October 20, 2008 – 4:50 am -

This installation is for Mysql 4 on Windows. Download Mysql 4 from http://dev.mysql.com/downloads.

Run the MSI file and use the following settings

* Typical Setup
* Skip Sign-Up
* make sure “Configure the MySQL Server now” is checked
* “Detailed Configuration”
* “Developer Machine”
* “Multifunctional Database”
* “InnoDB Tablespace Settings” – leave everything default
* “Decision Support (DSS)/OLAP”
* make sure “Enable TCP/IP Networking” is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
* “Standard Character Set”
* check “Install As Windows Service”
* enter your root password and I would recommend leaving “Enable root access from remote machines” unchecked
* then hit “execute” and it’ll install and set it up.


Tags: , , , , , , , ,
Posted in Dedicated Server Hosting | No Comments »

How to converting MYSQL table from InnoDB engine to MyISAM

Written by Mangesh on October 16, 2008 – 10:36 pm -

How to converting MYSQL table from InnoDB engine to MyISAM

I have problem of table repair in InnoDB so I need to convert InnoDB to the engine MyISAM.

I converted a MySQL table’s InnoDB to the engine MyISAM.

The code I found for conversion:

ALTER TABLE Tablename ENGINE=MYISAM

You can replace MYISAM engine to InnoDB, ISAM, HEAP and etc.


Tags: , ,
Posted in Dedicated Server Hosting, linux, Linux VPS Hosting, Plesk For Linux, VPS hosting, Windows VPS | No Comments »
RSS

  • Subscribe Me

  • Tag Cloud

  • Archives