mysql dump and restore

Dump all mysql data

mysqldump --user=XXXXXXXX --password=XXXXXXX -A > /PATH/TO/DUMPALL.SQL

Dump Individual or Multiple MySQL Databases

mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 > /PATH/TO/DUMPDB_NAME1.SQL

Dump only certain tables from a MySQL Database

mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPTABLE_NAME.SQL

Restore the database

mysql --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPALL.SQL

How to change the host name in linux Centos

1. login as root user

su -

2. type following command

echo “newhostname” > /proc/sys/kernel/hostname

3. Logout and re-login

how to extract bzip2 or gzip with tar command

To extract bzip2
-tar -jxvf file.tar.bz2

To extract gz
-tar -zxvf file.tar.gz