“mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.” Installation: root@server [~downloads]# wget hackmysql.com/scripts/mysqlreport root@server [~downloads]#chmod 755 [...]
Archive for the ‘Mysql’ Category
script to show mysql status values
Posted in Mysql, OPTIMIZATION, SCRIPT on October 4, 2009 | Leave a Comment »
Upgrade mysql from 5.0.x to 5.1.30 with cPanel scripts
Posted in MIGRATION, Mysql on October 4, 2009 | Leave a Comment »
You can upgrade from 5.0.x to 5.1.30 with cPanel scripts edit /var/cpanel/cpanel.config and set mysql-version=5.1 then execute /scripts/mysqlup then run /scripts/easyapache and then /scripts/perlinstaller –force Bundle::DBD::mysql to reset the new install ERROR! MySQL manager or server PID file could not be found! Solved: This error is caused by the my.cnf file that comes from mysql4 [...]
Backup and Restore MySQL database
Posted in Mysql on January 10, 2009 | Leave a Comment »
How to backup and restore MySQL database: ====================================== Here are the commands to manually do it via shell, given you have root privilege: To dump the database onto a text file: mysqldump database_name > database_name.sql To import the data into a database: mysql database_name < database_name.sql Replace database_name with the name of your database.
Reset Mysql root password..
Posted in LINUX, Mysql on January 10, 2009 | Leave a Comment »
First, stop mysql server /etc/init.d/mysql.server stop Start mysql in safe mode /usr/local/mysql/bin/mysqld_safe –user=root –skip-grant-tables –skip-networking & Now the mysql will be running in the background in safe mode. You will be able to login as root by just using: mysql -u root Once you got in you can use the following commands to reset the [...]
Identifying slow MySQL queries
Posted in Mysql, OPTIMIZATION, SECURITY on January 7, 2009 | Leave a Comment »
MySQL can sometimes create big problems on a server when you have users abusing it. This article will teach you how to correctly identify the queries that are creating a problem for your server. MySQL can log those queries that are taking longer then X seconds but this future is not turned on by default. [...]
Install MySQL Performance Tuning Script
Posted in Mysql, OPTIMIZATION, SECURITY on January 7, 2009 | Leave a Comment »
Tuning the performance of MySQL can be a really hard job to do. There are many thinks to consider and no two servers are identical so there is no universal solution. Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records. For [...]
Create mysql db backup:
Posted in Mysql, SCRIPT on January 1, 2009 | Leave a Comment »
File: === dbbackup.sh Description: ======== A shell script to backup a MySQL database Features: ====== The script can create a MySQL dump, compress it then both store a copy in the server and send a copy to the defined email address Supported OS: FreeBSD and RedHat, should work with other distributions How to install: ========= [...]
Upgrade MySQL on cPanel servers.
Posted in Cpanel, MIGRATION, Mysql on January 1, 2009 | Leave a Comment »
MySQL and PHP upgrade on cPanel is a very simple process, here is a list of steps that needs to be taken to upgrade these two components: 1. Login to your WHM as root; 2. Go to WHM >> Server Configuration >> Tweak Settings, scroll down to “MySQL” section, switch radio button to “5.0″ and [...]
PostgreSQL installations
Posted in Cpanel, INSTALLATION, Mysql, SERVICES on December 31, 2008 | Leave a Comment »
Problem: ======= Postgres isn’t showing any errors on cpanel, because it does not return any error. The most common error is that postgres cannot connect with cpanel password. Resolution: ======= You can try just go to section OPTIONAL – SKIPING POSTGRES PERMISSION and then on Cpanel and change by Cpanel postgres password or, if it [...]
Upgrading PostgreSQL to 8.1
Posted in Articles, Mysql, SCRIPT on December 31, 2008 | Leave a Comment »
Warning: ===== First, do it by your risk and IF you know what your doing AND IF you do really need and AND IF your customers do not use postgres on this server yet. DO NOT UPGRADE IT ON PRODUCTION SERVERS UNLESS YOU’RE SURE ABOUT DOING IT. THERE IS NO WAY TO GO BACK!!!! ALSO, [...]
