Tag: MySQL

How To Move MySQL Data Directory On A Separate Partition

Prerequisite: A free partition that will serve as a dedicated MySQL partition. Note: These instructions assume that the partition you wish to mount is /dev/sdc1 Backup all MySQL databases Code: mysqldump –opt –all-databases | gzip > /home/alldatabases.sql.gz Stop tailwatchd and the mysql (tailwatchd monitors services, so disable it to prevent it from prematurely restarting mysql) Code: […]

How To Back Up Your MySQL Databases

MySQL is an open source relational database management system (DBMS) which is frequently deployed in a wide assortment of contexts. Most frequently it is deployed as part of the LAMP Stack. The database system is also easy to use and highly portable and is, in the context of many applications, extremely efficient. As MySQL is often […]

How To Install Linux, Lighttpd, MySQL, and PHP5 (LLMP Stack) on Centos 6

Introduction Lighttpd is an open source web server originally written by Jan Kneschke as an alternative to Apache, it has a low memory footprint and numerous websites such as YouTube and Wikimedia run Lighttpd servers. MySQL is a popular database solution for use in web applications (such as WordPress) and is generally combined with a […]

Back to top