Assuming you already have mysql server installed on your machine, the reason you are installing phpmyadmin is to ease your administration of your MySQL like database creation and deletion, create/alter/drop/view tables and...
Tag - tips
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...
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...
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...
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...
How to check if perl module is installed? A. Checking if Perl Module is Installed This is important on checking if a given perl module is already installed or not. Code: #perl -MModule::Name -e 1 if present, no errors...