Install memcache for php 5.6.30

My environment: PHP: version 5.6.30 Xampp: Xampp version: 3.2.2 (x86) Xampp Directory: C:\xampp MariaDB: version 10.1.21 My problem: I use framework yii 1.1.15 to develop my application. I have problem with MemCache. I try to fix it. My Solution: Step 1: Download php_memcache-3.0.8-5.6-ts-vc11-x86.zip...

Migrate MyISAM tables to INNODB using mysqldump

In this article you will find information how to convert MyISAM tables to INNODB.  The procedure here is an offline procedure, i.e, you cannot have changes on the SOURCE database, while you do this. A better way could be to setup replication between the SOURCE and the TARGET, but that is not described here. On the source database In this example we dump out the database...

How to rename datafiles in Oracle 11g

[Problem]  I want to rename datafile E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_.DBF to E:\ORACLE\VNPT\DATAFILE\EXAMPLE.DBF [FIX] D:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 22 09:48:56 2016 Copyright...

How to fix "This installation package could not be opened..."

Describe: FIXED: Step 1: Start / Run / regedit Step 2: Browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem Step 3: Find Dword NtfsDisable8dot3NameCreation and Win31FileSystem Step 4: Modify them to 0 Step...

How to kill all session Xvnc

  Step 1: List all processes of Xvnc [root@VTGDB.COM tmp]# ps -ef | grep Xvncroot     112273      1  1 14:22 pts/0    00:00:00 /usr/bin/Xvnc :1 -desktop VTGDB.COM:1 (root) -auth /root/.Xauthority -geometry...

How to fix the Account Locked (Timed) Oracle

Step 1: Check status of Account: select username, account_status,profile from dba_users where username='APPUSER'; Step 2: Create an profile CREATE PROFILE APP_DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIME UNLIMITED CONNECT_TIME...

How to fix: Cannot grab required information(TMOUT) from /etc/profile

[PROBLEM] Cannot grab required information(TMOUT) from /etc/profile [FIXED] Edit file /etc/profile, add following line to end of file. vi /etc/profile # set a 5 min timeout policy for bash shell TMOUT=300 readonly TMOUT export TMOUT ...

How to set an expiration date for user' password on Linux

Step 1: Open file /etc/login.defs, change option for PASS_MAX_DAYS, For example: # Password aging controls: # #       PASS_MAX_DAYS   Maximum number of days a password may be used. #       PASS_MIN_DAYS   Minimum number of days allowed between password changes. #       PASS_MIN_LEN    Minimum acceptable password...

Installation Mysql, php, apache

My environment: OS Red Hat Enterprise Linux Server release 6.5 (Santiago) MySQL Version 5.1.73-community MySQL Community Server (GPL) PHP PHP 5.6.10 (cli) Htdoc Directory /u01/qlts/public_html Apache Configuration ...

How to fix Error Vietnamese font on Xampp

[Describe]:  [FIXED] Step 1: Open Xampp Control Panel, Click Config on MySQL Module Step 2: Open my.ini Step 3: Uncomment rows following and save file my.ini collation_server=utf8_unicode_ci character_set_server=utf8 skip-character-set-client-handshake character_sets-dir="C:/xampp/mysql/share/charsets" Step...