
How to check MySQL query caching status on your linux server?
Login to your server as root. On mysql prompt fire the following command: mysql> SHOW VARIABLES LIKE ‘%query_cache%’; This will result the …
Login to your server as root. On mysql prompt fire the following command: mysql> SHOW VARIABLES LIKE ‘%query_cache%’; This will result the …
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser. An E-Mail has …
Refer the following steps:- Create / open a new PHP File 1) new site 2) Yes I want to use server technology 3) which server …
Copying MySQL Databases to another server If you are using MySQL 3.23 or later, you can copy the .frm, .MYI, and .MYD files for MyISAM …
Solution mysql_fix_privilege_tables — Upgrade MySQL System Tables Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to …
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, …
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions …
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Solution Hello Guys! Here you can find some common cPanel scripts which are useful for the task given below. Common cPanel /Scripts Install Zend Optimizer …