Updating to MySQL 5.5.8

Super easy as I had MySQL 5.0.45 installed previously. Just went to http://www.mysql.com/downloads/ and grabbed the tar.gz file. After mysqldump’ing my old databases I simply ran these steps:

sudo mv ~/Downloads/mysql-5.5.8-osx10.6-x86_64.tar.gz /usr/local
cd /usr/local/
sudo tar -xvf mysql-5.5.8-osx10.6-x86_64.tar.gz
sudo ln -s /usr/local/mysql-5.5.8-osx10.6-x86_64 mysql
cd mysql
sudo chown -R _mysql .
sudo chgrp -R _mysql .
scripts/mysql_install_db –user=mysql
sudo chown -R root .
sudo chown -R _mysql data
sudo /usr/local/mysql/bin/mysqld_safe –user=mysql

I then reimported my data by opening a mysql prompt, creating the database, exiting, and then reimporting my data with mysql -u root -p db name < mysqldump file

Chris Lea provides a YUM repository for python26 RPMs that can co-exist with the ‘native’ 2.4 that is needed for quite a few admin tools on CentOS.

Quick instructions that worked at least for me:

$ sudo rpm -Uvh http://yum.chrislea.com/centos/5/i386/chl-release-5-3.noarch.rpm
$ sudo rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-CHL
$ sudo yum install python26
$ python26

to lock your resolv.conf

Bug Description

Binary package hint: network-manager

This bug causes name resolution to be painfully slow. If I manually remove the routers ip from resolv.conf it works normally, but next time the machine is booted the address gets added to the list again. (more…)

Note: In this post I’ll be showing how to install Apache, php, MySQL and phpMyAdmin (one by one) on Ubuntu 8.10 using Terminal. If you want to install them all at the same time with minimal fuss, I recommend you to read my post on installing LAMP.]

Installing Apache

1. Open Terminal (Application -> Accessories -> Terminal) and execute the following command:

sudo apt-get install apache2

2. When the setup is complete you can check if the Apache is working properly by pointing your browser to http://localhost. If you see the text “It works!”, it means Apache is working just fine.

3. Towards the end of the installation if you see a message like this inside Terminal, “Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName“, you can fix this by executing the following command. It will open Gedit (text editor).

gksu gedit /etc/apache2/conf.d/fqdn

4. When Gedit opens, type “ServerName localhost” inside the file and click Save. Then close the file.

Installing php5

1. Inside Terminal, execute the following command:

sudo apt-get install php5 libapache2-mod-php5

2. When setup is complete, you have to restart Apache so that php5 will work on Apache. Execute the following command in Terminal:

sudo /etc/init.d/apache2 restart (more…)

Make Yakuake autostart:

Open up your home folder; make sure you can see your hidden files.
Navigate to the .kde/Autostart folder and create a new text file: yakuake.
Paste this in the file:

#!/bin/bash
/usr/bin/yakuake

Start up your new Yakuake Terminal and press F12.

~/.kde/Autostart/
chmod +x yakuake

Next time you start Ubuntu Yakuake will be running. You just need to press F12 to access it.
To configure it you can right click on the Yakuake screen and use the menu.
The size of the window and other settings can be accessed by clicking the small down arrow at the bottom right of the screen.

Stopping to autostart mysql service

(firstly u must be sure to there is a<strong> /etc/init.d/mysql or mysqld</strong> )

# chkconfig --list | grep mysqld
mysqld          0:off   1:off   2:off   3:on   4:on   5:on   6:off
# chkconfig --level 345 mysql off
error reading information on service mysql: No such file or directory
# chkconfig --level 345 mysqld off
# reboot

chkconfig

The chkconfig command can also be used to activate and deactivate services. If you use the chkconfig –list command, you will see a list of system services and whether they are started (on) or stopped (off) in runlevels 0-6 (at the end of the list, you will see a section for the services managed by xinetd.
(more…)

How to remove a directory in linux console

first look at rm command .
(more…)

(more…)

if you get an error like this:
(more…)