{"id":18793,"date":"2021-09-18T14:13:19","date_gmt":"2021-09-18T14:13:19","guid":{"rendered":"https:\/\/supporthost.com\/?post_type=tutorial&p=18793"},"modified":"2024-05-15T16:50:48","modified_gmt":"2024-05-15T16:50:48","slug":"import-databases","status":"publish","type":"tutorial","link":"https:\/\/supporthost.com\/tutorial\/import-databases\/","title":{"rendered":"How to import MySQL databases with cPanel"},"content":{"rendered":"\n

In this tutorial, we see how to import MySQL databases using phpMyAdmin. Among the multiple functions integrated into phpMyAdmin, one of the most used database management systems, we can also find the import and export of databases<\/a>.<\/p>\n\n\n\n

Import databases: when can it be useful?<\/h2>\n\n\n\n

There are several cases where importing databases can be useful.<\/p>\n\n\n\n

The most common case is if you have decided to migrate a WordPress<\/a> website to another provider. To migrate the website successfully, you will also need to import the database to the new server.<\/p>\n\n\n\n

In other cases, you may just want to restore a backup of your database.<\/p>\n\n\n\n

How to import databases<\/h2>\n\n\n\n

You can import MySQL databases directly using phpMyAdmin, let’s see how to import databases step by step.<\/p>\n\n\n\n

First, login to cPanel<\/a>, then scroll down to the Database <\/em>section and click on phpMyAdmin <\/strong>as indicated on this screen.<\/p>\n\n\n\n

\"Import<\/figure>\n\n\n\n

You will now see the interface of phpMyAdmin<\/a>, and in the left section, you will see the list of databases present.<\/p>\n\n\n\n

You have two options:<\/p>\n\n\n\n