RAID1 configuretion in Ubuntu 8.04 LTS server and centos

Dear friends,

Now I am telling you how to create RAID1 or other RAID partition in Centos or other linux os using RAID software .

1> Connect fresh hard drive 2 or 3 it is up to you . But less then 2 .
2> Boot from the CD. (Centos or ubuntu other.)
3> When you boot from CD then you see there free space . Then click to RAID option.
4> And select " Create a software RAID partition" .
5> Add partition . " Uncheck 1st hard drive and in a size option put boot partition size like 200 MB"

6> And Click to Force to be primary partition. " Check mark it.
7>Then again click to 2nd hard drive and select RAID option .
8> Select " Create a software RAID partition".
9> Add partition . " Uncheck 2nd hard drive and in a size option put boot partition size like 200 MB again ".
10> And Click to Force to be primary partition." Check mark it."
11> There you see 2 partition that type is Software RAID.
12> Select that one partition and Click to RAID option again .
13> Select Create RAID device [default=/dev/md0].
14> Mount point = /boot
15> File system type = ext3
16> RAID Device = md0
17> RAID Level = RAID0 or RAID1
18> After that select all free space in 1st hard drive and create RAID partition.
19> Select free space in 2nd hard drive and create RAID partition.
20> Select RAID option again and Select Create RAID device.
21> There you see partition type then select there Physical LVM option.
for both hard drive .
22> After that click to LVM option.
23> Here you have to create "swap partition and root "/" partition".
24> And Start installation.
25> After finish installation. Loging to root .
26> Open terminal and type there "grub".
27> device (hd1) /dev/sdb
28> root (hd1,0)
29> setup (hd1)
30 > quit
31> Now you can check your both hard drive is working.

Open that 2 URL and try it .
http://www.centos.org/docs/5/html/Deployment_Guide-en-US/s1-raid-config.html
http://www.howtoforge.com/how-to-install-ubuntu8.04-with-software-raid1


jitendra jha

Force Fully mount NTFS partition in Linux

Hello friends,

how to force fully mount "ntfs partition " in linux or ubuntu.

mount -t ntfs /dev/sda5 /media/hard1 -o force
/dev/sda5 is hard disk name run fdisk -l command and check it .
/media/hard1 is mount point /hard1 is folder that create in /media.

Thanks

jitendra jha

My Sql server Data restore and Take Data Backup

friends,
If you want to take dump of data and want to store data in mysql server then try this .
Store (.dump or .sql files ) in My Sql server
1> mysql -u root -p
or mysql -A;
2> mysql> SOURCE location of data file
SOURCE /home/jiten/Desktop/backupfile.sql or .dump
3> show databases;
4> use data base name;
use mysql;
5>show tables;
6>If you want to see schema of the table
describe table name;
describe text_class;
7> If you want to select all data from table
select * from table name;
select * from text_class;
Other command if you do not want to connect MySql server
1> mysql -h DBHOST -u DBUSER -pDBPASS DBNAME <>
mysql -h "localhost or server ip or server name" -u "user name root or other" -p "user password " data base name " mysql or other " < data name that data you want to store in data base " data.sql or backup.dump"

Take Data Backup in Mysql server to other place


1> mysqldump -u [Username] -p [password] [databasename] > [backupfile.sql]
mysqldump -u {root or jiten}-p{password} {jiten or mysql} > {jitenback.sql}

Thanks
jiten jha

MySql Administrator for Get GUI

Download
Mysql administrator http://dev.mysql.com/downloads/gui-tools/5.0.html
1 > Generic x86 Linux TAR (bundled dependencies) this one
2> tar zxvf mysql-gui-tools-5.0r12-linux-i386.tar.gz
3> cd mysql-gui-tools-5.0r11b-linux-i386
4> ./mysql-administrator --update-paths
5> ./mysql-administrator
6> open that folder there you see mysql desktop icon click that icon and you get mysql administrator GUI mode.

2nd option

1> aptitude install libpcre3-dev libmysqlclient15-dev libglib2.0-dev libxml2-dev

libglade2-dev libgtkmm-2.4-dev g++

2> cd mysql-gui-common
3> ./configure
4> make
5> make install
6> cd ../mysql-administrator
7> ./configure
8> make
9> make install
Goto that folder and click to mysql administrator desktop icon.

Do that and you get mysql administrator GUI .

Magento Installation

Megento installation is so easy and you run it so easy .

Down load Magento form http://www.magentocommerce.com/download/noregister
down load
magento-1.3.2.1.tar.gz
magento-sample-data-1.1.2.tar.gz

download that 2 tar files.
Install some software
apt-get install apach2 mysql-server php5 php5-mysql php5-curl php5-gd php5-mcrypt php5-cgi

After install
open
vim /etc/php5/apache2/php.ini
and find
memory_limit = 256M
save that file

open
vim /etc/hosts
127.0.0.1 www.example.com

$ cp -rf magento -1.3.2.1.tar.gz magento-sample-data-1.1.2.tar.gz /var/www
$ cd /var/www
$ tar -xfv magento-1.3.2.1.tar.gz
$ tar -xvf magento-sample-data-1.1.2.tar.gz

mv magento-sample-data-1.1.2/media/* magento/media/
mv magento-sample-data-1.1.2/magento_sample_data_for_1.1.2.sql magento/data.sql
chmod o+w var var/.htaccess app/etc
chmod -R o+w media

open mysql
mysql -u root -p
password=

mysql>create datebase magento;

mysql -h DBHOST -u DBUSER -pDBPASS DBNAME <>

mysql -h localhost -u user name -p user password data base name < style="font-style: italic;">
./pear mage-setup .

./pear install magento-core/Mage_All_Latest-stable

It will take some time and magento works
open firefox and other broser
type there
www.example.com/magento
after that it is ask
agree check it
ask mysql user name and password
country name and country money.
then you get two option
Frant hand and back hand
if you click back hand then
user name = admin
password =123123

ok

Thanks
jiten jha

How to get GUI in mysql

Easy to get mysql GUI.

go to terminal > login to super user "su" > apt-get install phpmyadmin

then it is asking to select option to select.
apache2
apache
and two more

select all that and finish it

you have to install apache2 also
apt-get install apache2

open firefox or other browser
type there
http://localhost
when u press enter then it is tell "IT'S WORKS"
that mean apache is working
then
open firefox and other browser

http://localhost/phpmyadmin
then u get user name and password screen
there you have to put mysql user and password
you get GUI mysql

Case sensitive problem in Mysql table

if you want to remove case sensitive option in mysql table then go to /etc/mysql/my.cnf
vim my.cnf
open that file and find that line
[mysqld]
Write there
lower_case_table_names=1
then table in mysql if your mysql not loading table then you put "2" in place of "1".
Then it is work.

Thank
jiten jha