There is a simple procedure with which you can easily back up you’re my SQL database. Its very necessary to have a backup your MySQL database as if anything happens to the server then you will be in a position to restore back the content or else whole content present in the site will get lost and literally your site will be blank with no content. This will be a huge loss as the backing up or the export of the My SQL database will save you at this time. So, let’s check out how you can easily back up all database of the My SQL.
Procedure to backup your MySQL database:
�First of all, you will need to create a dump file be it export or the back up of the database which is basically used by your account. For doing this, you need to have the access the phpMyAdmin tool which is available in your cPanel. As soon as you head to this, the phpMyAdmin tool will be loaded shortly.
�Now, you need to select the databases which you would like to have the back up of which can be selected from the drop down menu which is also called the database which is basically located in the left hand side corner of the page.
�Now, a new page will be loaded in phpMyAdmin showing the selected database and so in order to proceed with the backup click on the Export tab in the cPanel.
�Now, the options which the user should select apart from the default ones are Save as file (which will save the file in the .sql format and the Add DROP TABLE which will add the drop table functionality if the table already exists in the database backup.
�Now, you just need to click on the Go button for starting start the export/backup procedure for your database.
So, now the download window will be popping up prompting you to select the folder where you wish to save the file and then the download starts automatically and then as soon as the download finishes, the file gets stored.
