Category: Uncategorized

Update information      Edit(Feb.9)    Edit2(Aug.2)

   Now, MySQL Community Server’s latest version is 5.6.10, and I heard this is the first GA. As I used MySQL5.5 until yesterday, I’ve upgraded to 5.6. I installed the previous version mysql-installer-community-5.5.29.0.msi, but this time I decided to use a Zip archive. I didn’t want to change the installation path name of MySQL because for easy configuration. So I took the next procedures. My server OS is still WindowsXP SP3(x86).

1. Changing our MySQL, we have to back up our current MySQL installation before performing a change. I backed up all my databases by phpMyAdmin. I stored the file my.ini and wrote down the installation path name of MySQL, C:Program FilesMySQLMySQL Server x.x.
2. Control Panel >> Administrative tools >> Services
   Select the MySQL Service name and stop
3. Control Panel >> Add or Remove Programs
   Select the MySQL Server 5.5 and remove

   When you remove it, the application data of MySQL still remains. So, your current databases are maybe all safe. But, if you want more safe, you’d better back up them.
   Upgrading one MySQL Zip archive to another, you can overwrite the existing installation. But, I used the msi to install the previous version, so, I need the uninstaller, if not, a MySQL zombie remains on the list of ‘Add or Remove Programs’.

4. Download and extract the file mysql-5.6.10-win32.zip
5. Remake the folder ‘MySQL Server x.x’ in my C:Program FilesMySQL, then, install the directories and files to the folder. You can install all of extract things. But, I only installed the next 5 directories and 2 files because I do not use others on my server by remote.
   • directories
     　　bin
     　　data
     　　include
     　　lib　　
     　　share
   • files
     　　COPYING
     　　my-default.ini

   I also installed my old my.ini to the same hierarchy of the new my-default.ini.

6. As I used the uninstaller, the MySQL Service was also deleted. So I need the new service.

   Run cmd.exe
   cd C:Program FilesMySQLMySQL Server x.xbin
   mysqld.exe –install

7. Control Panel >> Administrative tools >> Services
   Select the MySQL Service name and start

   If its ‘Startup Type’ is not ‘Automatic’, we have to change it to ‘Automatic’.

   When I made to start it, I had an error. orz.
    

8. I checked my event viewer. It gave me “MySQL: unknown variable ‘table_cache=256′”. At MySQL5.6 default I found ‘table_cache′ disabled.

   By the way, why did I set this option? I had no idea. Though I re-learned about ‘ table_cache, max_connections, open_files_limit’, I made no sense of it. Hmm.

   On the new server the default value of max_connections is 151 (<<--- You can know it by the command "show variables like 'max_connections'"). According to Upgrading from MySQL 5.5 to 5.6, between 5.5 and 5.6 have some Configuration Changes. They say ‘The idea behind autosizing’. So I deleted two lines about table_cache and max_connections in my old my.ini.

   Start the service again. Complete!!!

9. Run cmd.exe
   cd C:Program FilesMySQLMySQL Server x.xbin
   mysql_upgrade.exe

   I had the error.
   Got error: 1045: Access denied for user ‘root’@’localhost’ (using password: NO) when trying to connect
   FATAL ERROR: Upgrade failed

   So I did again.
   mysql_upgrade.exe –password[=password]

   Complete. But I have the warning next.
   Warning: Using a password on the command line interface can be insecure.

   My server configuration doesn’t make the command line data go the Internet. If your server permits your command line input to go outside and other users use the server, you maybe need more attentions.

   I restarted the MySQL service. mysql_upgrade — Check and Upgrade MySQL Tables says the need for it.

10. After this, I can access my blog. So I thought I made it, but, without reason I checked my event viewer again. Then, I found the warning next.
    TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).

    I think this is very common warning because Upgrading from MySQL 5.5 to 5.6 has the information about this. I added the next line to the [mysqld] area of the my.ini.
    explicit_defaults_for_timestamp=true

    I restarted the MySQL service. The warning has gone.

That’s it. Mission complete. I’m exhausted! (^_~;)

Edit(Feb.9):
   I had another warning on the log file xxxx.err. Like this.

• InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB’s internal memory allocator.

   I found “innodb_use_sys_malloc=on”. What does this warning say exactly?

   I turned “innodb_use_sys_malloc=off” and got the warning next.

• InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB’s internal memory allocator.

   As I got it probably said “no need to set the option innodb_additional_mem_pool_size”, I comment-outed innodb_additional_mem_pool_size in the my.ini. By the way, I found out MySQL 5.6 features made much progress gained a good reputation. It is wasted on a tiny blogger like me (^^;).

   I also had ‘IPv6 is not available.’ on the xxxx.err. It’s neither an error nor a warning, though…… I can not deal with it by myself. I wonder my provider is preparing for it.

Edit2(Aug.2):
   I wrote an article about a new installation of a MySQL5.6 on the post ‘To create a Wamp-like Web Server in Windows7-#3.‘.

   This morning at 8:00, temperature is 23℃(73℉). Wow, it’s cool. Autumn is approaching me. In the afternoon, of course, it heats up to over 30℃(86℉). Now, at 17:00, still 34℃(93℉). Hot, hot, hot.

   I watched the drama “4.50 From Paddington (1987)“. Until doing this, I liked Geraldine McEwan than Joan Hickson as Miss Marple. But after that, I began to appreciate Joan Hickson as this character. I always liked “4.50 From Paddington” when first I had read it. In this, Miss Marple is very old. Geraldine McEwan as Miss Marple is cute. But, Joan Hickson has something noble as the character.

   Besides, I discovered Jill Meager as the character Lucy Eyelesbarrow is good. Lucy Eyelesbarrow is a very unique character. Unless Miss Marple got such an old age, Lucy Eyelesbarrow had no chance created by Agatha, I think. Of course, the period when the novel was written probably influences her personality. She is a working woman and I feel she is the same class as Miss Marple and her friends. Don’t you think the world of Miss Marple has no working woman of the class as Miss Marple’s? Miss Marple herself is a rich and upper-class old lady, though she is less rich with the times.

   Lucy is an educated and smart, then she picks housekeeping as her job at that time(late 1950s). And that, she is a success. Incredible!!

   Until Sep. 30, a program ‘らいじんぐ産‘ was brought by NHK(日本放送協会). The program name ‘らいじんぐ産’ is a kind of puns. The pronunciation of ‘らいじんぐ産’ is similar to ‘rising sun’. On the other hand, the meaning of character ‘産’ is ‘bear’ or ‘be born’. When we use the word ‘産業’, it means ‘industry’ in English. So, ‘らいじんぐ産’ means ‘rising sun’ and ‘rising industry’, I think.

   By the way, last two episodes of this were about ‘Shinkansen (新幹線)‘. It cast my memory back to ‘Hikari (ひかり)’ and old ‘Blue Train‘.

   The first Tokaido Shinkansen train ‘Hikari’ traveled from Tokyo (東京) to Shin-Osaka (新大阪) on 1 October of 1964 at 210 km/h (130.5 mph). But my memory of Hikari isn’t between Tokyo (東京) and Shin-Osaka (新大阪) but between Tokyo (東京) and Hakata (博多). When the Okayama (岡山) to Hakata (博多) part opened on March 10 of 1975, I started to use ‘Hikari’ for coming home. At first, I took a ‘Hikari’ with excitement. But, as it took about 7 hours and was only possible during daylight travel, it was too boring and too wasting time for me. Because, at that time I was not a visitor for expecting Japan’s scenery but a student for returning home quickly.

   Until the part opening, for coming home I used Blue Train, its name maybe ‘Hayabusa (はやぶさ)’. Hayabusa was used the name as our unmanned spacecraft and this is still a fresh memory.

   Blue train was an overnight sleeper train and traveled from Tokyo to Nishi-Kagoshima (西鹿児島). Though I was stuck on Hayabusa all day long because of a typhoon, usually it delivered me to Hakata while my sleep. So, it was very convenient for me. Moreover, Hikari was more expensive than Hayabusa. :-p A plane was not in the options because of much expensive.

   Around to start working, Blue Train services was reduced and newbie’s vacation length was very short in Japan, I couldn’t get a ticket of Hayabusa for my returning home anymore, so I had no alternative but to use Hikari.   Now, if I go to Tokyo, I will take an plane.

   But I still love old Blue Train and my good old days. 🙂