There are ways to sync two MySQL tables in a non-GUI method such as mysql triggers or by Maatkit’s MySQL Table Sync, but it’s not that user-friendly. Of course, if you want the GUI-type, there’s always the...
Category - Quick Tips & Tricks
linux tips and tricks
I had the chance to work as a systems administrator in an e-commerce company and they have Linux dedicated servers leased/purchase from a hosting provider. Dedicated servers compared to a shared hosting is you have full control...
In this tutorial, we will be cloning PC desktop machines using an opensource tool called “G4U”. g4u (“ghosting for unix”) is a NetBSD-based bootfloppy/CD-ROM that allows easy cloning of PC harddisks to...
Here’s one trick to do that: Step 1. Install FreeTDS FreeTDS Website: choose FreeTDS source distribution Compile parameter: –prefix=/usr/local/freetds –enable-msdblib Then, copy /etc/ld.so.conf, to...
Want to test your Asterisk PBX system if it can sustain load and large traffic? Then you can use this tool. Sipp is a performance testing tool for the SIP protocol. Its main features are basic SIPStone scenarios, TCP/UDP...
These are the steps on adding additional hard drives on a pre-installed Linux server. Drives will be detected and can be checked thru the “dmesg” command. [root@localhost ~]#fdisk /dev/cciss/c0d1 press n to create...
1.compile cronolog () and install it on /usr/local/sbin 2. backup orig /usr/local/apache-tomcat-5.5.20/bin/catalina.sh on /root 3. edit lines on catalina.sh from org.apache.catalina.startup.Bootstrap “$@” start...
Quick tip in backing up and restore your MySQL database: Backing up and Restoring MySQL database Backing up database: Syntax: mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] o [username] -database...
Setting up mysql password is one of the essential task in systems administration Note: Linux/Unix login root account for your operating system and MySQL root are different You can use the built-in “mysqladmin” command to...
Finding CPU utilization is one of the important tasks in systems administration. There are built-in and 3rd party tools that you can use to perform this task. 1. top – displays Linux tasks this is the most common command used...