Well,
<short digression>
Thanks to the MUI packages available on Vista Ultimate, I was able to change OS idiom simply by installing one of them and logging off (near 400MB pack which exploded to 1,5GB). No reboots.
This was needed because my OS main language is Portuguese, so now my OS and this tutorial share the same idiom.
</short digression>
1) Let´s first install Mysql5:
1.1) I read somewhere
[1] that Mysql 5 wasn´t ready for Vista 64-bit. Nevertheless, I decided to try the EM64T package, highly encouraged by my environment variable:
PROCESSOR_IDENTIFIER = EM64T Family 6 Model 15 Stepping 11, GenuineIntelSo, if you dare, choose the "Without installer (AMD64 / Intel EM64T)" download file from :
http://dev.mysql.com/downloads/mysql/5.0.html#winx641.2)
Expand the zip file
in c:\. Vista extractor will create a directory like
mysql-x.x.xxx-winx64 there.
1.3) Rename the directory to
mysql.
1.4)
Run a command prompt in administrator mode1.5)Run the following command:
setx PATH "%PATH%;c:\mysql\bin;" /M
Shoud return
SUCCESS: Specified value was saved.
2.0) In the mysql directory (
c:\mysql if you´re following the recipe),
copy the
my-innodb-heavy-4G.ini to
my.ini . This will be the configuration file. Yes, we´ll stick to InnoDB because of foreign key constraints.
2.1) Open the newly created file in notepad and replace the text:
# Table type which is used by default when creating new tables, if not
# specified differently during the CREATE TABLE statement.
default_table_type = MYISAMwith this:
# Table type which is used by default when creating new tables, if not
# specified differently during the CREATE TABLE statement.
default_table_type = InnoDB
#Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement, but MySQL converts
#them to lowercase on lookup. Name comparisons are not case sensitive
lower_case_table_names=2
2.2)
Note: This configuration file is for machines which have 4GB of memory installed. If yours don´t, locate and find the following variable on my.ini:
Change from
innodb_buffer_pool_size = 2GTo (suitable for 1GB RAM)
innodb_buffer_pool_size = 512M2.3) Save and close the file. Time to install the Mysql service.
3.0) Go to the commmand prompt you opened in the previous step and type:
mysqld --installAnd then (to start the service):
net start mysql
That´s it, you should have the service installed and running by now.
References
[1]
http://dev.mysql.com/doc/refman/5.0/en/windows-installation.htmlLabels: 64-bit, InnoDB, installation, mysql, mysql5, vista