Here, we are not going to discuss any third-party vendor’s backup solutions. Many vendors provide state-of-the-art software and hardware solutions that can help to back up the database, and it can restore the database within the defined RTO and RPO. If the system or data center fails, database corruption, and data loss, we must be able to recover it within the defined SLA.ĭifferent database platforms provide various methods to generate the backup and restore the database. As database administrators, it is our primary and crucial job to keep the data available and safe. As we know, data is a valuable asset to the organization.

You can also choose to export the database in a format other than the default SQL, such as CSV or JSON.In this article, I am going to explain different ways to generate the backup in the MySQL database server. If you want to export the entire database, then just press the Go, but you can also choose to export only certain tables, change the character set and compression by checking the 'Custom' in the 'Export Method'.

Then come together when the following view:Ģ. To create a dump of your MySQL database, go instead to the Export tab in the menu bar at the top. Once you have made your selections, click 'Go' in the lower right corner. Other formats such as comma-separated values (CSV), Excel 97-2003 or Excel 2007 and XML can also be managed. Is it a normal MySQL dump so the format is SQL. Select the format of the file you're importing. This can be in plain text or compressed with gzip, bzip2, or zip.ģ. To import the data into your database, click on the 'Import' in the menu bar at the top.

Here you enter the username and password database when you created it.Īfter logging in you are met by the following view, which you can get more information about your database:ġ. If you are unsure of how this works, please contact support instead.īy clicking the edit button for a database, you can get additional information and also access a web-based tool called phpMyAdmin: Note: This page is intended for those who have more advanced requirements and knowledge of how to manage a database.

Download phpmyadmin mysqldump