How to Backup MySQL Database in GoDaddy? [with images]

Shit! I lost all my user account details, credentials in my GoDaddy’s account, I do not want to lose the data again with my another account. Now instantly I need to take backup MySQL database in GoDaddy’s account.Do you know how to take backup MySql database in GoDaddy? if possible can you show me how to do it?

Yeah, I’ll help you to take backup in GoDaddy account.For an online business, it’s recommended to take the backup data frequently to avoid data loss issue.

Nowadays most of the web applications use MySQL database to store their data, GoDaddy also provides MySQL database to their customers to deal with the data.

steps to backup mysql database in godaddy

GoDaddy is a best, cheapest hosting provider in the world, Once you register domain name with GoDaddy, you will be authorized to delete domain name, you can transfer one domain register to another, you can enable security options, you can do so many things with your domain name but In today’s article I’m going to show you to take backup MySQL database in GoDaddy.

We have unlimited hosting providers in the blogging market, every hosting provider offers unlimited features to their customers but we can’t come to a conclusion that, this hosting provider is providing ultimate features from rest of the hosting providers, though every provider has their unique style to attract their customers.

Let me share you few ideas about GoDaddy. GoDaddy is one of the largest hosting providers in the world, It offers many plans to the customers as well for the organizations to choose a host in cheap.

Many of them aware of GoDaddy hosting because they are providing best features to their customers with 24/7 support, But we can’t say that GoDaddy is best in the world because I have many niche blogs which are hosted on GoDaddy, Yeah i have been facing some issues in some niche blogs, it’s been showing server down, not optimizing properly, but some other niche blogs are running well and getting reputation from all various resources.

According to my analysis, GoDaddy is best in price and feature wise.One of the features of GoDaddy is to backup database in GoDaddy to avoid data loss.

 

How to Backup MySQL Database in GoDaddy?

 

Every hosting provider gives an opportunity to backup MySql database in their accounts and it’s an easy to take backup MySql database in GoDaddy. I will explain you step-wise so that you will feel more comfy with the process.

Step-1) To backup MySql database in GoDaddy through cPanel, first log in to your Godaddy’s Account, Once you logged-in, now you need to click on your account’s top right corner of the page(As shown in the below image), in those options just click on a “My-Products” option.Once you click on a “My-Products” option, below you will get multiple options.(check we have “Domains, Web hosting, and WorkSpace Email”).

GoDaddy my product optionStep-2) After completion of the first step now you need to click on “Web Hosting->Manage” option ( I have hosted only one website so I will click on “blogkeep.com-> Manage” option if you have multiple websites hosted then you need to click on “Manage”, for which you want to backup MySql database in GoDaddy through cPanel).

Webhosting's Manage optionStep-3) After clicking on “Web Hosting->Manage” option you will get redirected to your cPanel’s account which contains all hosted account related information. Just scroll down the page and in the bottom, you can find “phpMyAdmin” option under Databases tab (refer the image for clarification)

Now Click on “phpMyAdmin” optionDatabses phpMyAdmin option

Step-4) After clicking on “phpMyAdmin” option you will be redirected to database account details, Now click on the first option from left navigation panel(refer the image).

 

phpmyadmin database account details

Step-5) After completing the step-4, you will get all database files on your screen, now click on “Export” option which will help you to take backup of mysql database.

 

phpmyadmin export option

Step-6) After clicking on “Export” option, you will be asked to download the backup MySQL database of your website in multiple ways(refer the image).

 

Now you have to select either “Quick” or “Custom” export method to backup your MySQL data
Format: – You can export all your MySQL database in multiple ways such as ex- Text report, CSV format, PDF, and etc.

backup mysql database in godaddy

After completing all the options now click on “GO” option to export all your database information in respective format. Now you have successfully downloaded backup MySQL database in GoDaddy to your local machine.

 

How Import SQL files into MySQL databases in GoDaddy

 

If you already have backed up database data to a SQL format, you can easily import into your hosting account.

import mysql database in godaddy

1) Navigate to “phpMyAdmin” option as I shown above
2) Click on “database details” as discussed in step-4
3) Now click on “import files” tab
4) Click “Browse” option to import your files in a hosting account
5) After updating your database files click on “Go” button to save all your SQL information.

You have successfully uploaded your MySQL database information to your hosting account,
Facing any problem? ping back with your questions, I will help you to resolve quickly

Hope you felt comfortable to take backup MySQL database in GoDaddy as well import SQL files into MySQL databases in GoDaddy.

Happy blogging!

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge