MySQL is one of the most popular open-source database management system in the world. When it comes to the security of your MySQL, backing up the databases it’s a must. You always need to have a solid backup of your MySQL databases. MySQLDumper is a free and open-source web based tool for creating a backup of MySQL databases. With MySQLDumper you can automate the process of backing up the databases and configure it to send you an email report about whether the backup succeeds. MySQLDumper is based on PHP and Perl and it is very easy to use.
In this blog article we will guide you through the installation of this very useful tool on a CentOS VPS.
The installation is very easy and straightforward. MySQLDumper requires Apache, MySQL and PHP. These requirements are already installed on all our full OS templates.
Log in to your CentOS server as user ‘root’ and make sure that all packages are up-to-date
yum -y update
Go to MySQLDumper’s official website and download the latest available version. At the moment of writing this article it is version 1.24.24
wget http://downloads.sourceforge.net/project/mysqldumper/MySQLDumper/MySQLDumper1.24.4.zip
Unpack the downloaded zip archive in the Apache’s document root directory. If you are not sure what is your document root directory, you can find out using the following command
grep -i "^documentroot" /etc/httpd/conf/httpd.conf DocumentRoot "/var/www/html"
In our case it is ‘/var/www/html’ which is the default document root directory under CentOS.
Unpack the downloaded zip archive
unzip MySQLDumper1.24.4.zip -d /var/www/html/
This will create a new ‘msd1.24.4’ directory under ‘/var/www/html’. We will rename the directory to something simpler.
cd /var/www/html mv msd1.24.4/ mysqldumper
Change the ownership of the ‘mysqldumper’ directory
chown -R apache:apache mysqldumper/
Now, navigate your web browser to http://YOURDOMAIN.TLD/mysqldumper/install.php and follow the on-screen steps to finish the installation. You will be prompted to enter your MySQL server information such as hostname, MySQL username and password, etc…
Of course you don’t have to do any of this if you use one of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to install MySQLDumper for you. They are available 24×7 and will take care of your request immediately.
PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.