MySQLTuner is a Perl script that helps to analyzes your current MySQL configuration and give some recommendations to adjust your settings to increase the performance and stability. The MySQLTuner output is separated into 5 parts as below: General Statistics Storage Engine Statistics Security Recommendations Performance Metrics Recommendations You should go through all parts especially on [...]
If you want to change,update or reset your MySQL account (ex: Root) password under Microsoft Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE, … you can use one of 3 following methods below: Method 1. Using MySQL command: It’s my favorite way. MySQL stores all account (includes root account ) [...]
This example will help you know how to backup one or multi MySQL database using mysqldump command. If your database is very big, you may need to compress the backup sql file. To do that, you can use gzip compression to pipe the output to gzip then you will get the output as gzip file. [...]
This shell script will backup all current Mysql databases, compress(gzip) them and put them in a new folder named by current date (one directory per database). #!/bin/bash PATH=/usr/sbin:/sbin:/bin:/usr/bin MyUSER=”your_db_user” MyPASS=”your_db_password” MyHOST=”your_db_host” SUBFOLDER=”$(date +”%Y-%m-%d”)” DEST=”/somewhere/on/your/server” MDB=”$DEST/backup/$SUBFOLDER” if [ ! -d $MDB ] then mkdir -p $MDB >/dev/null 2>&1 && echo “Directory $MDB created.” || echo “Error: [...]
Creating a job to schedule backup databases automatically is a very important task for each database administrator. Database is always irreplaceable and is the heart of all online business therefore this process must be the first thing in the process of database administrating to ensure it’s super safe. In this tutorial, I’ll share with you [...]
This is the fourth part of the Installing WordPress From the Ground Up series. Previously I discussed installing MySQL, the FastCGI extension, and PHP. This article will show the exact steps for setting up phpMyAdmin on Windows and IIS 6.0. phpMyAdmin is a web-based tool for managing MySQL database servers. I would go so far [...]
Sometimes it may happen that mysql won’t start returning as an error: “the partition is too full with/var/lib/mysql”. This error can be caused by excessive size often of the mysql log files that fill up all available space dedicated to it. We can try to resolve this error with simple steps: First, we clean all [...]
Here is a simple shell script tested on CentOS / RHEL / Fedora / Debian / Ubuntu Linux. Should work under any other UNIX liker operating system. It will check for httpd pid using pgrep command Pgrep command pgrep looks through the currently running processes and lists the process IDs which matches the selection criteria [...]
When you cannot monitor your server for service availability, it is better to take help of automated monitor and restart utility. Last 4 days I was away from my server as I was enjoying my vacation. During this time due to load my lighttpd webserver died but it was restarted automatically within 2 minutes. I [...]
With a considerable number of webmasters switching to Virtual Private Servers (VPS) from shared hosting these days and preferring them over costlier fully dedicated servers, memory and resource optimization has become a burning issue. Most VPS packages being bought these days, have dedicated memory constraints of 128MB to 256MB. Apache and MySQL are known to [...]
