How to backup and restore a MySQL database using phpMyAdmin

by | May 11, 2022 | Tutorials

 Why should I backup MySQL databases with Indichosts.net?

A database is a storage place for dynamic content. Even if you have not changed your website HTML and pictures for some time, your database would have changed as your website script interacted with website visitors. It is very important to do a periodic backup of your database even if you have not changed your website for some time.

A lot of web applications use MySQL database(s) for storing the content. This can be blogs, shopping carts, content management systems, support systems, and most of the Fantastico scripts. You can check your hosting control panel to verify how many MySQL databases you are using.

We have PhpMyAdmin installed on our servers, accessible using graphical user interface (control panel) such as cPanel, DirectAdmin, Plesk and other opensource solutions. Please Open phpMyAdmin from the control panel assigned to you.

Create a Backup of the MySQL database

  • Select your database from the left panel (if you have multiple databases), Click Export in the Menu to get to where you can backup a MySQL database.

Click to enlarge

 

  • Make sure that you have selected to export your entire database and not just one table. There should be as many tables in the export list as shown under the database name.
  • Select “SQL”-> for the output format,   Then,
    • Check “Structure”.
    • Check the “Add AUTO_INCREMENT” value.
    • Check “Enclose table and field name with backquotes”.
    • Check “DATA”, check use “hexadecimal for binary field”.
    • Set Export type set to “INSERT”.

     

  • Now, Check “Save as file”, do not change the file name, and use compression if you want. Then click “GO” to download the backup file.

Click to enlarge

 

Restoring a backup of a MySQL database

  • To restore a database, Select your database from the left panel (if you have multiple databases), Click the SQL tab.
  • On the “SQL”-page, unclick the show query here again.
  • Browse to your backup of the database.
  • Click Go.

Click to enlarge

To read more about PhpMyAdmin, see the documentation.

Related Posts:

Heads Up: cPanel’s Price is Going Up Again! 1st Jan 2024

Updated on 6th October 2023. Previously updated on: November 15, 2022, September 30, 2021 November 4, 2020 August 26, 2019   2019 pricing update: We at IndicHosts strive to offer you our products at the lowest possible price. However, cPanel has announced a new pricing and licensing structure. Therefore, we will also need to adjust to cPanel’s new pricing policy and adjust our prices similarly.

A Simple Guide to Combating Email Spoofing

Looking to enhance your email security? Get a step ahead with our comprehensive email spoofing solutions. Our expert team has crafted a Simple Guide to Combating Email Spoofing that will equip you with the knowledge and tools to protect your valuable information. With our innovative techniques and cutting-edge technology, we’ll help you stay one step ahead of cyber threats. Don’t let email spoofing compromise your security – join us today and safeguard your business.

Upgrading to MariaDB 10.11 from MariaDB 10.6: A Comprehensive Guide

Looking to level up your MariaDB game? Look no further! Our comprehensive guide to upgrading from MariaDB 10.6 to MariaDB 10.11 is your go-to resource for seamless migration. Gain access to expert tips, step-by-step instructions, and insider tricks to ensure a smooth transition and optimize your database’s performance. Whether you’re a seasoned developer or a curious beginner, our guide has got you covered. Upgrade with confidence and unlock the full potential of MariaDB today.