CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

How to backup multiple mysql databases ? A very powerful shell script to backup your mysql databases totally free.. enjoy #!/bin/bash NOW=`date +"%Y-%m"`; BACKUPDIR="location/of/your/backup/dir/$NOW"; ### Server Setup ### #* MySQL login user name *# MUSER="user"; #* MySQL login PASSWORD name…

In this quick tutorial I will share some vim basics. Vim is a powerful text editor used in CLI (command line interface). As there are lots of configuration files in gnu/linux, which are all in clear text format, you’ll often need…

This how-to will show how to disable a user account under linux. This might be useful in the situation where you don’t want to permanently remove the user, but you just want it disabled and no longer able to use…

Today I wanted to change date and time on one of my server quickly from command line. I am aware with command line options but every time I want to do it, I need to read man page or help…

find is very famous and regularly used command to find files in the Linux/UNIX filesystem based on various different conditions. Let us review some practical examples of find command. All system administrators love this command, sometimes a life saver.. Syntax:…

By default, MySQL 5.x and above enables MySQL Binary Log. Keeping MySQL Binary Log will take up a lot of disk space for long run. Older MySQL Binary log can be removed in order to keep your hard disk space…

Don’t worry if you have forgotten / lost your mysql-server root (administrator) password. You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld)…