When you use any of the web hosting services which are online to host your website or blog. You should always backup your files frequently to avoid any kind of data loss. MySQL is one of the widely used database used in web applications in the world. It is one of the open source relational database management system. In most of the web hosting services you can find this term being used MySQL because they all use this one for the database management. In this article on BloggingChamps.Com I will tell you the procedure which you need to follow to backup MySQL Database in Godaddy.
How to Backup MySQL Database in Godaddy?
To backup or export MySQL Database first of all you need to login into your Godaddy account. You can use this link provided here it will directly take you to the Godaddy’s Website where you can login into your account by entering your username and password.
After that you need to click on your username which is show at the upper right corner of your window. You will get one menu when you click on that. Now click on Manage Your Hosting, you can refer the picture embedded below.
When you click on Manage Your Hosting, all the hosting plans which are active on your Godaddy account will be displayed to you on your screen. Choose the Hosting plan whose MySQL you want to back up and click on Manage. Refer the picture below for more detailed information about this step.
You will be taken to cPanel when you click on Manage. From there scroll down to Databases and look for phpMyAdmin and click on that. A new tab will open in your web browser, click on the database which you want to backup.
After selecting the database, you will see a table on your screen. Now you need to click on Export to backup the database. You can refer the image below.
As soon as you click on Export you will see a yellow link tell you Loading……. as soon as the loading process completes. You will be asked to select the Export method, you will be getting two export methods. One is Quick which will display minimal options.
And the second one is Custom export option in which you will be shown all the possible options to you. If you are expert then choose Custom export and if you are non-technical person then I would like to recommend you to go with Quick.
You should also select the format in which you would like to export your database, you will be offered with many formats. But I recommend you to choose SQL format from the drop-down menu.
At last click on Go and you and you are done. Your have successfully downloaded your MySQL Database. This was how you can backup MySQL database in Godaddy. I hope you are clear with all the steps which are mentioned in this article. If you have any doubts you can comment below. We will respond to you as quick as possible to us.
Other Backup articles related to Godaddy:
- How to restore MySQL Database in Godaddy?
- How to backup website through cPanel in Godaddy?
- And How to restore website through cPanel in Godaddy?
These two articles will explain you how you can backup and restore your website from cPanel of Godaddy.