Linux
Rsync using ssh non-standart port ssh
Before we start to explain deep, let me introduce rsync What is Rsync ? rsync is a file transfer program for Unix systems. rsync uses the “rsync algorithm” which provides a very fast method for bringing remote files into sync. It does this by sending just the differences in the files across the link, without … Continue reading
Howto: Install PHP Oracle / module php-oci8 on Linux
If you are using Oracle database and you want to connect, in here you can find how to install module php-oci8. In this how to you can use Oracle’s Instant Client and php oci8 module from pear. Download the Linux Basic and the SDK packages from here. At the time of this writing, filename are … Continue reading
Export MySQL data to CSV
Melakukan export data MySQL ke CSV sangat mudah di lakukan melalui CLI (Command Line Interface), untuk langkah ini kita mempunya 2 cara, tinggal pilih saja mana yang menurut Anda gampang dilakukan. Langkah 1: select columns INTO OUTFILE ‘/path/to/output.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘n’ from table [where clause] Langkah … Continue reading
Thunderbird Get MS-Exchange Global Address List
I’m using Thunderbird as Mail User Agent. Now i want to get Global Address List with my Thunderbird. As we know Active Directory using LDAP. To setting up Thunderbird open Tools > Address Book
Exporting Data with the SELECT … INTO OUTFILE Statement
Berikut syntax untuk membatu dalam melakukan dump database, tetapi kita dapat menentukan field-filed yg kita butuhkan, dengan menggunakan SELECT dengan INTO OUTFILE output_file. Ikuti langkah berikut ini untuk mengexport table data_tbl ke dalam file data.txt. mysql> SELECT * FROM data_tbl -> INTO OUTFILE ‘/tmp/data.txt’; Output dari perintah diatas akan membuat file /tmp/data.txt. Jika ingin outpunya … Continue reading
Linux Output Display via Console RS232
In the office now being POC avocent for ACS products, which supposedly he can capture the output from linux. After reading read the documentation of the Linux-Serial finally found it, how to make Linux not just to the monitor output (VGA Card) but via RS232 Console (ttyS0). 1. Make sure your system support serial port. … Continue reading
Remove MySQL Binary Log Files Eating Lots of Disk Space
By default, MySQL 5.0 and above enables MySQL Binary Log. Keeping MySQL Binary Log might take up a lot of disk space for long run. Older MySQL Binary log can be removed in order to keep your hard disk space free. MySQL Binary Log stores query event such as add, delete and update in a … Continue reading
Repair MySQL Replication Duplicate Entry Error
We have 2 servers that will be configured as Circular Replication. It means both servers act as master and slave to another server. And Master server was going down because hardware failure and need restart Master server. When Master server is going up, repication with slave is not running. Check replication on slave mysql> SHOW … Continue reading
Adding nodes to a GPFS cluster using use command mmaddnode, mmlsnode and mmlscluster.
You can add nodes to an existing GPFS cluster by issuing the mmaddnode command. The new nodes are available immediately after the successful completion of this command. You must follow these rules when adding nodes to a GPFS cluster: * You may issue the command only from a node that already belongs to the GPFS … Continue reading
Linux Ethernet Bonding
Setelah sekian lama jadi pengen nulis lagi di blog yg tak seberapa ini, saat ini topic yg akan kita bahas Linux Ethernet Bonding yaitu menggabungkan dua buah atau lebih ethernet menjadi 1 device bond. Mengapa kita harus mem-bonding ethernet? Jawabnya dengan bonding ethernet kita bisa memaksimalkan network jika terjadi failure, biasanya digunakan untuk mesin-mesin yg … Continue reading