Install ImageMagick on CentOS

ImageMagick® is a software suite to create, edit, compose, or convert bitmap images. It can read and write images in a variety of formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PNG, Postscript, SVG, and TIFF. Use ImageMagick to resize, flip, mirror, rotate, distort, shear and transform images, adjust image colors, apply various special effects, or draw text, lines, polygons, ellipses and Bézier curves.

Make sure that the required dependencies are installed:

yum install -y ImageMagick ImageMagick-devel


How to Start-Stop MySQL Server on CentOS Server

This small post is to explain how you can start/stop/restart MySQL server from command line on CentOS Server.
Stop MySQL Server

# /etc/init.d/mysqld stop
Start MySQL Server

# /etc/init.d/mysqld start
Restart MySQL Server

# /etc/init.d/mysqld restart
Hope you find this small tip useful


Restore MySQL Database from FileSystem Backup

Always backup your  MySQL database with mysqldump but if you didn’t you can restore it from file system.

If your backup include the /var/lib/mysql directory, if so then you should be able to restore the database. Each database is contained in a separate subdirectory off /var/lib/mysql, so look for one named with the name of your database (WordPress or any other). To restore it, shutdown the mysql server first

sudo /etc/init.d/mysql stop

Copy the backup-ed directory into the same location on your new server, then restart mysql server

sudo /etc/init.d/mysql start

Note:- that its much better to take actual database dumps using the mysqldump command than to rely on this method. so for the future, you should schedule something like this:

mysqldump -h host -u user -ppassword --databases database1 database2 > myfile.dump

 


Disk Management in Windows 2012 R2

In Windows Server 2012 R2 I to find the option to reassign the drive letter for a CD/DVD drive where the disks are normally managed Run diskmgmt.msc just like previous versions of Windows.


Group Policy to Turn Off Display

To turn off the user’s monitor/display to save power and extend monitor life using Group Policy & Active Directory, consider the following group policy setting:

 

Computer Configuration > Policies > Administrative Templates > System > Power Management > Video and Display Settings > Turn Off the Display (Plugged In or On Battery)


Lock screen using Group Policy without setting a screen saver server 2012

 

To lock screen of workstation  using Group Policy without setting a screen saver, after certain time screen will be locked.

 

Computer Config > Policies > Windows Settings > Security Settings > Local Policies > Security Options > “Interactive logon: Machine inactivity limit”