How to upgrade to MySQL 5.5

0

A step by step guide to upgrading to MySQL 5.5

Download the binary

$ cd /root/
$ wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.11-linux2.6-i686.tar.gz/from/http://mysql.llarian.net/
$ mv index.html mysql-5.5.8-linux2.6-i686.tar.gz

Backup the MySQL configuration

$ mkdir /root/mysql-5.1-conf
$ cp -R /etc/mysql/ /root/mysql-5.1-conf

Backup the data directory

We will be backing up the data in the form of SQL dump as well as by copying the data files over to a safe place, just to be 100% sure about the data not getting lost.

$ mkdir /root/mysql-5.1-data
$ cp -R /var/lib/mysql/ /root/mysql-5.1-data

Backup the data as SQL dump

Backup the mysql database separately and not with all the other databases, because we are going to need it before we restore all the databases.

$ mkdir /root/mysql-5.1-dump
$ mysqldump -u user_name -p --databases mysql > /root/mysql-5.1-dump/mysql.sql
$ mysqldump -u user_name -p --databases db_name > /root/mysql-5.1-dump/db_name.sql

Install the asynchronous I/O library

This is so that we can take advantage of the asynchronous I/O capability in the new InnoDB plugin that ships with MySQL 5.5

$ apt-get install libaio-dev

Untar the archive

$ tar xzvf mysql-5.5.8-linux2.6-i686.tar.gz

Copy or move the untarred MySQL directory to the installation directory

$ cp -R mysql-5.5.8-linux2.6-i686 /usr/local/
$ cd /usr/local/
$ ln -s mysql-5.5.8-linux2.6-i686 mysql

Remove the older version of MySQL

Now is the time to remove the older version of MySQL, in this case I assume the older version to be MySQL 5.1

$ apt-get remove mysql-server-5.1
$ apt-get autoremove
$ apt-get remove mysql-client
$ apt-get autoremove

Add the path to MySQL bin directory to the PATH variable

$ vim /etc/environment
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/mysql/bin"

Set the correct file and directory permissions on the MySQL installation directory

Setting correct permissions is very important, make sure that all the files except those under the data directory are owned by root. The data directory has to be owned by the user mysql.

$ cd /usr/local/mysql
$ chown -R mysql:mysql data

Create the socket directory

Here again, setting the correct permissions on the socket directory is very important, otherwise MySQL would not run.

$ mkdir /var/run/mysqld/
$ chown -R mysql:mysql /var/run/mysqld/

Copy the sample MySQL configuration file to the etc directory and setup the paths

$ cd /usr/local/mysql/support-files/
$ cp my-large.cnf /etc/my.cnf

Now edit /etc/my.cnf so that it has the following values:

user            = mysql
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr/local/mysql
datadir         = /usr/local/mysql/data
tmpdir          = /tmp
log_error       = /var/log/mysql/error.log

Copy the MySQL server startup script to the startup directory

The MySQL startup script has to be placed in the directory where all the startup scripts reside, so that MySQL starts on system startup. Make sure that you make the startup script executable, and update the rc.d database to notify the system about the presence of a new startup script.

$ cd /usr/local/mysql/support-files/
$ cp mysql.server /etc/init.d/mysql
$ chmod +x /etc/init.d/mysql
$ update-rc.d mysql defaults

Remove the MySQL files from the older version

Make sure you don’t delete files belonging to the new version we are installing.

$ rm -R /var/lib/mysql
$ rm -R /etc/mysql
$ rm -R /usr/lib/mysql

When starting the MySQL server for the first time after the new installation, it has to be started without the grants table, for two reasons. Firstly, because we want to retain the users and privileges data from the previous install of MySQL and secondly, because the schema of the grants table in MySQL 5.5 has changed.
So what we will do is start MySQL without the grants table, import the users and privileges data we backed up earlier in this guide and run the mysql_upgrade script that modifies the schema of the grants table to be in sync with that in MySQL 5.5. After that we will be able to run MySQL normally and have all the users and privileges same as in the previous version we had.

Start MySQL server without grants table.

$ mysqld --skip-grant-tables --user=mysql

Load the MySQL users and privileges data we backed up earlier

$ cd /root/mysql-5.1-backup/dump/
$ mysql < mysql.sql

Run the upgrade script so that everything gets upgraded to the version 5.5

$ mysql_upgrade

Stop the server and start it normally

$ /etc/init.d/mysql stop
$ /etc/init.d/mysql start

There you go, you have a MySQL 5.5 server up and running

Source http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mysql-5-5/
Google Chrome Sneak Preview

Google Browser “Chrome” Launching today.

0

Google, the popular search engine is launching its own browser called “Chrome” or Google Chrome. It would be launched on the 2nd of Sept 2008. It would be an open source browser which would be challenging Mozilla Firefox and Microsoft Internet Explorer for the browser market share.

Chrome would be a tabbed browser with enhanced javascript. A preview of what Chrome is like in the below picture.

I’ll provide more update as soon as i get the link to download the beta version tonight.

Official Link

Stay Tuned.

Free Bitdefender 2008 ( 180 Days license )

3

 

Original license for BitDefender suite

  • BitDefender AntiVirus 2008
  • BitDefender InternetSecurity 3008
  • BitDefender TotalSecurity 2008

Here

Hide Secret Files inside an Image ( .jpg )

0

In thisarticle we will hide a text message inside a picture. We have choose for this tutorial a text file named topsecret.txt and a picture photo.jpg.

1. Move your files you want to combine in a new folder, in our case C:\topsecret.

2. Add the file you want to hide into a new RAR archive (in our example named topsecret.rar).

3. WinRar created the archive in the folder where our files are located.

4. Open Command Prompt (Start -> Run…, type cmd and press Enter).

5. Go to the folder where your files are located, in this case C:\topsecret by using the cd command.

6. Now type copy /b photo1.jpg + topsecret.rar hotchick.jpg where photo1.jpg is the original picture, topsecret.rar is the file that will be hidden, and hotchick.jpg is the file which contains both.

7. If you open hotchick.jpg you will see the photo1.jpg image.

8. Try opening the file with WinRar (select All files).

9. Now you can see the text file that is hidden in the picture.

A simple solution to make this more secure, is to use encryption on the RAR file or set a password when your create it.

Copyright by Beijing Olympics.

Beijing Olympics Official Song “Beijing Welcome You / 北京欢迎你 ” with English/Pinyin Lyrics

1

Today is the day of Opening Ceremony of  Beijing Olympics 2008. Here i present to you the Theme Song along with the Lyrics in Pin yin and English. It means “Beijing Welcome You” or in Mandarin 北京欢迎你 ( Bei Jing Huan Ying Ni ).

Copyright by Beijing Olympics.

Copyright by Beijing Olympics.

Lyrics

迎接另一个晨曦,带来全新空气。陈天佳
Let’ s embrace another morning and enjoy its ever new air.
Ying jie ling yi ge chen xi, dai lai quan xin kong qi.

气息改变情味不变,茶香飘满情谊。刘欢
With the fragrance of tea, it smells different. But it feels great, full of friendship.
Qi xi gai bian qing wei bu bian, cha xiang tiao man qing yi.

我家大门常打开,开放怀抱等你。那英
Our door is always open. We are waiting for you open-armed.
Wo jia da men chang da kai, kai fang huai bao deng ni.

拥抱过就有了默契,你就会爱上这里。孙燕姿-Stefanie Sun
After a big hug, you’ll feel close with us. And surely you will love this place.
Yong bao guo jiu you le mo qi, ni jiu hui ai shang zhe li.

不管远近都是客人,请不用客气。孙悦
Our guests, no matter where you come from, please feel at home.
Bu guan yuan jin dou shi ke ren, qing bu yong ke qi.

相约好了在一起,我们欢迎你。王力宏-Wang Lee Hom
We promised to get together here. So welcome!
Xiang yue hao le zai yi qi, wo men huan ying ni.

我家种着万年青,开放每段传奇。韩红
We cultivate Chinese Evergreen in the garden. All the time, it is producing a new legend.
Wo jia zhong zhe wan nian qing, kai fang mei duan chuan qi.

为传统的土壤播种,为你留下回忆。周华健-Emil Chou
In the soil rich in traditions, we plant. Hope everything we plant here leaves you a great experience.
Wei chuan tong de tu rang bo zhong, wei ni liu xia hui yi.

陌生熟悉都是客人,请不用拘礼。梁咏琪
Our guests, no matter we’ve met before or not, please feel at ease.
Mo sheng shu xi dou shi ke ren, qing bu yong ju li.

第几次来没关系,有太多话题。羽泉
Even if you have been here for many times, you won’t feel bored ’cause we have vast new things for you.
Di ji ci lai mei guan xi, you tai duo hua ti.

北京欢迎你,为你开天辟地。成龙-Jackie Chan
Welcome to Beijing; we’ve done a lot for your visit.
Bei jing huan ying ni, wei ni kai tian bi di.

流动中的魅力,充满着朝气。任贤齐-Richie Ren
Its charm in ever changing is full of life.
Liu dong zhong de mei li, chong man zhe chao qi.

北京欢迎你,在太阳下分享呼吸。蔡依林-Jolin Tsai
Welcome to Beijing; let’s breathe together in the sunshine.
Bei jing huan ying ni, zai tai yang xia fen xiang hu xi.

在黄土地刷新成绩!孙楠
Let’s establish new records here in China.
Zai huang tu di shua xin cheng ji.

我家大门常打开,开怀容纳天地。周笔畅
Our door is always open. We are open armed, ready to embrace the world.
Wo jia da men chang da kai, kai huai rong na tian di.

岁月绽放青春笑容,迎接这个日期。韦唯
5000-year-old China is flashing a youthful smile, waiting for the day.
Sui yue zhan fang qing chun xiao rong, huan jie zhe ge re qi.

天大地大都是朋友,请不用客气。黄晓明-Huang Xiao Ming
Our guests, no matter where you come from, please feel at home.
Tian da di da dou shi peng you, qing bu yong ke qi.

画意诗意带笑意,只为等待你。韩庚-Hangeng from Super Junior
We paint pictures and write poems to express the joy for your coming.
Hua yi shi yi dai xiao yi, zhi wei deng dai ni.

北京欢迎你,像音乐感动你。汪峰
Welcome to Beijing; like moving music, our hospitality will warm your heart.
Bei jing huan ying ni, xiang ying yue gan dong ni.
让我们都加油去超越自己。莫文蔚-Karen Mok
Let’s try to challenge ourselves.
Rang wo men dou jia you qu chao yue zi ji.

北京欢迎你,有梦想谁都了不起。谭晶
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹。陈奕迅
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

北京欢迎你,为你开天辟地。阎维文
Welcome to Beijing; we’ve done a lot for your visit.
Bei jing huan ying ni, wei ni kai tian bi di.

流动中的魅力,充满着朝气。戴玉强
Its charm in ever changing is full of life.
Liu dong zhong de mei li, chong man zhe chao qi.

北京欢迎你,在太阳下分享呼吸。王霞, 李双松
Welcome to Beijing; let’s breathe together in the sunshine.
Bei jing huan ying ni, zai tai yang xia fen xiang hu xi.

在黄土地刷新成绩!廖昌永
Let’s establish new records here in China.
Zai huang tu di shua xin cheng ji.

北京欢迎你,像音乐感动你。林依轮
Welcome to Beijing; like moving music, our hospitality will warm your heart.
Bei jing huan ying ni, xiang ying yue gan dong ni.

让我们都加油去超越自己。张娜拉
Let’s try to challenge ourselves.
Rang wo men dou jia you qu chao yue zi ji.

北京欢迎你,有梦想谁都了不起。林俊杰-JJ Lin
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹。阿杜-Ah Du
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

我家大门常打开,开放怀抱等你。容祖儿-Joey Yung
Our door is always open. We are waiting for you open-armed.
Wo jia da men chang da kai, kai fang huai bao deng ni.

拥抱过就有了默契,你就会爱上这里。李宇春-Chris Li
After a big hug, you’ll feel close with us. And surely you will love this place.
Yong bao guo jiu you le mo qi, ni jiu hui ai shang zhe li.

不管远近都是客人,请不用客气。黄大炜-Huang Da Wei
Our guests, no matter where you come from, please feel at home.
Bu guan yuan jin dou shi ke ren, qing bu yong ke qi.

相约好了在一起,我们欢迎你。陈坤-Chen Kun
We promised to get together here. So welcome!
Xiang yue hao le zai yi qi, wo men huan ying ni.

北京欢迎你,为你开天辟地。谢霆锋-Nicholas Tse
Welcome to Beijing; we’ve done a lot for your visit.
Bei jing huan ying ni, wei ni kai tian bi di.

流动中的魅力,充满着朝气。韩磊
Its charm in ever changing is full of life.
Liu dong zhong de mei li, chong man zhe chao qi.

北京欢迎你,在太阳下分享呼吸。徐若瑄-Vivian Hsu
Welcome to Beijing; let’s breathe together in the sunshine.
Bei jing huan ying ni, zai tai yang xia fen xiang hu xi.

在黄土地刷新成绩!费翔
Let’s establish new records here in China.
Zai huang tu di shua xin cheng ji.

我家大门常打开,开怀容纳天地。汤灿
Our door is always open. We are open armed, ready to embrace the world.
Wo jia da men chang da kai, kai huai yi rong na tian di.

岁月绽放青春笑容,迎接这个日期。林志玲-Lin Ci Ling, 张梓琳
5000-year-old China is flashing a youthful smile, waiting for the day.
Sui yue zhan fang qing chun xiao rong, huan jie zhe ge re qi.

天大地大都是朋友,请不用客气。张靓颖
Our guests, no matter where you come from, please feel at home.
Tian da di da dou shi peng you, qing bu yong ke qi.

画意诗意带笑意,只为等待你。许茹芸, 伍思凯
We paint pictures and write poems to express the joy for your coming.
Hua yi shi yi dai xiao yi, zhi wei deng dai ni.

北京欢迎你,像音乐感动你。杨坤, 范玮琪-Fan Wei Qi
Welcome to Beijing; like moving music, our hospitality will warm your heart.
Bei jing huan ying ni, xiang ying yue gan dong ni.

让我们都加油去超越自己。游鸿明, 周晓欧
Let’s try to challenge ourselves.
Rang wo men dou jia you qu chao yue zi ji.

北京欢迎你,有梦想谁都了不起。沙宝亮, 满文军
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹。金海心, 何润东
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

北京欢迎你,为你开天辟地。飞儿-FIR, 庞龙
Welcome to Beijing; we’ve done a lot for your visit.
Bei jing huan ying ni, wei ni kai tian bi di.

流动中的魅力,充满着朝气。吴克群-Kenji Wu, 齐峰
Its charm in ever changing is full of life.
Liu dong zhong de mei li, chong man zhe chao qi.
北京欢迎你,在太阳下分享呼吸。5566, 胡彦斌-Anson Hu
Welcome to Beijing; let’s breathe together in the sunshine.
Bei jing huan ying ni, zai tai yang xia fen xiang hu xi.

在黄土地刷新成绩!郑希怡, 刀郎
Let’s establish new records here in China.
Zai huang tu di shua xin cheng ji.

北京欢迎你,像音乐感动你。纪敏加, 屠洪刚, 吴彤
Welcome to Beijing; like moving music, our hospitality will warm your heart.
Bei jing huan ying ni, xiang ying yue gan dong ni.

让我们都加油去超越自己。郭容, 刘耕宏, 腾格尔
Let’s try to challenge ourselves.
Rang wo men dou jia you qu chao yue zi ji.

北京欢迎你,有梦想谁都了不起。金莎, 苏醒, 韦嘉
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹。付丽珊, 黄征, 房祖明
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

北京欢迎你,有梦想谁都了不起。
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹。
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

北京欢迎你,有梦想谁都了不起。
Welcome to Beijing; people who have dreams are all bravo.
Bei jing huan ying ni, you meng xiang shei dou liao bu qi.

有勇气就会有奇迹!
If only you keep the courage, miracles will happen.
You yong qi jiu hui you qi ji.

Go to Top