Restoring MySQL Databases with phpMyAdmin

For Linux or Windows Web Hosting Packages and Managed Dedicated Servers

In this article, we'll show you how to insert a backup file into your MySQL database.

Guided Steps

  • Log in to 1&1 IONOS.
  • In the My Products menu, select the Hosting tile and, if necessary, select the appropriate contract.
  • Click the Manage button in the Databases tile.
  • Next to the desired database, click the Open link in the phpMyAdmin column.
  • Click on the database name (Example: db123456789) in the left side menu.
    Please Note: This step is necessary to make sure the database is the target for the data import.
  • Go to the Import tab.
  • Click Choose File to select the backup file you are importing.
  • Specify the desired import settings:
    • The default character set of the file setting is UTF-8, and since almost every current application now supports this format, you typically don't need to change this.
    • The format must match that of your data file. The default setting is SQL.
    • The other settings can usually be kept in their default values.
  • Click Go to start the import.

Your backup file will now begin importing. This process should only take a few moments but can take longer depending on the size of the file imported.