Backup Mysql Database dengan Command Line

For those who looking for way to backup mysql database,
you can use mysqldump to backup mysql database.

Below is the script example to backup mysql database in command line:-

$ mysqldump -h localhost -u username -p database_name > backup_db.sql

If your mysql database is very big, you might want to compress your sql file.
Just use the mysql backup command below and pipe the output to gzip,
then you will get the output as gzip file.

$ mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz

If you want to extract the .gz file, use the command below:-

$ gunzip backup_db.sql.gz
By yonaldi on April 2, 2011 | Knowledge | A comment?

Install dan Configurasi PPTPD di Centos 5

 

Apa itu VPN? (Virtual Private Network) hmmm..dari bahasanya saja sudah jelas “Private” artinya ya personal/privasi  jadi membuat sebuah jaringan dengan jalur private untuk menjaga keamanan data dari network public seperti internet, teknologi VPN yang sering digunakan antara lain P2TP, PPTP dan juga IPSec, apa bedanya sih? tujuannya sih sama cuma beda teknologi, kalau P2TP menggunakan port UDP dengan port 1701 sedangkan PPTP Port TCP 1723…ya lebih kurang gituh deh hehehe,..selanjutnya tanya om guggle aja. More…

By yonaldi on March 30, 2011 | Knowledge | A comment?

DNS BIND Zone Transfers and Updates

This chapter describes all the statements available in BIND 9.3.x relating to zone transfers and Updates. Full list of statements. More…

By yonaldi on March 27, 2011 | DNS | A comment?

19 ffmpeg commands for all needs

ffmpeg is a multiplatform, open-source library for video and audio files. I have compiled 19 useful and amazing commands covering almost all needs: video conversion, sound extraction, encoding file for iPod or PSP, and more. More…

By yonaldi on | Knowledge | A comment?

Network and IP address calculator

IP Multicast address ranges

All multicast addresses can easily be recognized because they start with the bit pattern “1110″.

224.0.0.0 - 224.0.0.255 <em> Well-known multicast addresses, control channels</em>
224.0.1.0 - 238.255.255.255 <em> Globally-scoped (Internet-wide) multicast addresses</em>
239.0.0.0 - 239.255.255.255 <em> Local multicast addresses</em>

Special and private address ranges

Private address ranges are not routed on the Internet and can be freely allocated in any private network. NAT (network address translation) is required when connecting such a network to the Internet.

Private network addresses (RFC1597/RFC1918 addresses):

10.0.0.0 - 10.255.255.255  <em>A 24-bit block, /8, class A network</em>
172.16.0.0 - 172.31.255.255  <em>A 20-bit block, /12, set of 16 contiguous class B network numbers</em>
192.168.0.0 - 192.168.255.255  <em>A 16-bit block, /16, set of 255 contiguous                                 class C network numbers</em>

Special addresses:
127.0.0.0 – 127.255.255.255 Special address range for the localhost. You can normally not use those addresses for anything else. 127.0.0.1 is generally assigned to the loopback device
0.0.0.0 Special host address commonly reserved for the default route


Overview of common subnets and masks

Mask Hosts  Usable Netmask          Hex Mask
/30  4      2      255.255.255.252  fffffffc  this is 1/64 of a Class C net
/29  8      6      255.255.255.248  fffffff8  this is 1/32 of a Class C net
/28  16     14     255.255.255.240  fffffff0  this is 1/16 of a Class C net
/27  32     30     255.255.255.224  ffffffe0  this is 1/8 of a Class C net
/26  64     62     255.255.255.192  ffffffc0  this is 1/4 of a Class C net
/24  256    254    255.255.255.0    ffffff00  this is a Class C net
/23  512    510    255.255.254.0    fffffe00  these are 2 Class C net
/22  1024   1022   255.255.252.0    fffffc00  these are 4 Class C net
/21  2048   2046   255.255.248.0    fffff800  these are 8 Class C net
/20  4096   4094   255.255.240.0    fffff000  these are 16 Class C net
/19  8192   8190   255.255.224.0    ffffe000  these are 32 Class C net
/18  16384  16382  255.255.192.0    ffffc000  these are 64 Class C net
/17  32768  32766  255.255.128.0    ffff8000  these are 128 Class C net
/16  65536  65534  255.255.0.0      ffff0000  these are 256 Class C net = Class B net
By yonaldi on March 25, 2011 | Knowledge | A comment?

Install module tambahan apache dengan apxs

apxs (Apache Extension Tool)

Adalah program bantu untuk membangun dan menginstal modul-modul tambahan untuk apache HTTP server. Apxs melakukannya dengan membangun Dynamic Shared Object (DSO) dari satu sumber atau lebih sehingga dapat dimuatkan pada Apache server lewat paramater LoadModule dari modul mod_so (lihat bagian modul Apache yang telah dibahas sebelumnya). Misalnya untuk menambahkan modul foo (mod_foo.c), cukup ketikkan :

$ apxs -i -a -c mod_foo.c

Pilihan -i berarti menginstal, -a adalah otomatis menjalankan modul, -c berarti kompilasi pada saat instalasi. Untuk pilihan-pilihannya secara lengkap, tersedia dalam manual apxs.

$ man apxs

Source : http://kambing.ui.ac.id/bebas/v01/DLL/ServerLinux/node122.html

By yonaldi on March 24, 2011 | Knowledge | A comment?

Real-time Transport Protocol (RTP) Multicast Streaming

Network Base Padang TV Streaming Station…

By yonaldi on | Knowledge | A comment?

Using ntp with Red Hat Linux/Fedora Core

Here are the steps to configure Network Time Protocol (ntp) with Red Hat Linux/Fedora Core.

1. Select time servers. I recommend using three ntp servers from pool.ntp.org; you may specify your country code when selecting servers from the ntp pool for the most accurate results. Please see http://www.pool.ntp.org/ for more information. More…

By yonaldi on March 21, 2011 | Knowledge, Linux Shell Scripts | A comment?

Installasi ffmpeg dengan auto installer…

Untuk membuat server streaming seperti youtube, clipshare, atau sejenisnya diwajibkan terlebih dahulu meng-install ffmpeg dan berbagai macam codec untuk kebutuhan conver, record, dll. Sekarang tidak lagi susah-susah dan memakan waktu lama hanya  sekedar menginstall ffmpeg di server linux cukup dengan auto installer yang sudah di sediakan di
URL : http://www.ffmpeginstaller.com/
Mudah-mudahan info ini berguna buat rekan-rekan linuxer dimanapun berada, salam.

By yonaldi on March 11, 2011 | Init Scipts Centos, Knowledge, Linux Shell Scripts | A comment?

Howto: Linux Add User To Group

How can I add a user to a group under Linux operating system?

You can use the useradd or usermod commands to add a user to a group. The useradd command creates a new user or update default new user information. The usermod command modifies a user account i.e. it is useful to add user to existing group. There are two types of group. First is primary user group and other is secondary group. All user account related information is stored in /etc/passwd, /etc/shadow and /etc/group files to store user information. More…


DNS
Init Scipts Centos
Knowledge
Linux Shell Scripts
Old Archive