Results 1 to 7 of 7
  1. #1
    Senior Member
    Join Date
    Jul 2006
    Location
    IndiaMDM
    Posts
    365

    Thumbs up How to Backup & Restore MySQL Database in cPanel?

    To backup the databases please do the following:

    1. Login to your control panel and click Backups.
    2. Under Download a MySQL Database Backup, click the name of the database.
    3. Click Save As.
    4. Select a destination for where you would like the back up to be saved, locally.

    Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

    To restore a database, please do the following:
    1. Login to your control panel and click Backups.
    2. Click the Browse button next to the option which says Restore a MySQL Database.
    3. Select the .sql.gz file which you want to be restored.
    4.Click the Open button and click the Upload button.

    Your database driven website should be working again.
    HostechSupport
    24x7 Remote Services
    Linux/Windows Server Administration Server Management
    Get in touch: support@hostechsuppport.com

  2. #2
    Member
    Join Date
    Apr 2019
    Location
    US
    Posts
    33
    Thank you for your advise!

  3. #3
    Senior Member
    Join Date
    Mar 2019
    Location
    Mumbai
    Posts
    187
    Thanks For Advise

  4. #4
    Senior Member
    Join Date
    Jul 2006
    Location
    IndiaMDM
    Posts
    365
    Quote Originally Posted by Wolverine View Post
    Thank you for your advise!
    You're most welcome
    HostechSupport
    24x7 Remote Services
    Linux/Windows Server Administration Server Management
    Get in touch: support@hostechsuppport.com

  5. #5
    Registered User
    Join Date
    Jun 2019
    Posts
    40
    Hey,
    Database backup is a very important part of the application infrastructure. You should have a process in place to take Mysql DB backup on a regular interval. You can find steps to configure MySQL by using RAID 5 software backup on below URL https://www.diskinternals.com/raid-r...-step-by-step/
    Last edited by Okmar3; 09-29-2019 at 07:06 AM.

  6. #6
    Registered User dockerdan's Avatar
    Join Date
    Sep 2019
    Posts
    1
    The best way to backup and restore a MySQL database in cPanel would be from the phpMyAdmin application:

    On the cPanel Home screen, scroll down to Databases and click on phpMyAdmin.

    Select the database you would like to backup from the left navigation tree.

    Click the Export tab.

    Choose the Quick export method and click Go.

    Your export of your database will be downloaded to your local machine's default downloads location.

    To restore your MySQL database from a Backup in phpMyAdmin:

    Choose the database you want to restore from the left navigation tree.

    The phpMyAdmin script that restores your database does not drop the tables first.

    Click the Check All check box.

    Click the With selected: drop down menu and choose Drop.

    Confirm by clicking Yes.

    Click the Import tab.

    Click the Choose File button to browse for the MySQL backup.

    Click Go.


    Using this method will ensure that you have the exact .sql file for your database and that you can see the execution of the backup and restoration process directly in the mySQL administration console.
    〓〓 SSD Cloud Servers - 16 Datacenter Locations (Silicon Valley, New York, London, Amsterdam, Singapore + more)

    〓〓 Xeon Dedicated Servers Tier 3++ USA Datacenters / 1000mbps Layer 3 Uplink

    〓〓 1 Click Docker ~ Minecraft ~ Wordpress [100mbps/RAID Storage]

    〓〓 Secure Web Cloud Hosting | Twitter: @securewebcloud | Infrastructure for Developers & Agencies

  7. #7
    Registered User Isabella020's Avatar
    Join Date
    Oct 2019
    Location
    London
    Posts
    6
    Quote Originally Posted by HosTechS View Post
    To backup the databases please do the following:

    1. Login to your control panel and click Backups.
    2. Under Download a MySQL Database Backup, click the name of the database.
    3. Click Save As.
    4. Select a destination for where you would like the back up to be saved, locally.

    Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

    To restore a database, please do the following:
    1. Login to your control panel and click Backups.
    2. Click the Browse button next to the option which says Restore a MySQL Database.
    3. Select the .sql.gz file which you want to be restored.
    4.Click the Open button and click the Upload button.

    Your database driven website should be working again.
    wow that's great information thanks for share how to get sql and backup and update again on the database this is very important because of some time hacker put the script in data website distribute...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.