What is a MySQL database dump?

A MySQL database dump is a copy of the data in a MySQL database. It can be used to recreate the same database on another computer or server.

There are many reasons why you need to create a MySQL database dump. You may want to move your databases from one server to another, or you may want to move your databases between different environments such as development and production servers, or you may want to back up your databases.

How to dump a database in phpMyAdmin

The first step in creating a database dump is to find the database you want to create. You can do this by scrolling down the sidebar on the left.

Scroll down to find the database you want and select it. Once you have selected the database you want, go back to the main page and click “Export“.

hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com

To export your data, you need a file type that phpMyAdmin supports. The most common file types are .sql and .sqlite.

Choose whichever one you want and then click “Go”.

Now phpMyAdmin will prompt you to specify the location where it should save your file, as well as a name for it. Specify these details and click “Go” again before clicking “Yes” to confirm that you want phpMyAdmin to continue exporting your data from this database.

How to restore MySQL database from dump

If you want to restore a MySQL database from a dump, the first thing to do is select the desired database in the phpMyAdmin sidebar and click on the “Import” tab in the top menu.

hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com

You will see a long list of import options. Select “Dump File” and click “Select File“. Select the dump file and click “Upload”. You will be able to see that it has been successfully uploaded. Now all you need to do is select the target database and click “Go” that’s all.

About the Author

Andrii Kostashchuk

Andrii has experience in programming in various languages for different platforms and systems. He has spent more than 8 years in the Internet sphere, working with various CMS, such as: Opencart, Drupal, Joomla, and of course, the most popular content management system WordPress.

View All Articles