Restore InnoDB database from RAW file (Window)

Posted on by
Reply

Note:  ensure the mysql version is same in both server, and also have the root password.

(1) create VM and install the same version of mysql that need to restore

(2) Stop the mysql service

(3) Restore the file as below to your VM

-database raw file (.frm files)
-mysql raw file
-ibdata1 (InnoDB data files)
-ib_logfile1 (InnoDB log files)
-ib_logfile0 (InnoDB log files)
-my.ini

(4) Start the mysql service
-in this step, you may discover the mysql service unable to start. Hence you need to confirm that all setting is same with the database previous host

(5) Dump the db out as .sql
-You need to use the previous host root password as your mysql is restore as previous host.

Done, you have save the world….

Reference:

MySQL

Install the Intermediate Certificate (IIS6 & IIS7)

Posted on by
Reply

(1) Click the Start menu and click Run…. Type mmc in the Run window and click OK to start the Microsoft Management Console (MMC).

(2) In the Management Console, select File then Add/Remove Snap In.

(3) In the Add or Remove Snap-ins dialog, click the Add button and then select Certificates.

(4) Choose Computer Account then click Next.

(5) Choose Local Computer, then click Finish.

(6) Close the Add or Remove Snap-ins dialog and click OK to return to the main MMC window.
If necessary, click the + icon to expand the Certificates folder so that the Intermediate Certification Authorities folder is visible.

(7) Right-click on Intermediate Certification Authorities and choose All Tasks, then click Import.

(8) Follow the wizard prompts to complete the installation procedure.

(9) Click Browse to locate the certificate file. Change the file extension filter in the bottom right corner to be able to select the file. Click Open after selecting the appropriate file.

(10) Click Next in the Certificate Import Wizard.

(11) Choose Place all certificates in the following store; then use the Browse function to locate Intermediate Certification Authorities. Click Next. Click Finish.

Done.

iftop installation step

Posted on by
Reply

iftop command displays real-time network bandwidth usage. It displays the network usage of a specific interface on the host. Using iftop you can identify which host is responsible for slowing down your network.

(1) First, ensure this 2 module is install in your server. If not, install it. (of course, your server need to have module “Development Tools” such as gcc)

yum install libpcap-devel
yum install libpcap

(2) Download the iftop source code to /usr/src

cd /usr/src
wget http://www.ex-parrot.com/~pdw/iftop/download/iftop-0.17.tar.gz

(3) Unzip and install it

gzip -d iftop-0.17.tar.gz
tar xvf iftop-0.17.tar
cd iftop-0.17
./configure
make
make install

Please visit iftop site for latest version.

How to disable auto FSCK

Posted on by
Reply

(1) open /etc/fstab

nano /etc/fstab

(2) edit the line that contains the filesystem and modify the last number in the row to ’0′, which disables fsck.

/dev/VolGroup/LogVol     /mountpoint      defaults    1 0

(3) Save it, done.

Note: Will not typically suggest disabling the on-boot fsck except in situations where the machine does not boot, the file system is extremely large, or the file system is on remote storage.