Category: MySQL

On DBs

Install phpMyAdmin 4.3.10 on Fedora 21/20, CentOS/RHEL 6.6/5.11

This is guide, howto install phpMyAdmin 4.3.10 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. phpMyAdmin needs web server with PHP and MySQL database. This guide uses Apache web server with PHP 5.6 or Nginx web server with PHP 5.6 (PHP-FPM) and MySQL 5.6 database server or MariaDB […]

LEMP on Fedora 28/27, CentOS/Red Hat (RHEL) 7.5/6.9

LEMP (Linux, Nginx, MySQL, PHP) server is extremely powerful setup behind any website or web based service. This guide is collection of Fedora/CentOS/Red Hat (RHEL), Nginx, MariaDB/MySQL and PHP (PHP-FPM) install guides. This guide (more specifically this guide parts) try to explain in more detail LEMP (Linux, Nginx, MariaDB/MySQL, PHP (PHP-FPM)) server environment installation. This […]

Install WordPress 4.1.1 on Fedora 21/20, CentOS/RHEL 7/6.6/5.11

This is guide, howto install WordPress 4.1.1 with Nginx or Apache on Fedora 21/20/19, CentOS 7/6.6/5.11 and Red Hat (RHEL) 7/6.6/5.11 servers. WordPress needs web server with PHP and MariaDB or MySQL database. This guide uses Apache web server with PHP 5.6 or Nginx web server with PHP 5.6 (PHP-FPM) and MariaDB 10/5.5 database server […]

LAMP on Fedora 28/27, CentOS/Red Hat (RHEL) 7.5/6.9

LAMP (Linux, Apache, MariaDB/MySQL, PHP) server is very powerful server setup behind any website or web based service. This guide is collection of Fedora/CentOS/Red Hat (RHEL), Apache, MariaDB/MySQL and PHP install guides. Today the Internet is full of instructions, which promises a LAMP server installation with a “One-Liner”, and so forth. In fact, these “One-Liner” […]

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.