The basic installation of MySQL Server provides a great command line utility to take backup of MySQL databases The ‘mysqldump‘ command is used for creation “dumps” of databases managed by MySQL. These dumps are just files with all the SQL commands needed to recreate the database. Backup a Database Use the following command to backup […]
mysql
Checking MySQL Replication Status
The most common task when managing a replication process is to ensure that the replication is taking place and that there have been no errors between the slave and the master. The primary statement for this is ‘SHOW SLAVE STATUS‘, which must be executed on each slave. mysql> SHOW SLAVE STATUS\G The key fields from […]
HowTo: Install LAMP on CentOS/RHEL
In this guide, I will show you, how to install LAMP (Linux, Apache, MySQL, PHP) – a stack of free, open source software for building a web server for general purpose. 1. Install Apache HTTP Server yum install httpd Backup the apache configuration file ‘httpd.conf’. cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.backup Set the apache service to start at […]