Results 1 to 2 of 2

How to Backup & Restore MySQL Database in cPanel?

This is a discussion on How to Backup & Restore MySQL Database in cPanel? within the Web & Server Administration forums, part of the Web Designing & Development category; To backup the databases please do the following: 1. Login to your control panel and click Backups. 2. Under Download ...

  1. #1
    Senior Member hostechsupport's Avatar
    Join Date
    Feb 2017
    Posts
    417

    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
    Best Linux/ Windows Server Management
    24x7 Skype: hostechsupportindia

  2. #2
    Junior Member
    Join Date
    Jan 2018
    Location
    India
    Posts
    25

    Default Re: How to Backup & Restore MySQL Database in cPanel?

    By following steps you can easily import:
    • Login to cPanel.
    • Go to phpMyAdmin.
    • Click to create new database name in the top left, or choose an existing database.
    • Click Import in the main area of phpMyAdmin.
    • Browse for the .sql file on your computer and click Open.