Category: MySQL

On DBs

Install Apache/PHP 7.2.5 on Fedora 28/27, CentOS/RHEL 7.5/6.9

This guide shows howto install Apache HTTP Server (httpd) with PHP 7.2.5 and following modules on Fedora 28/27/26, CentOS 7.5/6.9 and Red Hat (RHEL) 7.5/6.9 systems. OPcache (php-opcache) – The Zend OPcache provides faster PHP execution through opcode caching and optimization. APCu (php-pecl-apcu) – APCu userland caching CLI (php-cli) – Command-line interface for PHP PEAR […]

Install MySQL 8.0/5.7 on Fedora 28/27, CentOS/RHEL 7.5/6.9

Are you looking MariaDB 10.2/10.1/10.3 Install guide? MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest version 5.7 (5.7.22)/8.0 (8.0.11) on Fedora 28/27/26, CentOS 7.5/6.9 and Red Hat (RHEL) 7.5/6.9. This guide […]

c

cPanel Server : Restoring MySQL SimLink.

If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the

nginx, PHP 5.3 and FastCGI on CentOS 5.5, Fedora 13, Red Hat RHEL 5.5/6

This is guide howto install nginx, PHP 5.3 and FastCGI webserver with MySQL and/or PostgreSQL and Memcache support on Fedora 12 and Fedora 13, CentOS 5.5, Red Hat (RHEL) 5.5/6. nginx (engine x) is a robust, small and high performance http server, reverse proxy server and also mail proxy server. 1. Add and enable needed […]

H

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial is based on Falko Timme’s tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer

T

Turbo charging MySQL by setting up the query cache

To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell

M

Moving mySQL DBs between servers

Moving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one nicely portable text file. on a new server it takes mysql -uUSER -pPASSWORD txp_database <

T

Taking backup of mysql database using cron

Taking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :

H

How can I repair corrupt MySQL tables?

How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables.