MySQL dump or SQL backup from Linux

#mysqldump -u $uer_name -h $host_name –p$password $database_name | gzip -9 > file_name.sql.gz   ::::::::::::::::::::vi mydump.sh::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::   now=”$(date +’%d-%m-%Y’)” mysqldump -u $uername -h $hostname -p’Pawwword’ dbName | gzip -9 > /var/www/db_backup/db_name$now.sql.gz mysqldump -u $uername -h $hostname -p’Pawwword’ dbName | gzip -9 Read More …

How to setup static ip in centos

## Configure eth0 # # vi /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=”eth0″ NM_CONTROLLED=”yes” ONBOOT=yes HWADDR=A4:BA:DB:37:F1:04 TYPE=Ethernet BOOTPROTO=static NAME=”System eth0″ UUID=5fb06bd0-0bb0-7ffb-45f1-d6edd65f3e03 IPADDR=192.168.1.44 NETMASK=255.255.255.0 ## Configure Default Gateway # # vi /etc/sysconfig/network NETWORKING=yes HOSTNAME=centos6 GATEWAY=192.168.1.1 ## Restart Network Interface # /etc/init.d/network restart ## Configure DNS Server Read More …