MySQL Database - cPanel Tutorial Ch.8 | Web Hosting Articles & Tutorials

MySQL Database - cPanel Tutorial Ch.8

MySQL is a multi-function, multi-user database management system. With well over 10 million installations it is without doubt the most widely used system of its kind. Its basis is to operate as a server and provide access to databases for a number of simultaneous users, the reason it has been so popular for web hosting companies.

MySQL has been used as a very reliable component for Linux, Mac, Windows and Apache servers. It’s benefits towards web applications relates closely with the language of PHP. We previously learned how PHPMyAdmin can enhance the MySQL database. MySQL works with powerful content management systems such as Joomla and Mambo and blogging platforms such Drupal and WordPress. It also manages the databases of several other web applications written in PHP scripts.

ANOTHER BENEFIT OF MYSQL

Since we already learned how to create a database and configure it for PHPMyAdmin we will now further discuss other benefits of a MySQL database.

Automatic MySQL Backups

Blogs, message forums and other online communities have never been easier to create. As more web hosting servers implement Fantastico in their cPanel, other applications are able to be attached with enhanced overall features. Everything seems clear on the surface until the term “backup” is mentioned.

The uniformed user will not think much of this, firmly believing that their web host will handle the procedures of backing up information. Though this is mostly fact, some hosting servers will clearly explain that they cannot give a one hundred percent guarantee when it comes to the limit of corruption or the quality of their back system.

Users who are lucky enough to have a cPanel with their web hosting have it a bit easier. MySQL allows you to manage your database from A to Z, giving you the power to backup your information in case of technical difficulty.

Here is a simple way to back up your database with MySQL:

- Navigate to “Cron Jobs” from the main page of your cPanel and click the icon. You will be then be prompted with these options:

Minutes: This explains how many minutes a script will run
Hour: This represents what time of day the script will run
Day: This details how many days per week the script will run
Month: This determines if a script is to run on a particular month

Next should be a command option. After filling in the fields, the text inside the box should read something like this.

mysqldump –opt -Q -u dbusername –password=dbpassword dbname > /pathto/backups/sunday.sql

Changes will need to be made with the command prompt to correspond to your information. In this instance we would replace the variables in red.

From here you will repeat the first script six times over but modify the weekdays. This will go from 0 all the way up to 6. You will also change the file name from Sunday to Monday and so forth until reaching Saturday.

Even standing on its own MySQL is a very powerful application that brings out the best in your cPanel.

Share this article: