Wednesday, July 4, 2012

Adminer – manage MySQL by single file, alternative of phpMyAdmin

June 1, 2010 by  
Filed under General

Adminer impressed me when I first tested it. It is superb alternative to the most famous MySQL web based administration tool phpMyAdmin. I just counted number of files in my current phpMyAdmin installation and I found there are 642 items. But Adminer is only a single file. You need to download it from there website [...]

How to change MySQL database collation?

October 21, 2009 by  
Filed under cPanel

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below: Enter your cPanel and click on the phpMyAdmin icon in [...]

Where the logs are stored in linux (cPanel)?

October 8, 2009 by  
Filed under cPanel

In a cPanel server, you may find logs are often stored differently comapring a control panel less server. Even Plesk saves logs in different paths. Here is a list of services and their log path that may help you finding the logs. Apache /usr/local/apache/logs/access_log /usr/local/apache/logs/error_log /usr/local/apache/domlogs/ MySQL /var/lib/mysql/hostname.err hostname should be resemble your hostname.

MySQL database import-export from Shell

September 2, 2009 by  
Filed under General

The control panels provide GUI for import / export databases. However, it is very easy doing the same from shell. Exporting Database mysqldump dbname > exportfile.sql This will export the database to exportfile.sql. You can optionally compress the file to save bandwidth during server to server transfer. Run the following command: gzip exportfile.sql Database Import [...]

Linux Hosting Control Panels

August 5, 2009 by  
Filed under cPanel, Ensim, Plesk, Webmin

A Control Panel is a very important factor that comes with web hosting service. Your control panel determines how accessible the features of the server are to you so as to maximize the benefits to your web site. Since a large number of hosts offer hosting on Linux platform, following is a run down of [...]

How to allow remote SQL connection to your site

August 4, 2009 by  
Filed under cPanel

Sometimes you may need to allow access of remote servers to your site’s mysql server. As mysql considers host for authentication anyone can’t connect from remote server unless allowed explicitly. You can grant remote MySQL in the following steps: – Login to cPanel – Click Remote MySQL from Databases section – Enter your connecting host [...]

What is cPanel?

August 2, 2009 by  
Filed under cPanel

cPanel is a unix based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site. cPanel utilized a 3 tier structure that provides functionality for administrators, resellers, and end-user website owners to control the various aspects website and server administration through a standard [...]