ESDS Knowledge Base

04
Jan

How to backup MySQL Database on dedicated servers ?

Databases are always being the main concern of the servers. Along with backups one can be rest assured that their database is secure and can be utilized as and when required. Websites today rely a great deal on databases to store vital data, which may include member information as well as website content.

Backing up MySQL database involves a strategic integration of resources. One can give preference to the automated backups as well. While automated backups are important, sometimes you just want to take a quick snapshot before making a change to your data. Dedicated web hosting solutions gives you full control over them. This helps you in making any crucial changes on your own and also gives you the liberty of installing or updating any softwares. You can do whatever you want with the box, implement services and of course a full root access with the machine.

People with the past experience in the web technologies knows that backups are a good practice and better too many than none. This practice of backing up the database of a website is fairly proves to be fruitful for a website and its content. If something happens (for instance, if the database gets corrupted), you’ll get to experience will be worst, but with the backups you can anytime recover it without any hassles. MySQL databases are the most popular open source databases that are used to power most of the websites today. This is why, it is very important to understand some basic working and administration of MySQL databases to comfortably manage your website.

We will have a quick peak into as how to make a backup and also restore a MySQL database with the following procedure:

The first and foremost step is to “Login into cPanel” you can follow the procedure like : type the URL http://<yourwebsite address>/cPanel in the Address bar of your Web browser and then press Enter. When prompted, enter your user id and password.

Then on the second step “ Login to PHPMyAdmin”: Sign into it as a valid root user or an administrator for your database. Then select the database which you want to backup. The menu for the database will come on the left side margin.

Then the another step is to Click on the Export tab once web page screening the selected database. Click on the saves as file option, which will save the file on your PC >> You can select database format either CSV, CSV for Excel or in .sql format.

Then with the ADD DROP TABLE option you can add table functionality. Generally the table exists in the database backup.

After that to import.sql file >> Click on the Import option (right side on the export tab).

Finally, Click on the Browse button to select .sql file from your local PC.

From the drop down menu, you can choose the character set of the file. If you are not firm with the character set then leave it default. Then the last step would be in order to proceed, click on the Go button (bottom of the right).

Please Note: If you are looking for Rich Data Center Web Hosting, Cloud Services, Dedicated Hosting, Colocation or Software Services in India at Affordable Costs, Visit our website at WWW.ESDS.CO.IN.

Leave a Reply