Import a database backup

Article

Import a checked database backup into a new empty database.

  1. Log in to cPanel from your client area. If that link is unavailable, use the panel address in your welcome email. The cPanel dashboard appears after successful sign-in.

    The own demo domain in cPanel, outlined and marked 1.
  2. Create a new empty database in cPanel with a separate name. This example uses importdemo. Keep the full prefixed database name.

    The separate importdemo database name in cPanel, outlined and marked 2.Create Database for the separate empty target, outlined and marked 2.
  3. Open phpMyAdmin from Tools. phpMyAdmin opens with the database list on the left; select your new empty database in the next step.

    phpMyAdmin in Tools for the fresh empty import target, outlined and marked 3.
  4. Select the new empty database. Check the database name and confirm that no tables are listed.

    The separate new empty demo database, outlined and marked 4.
  5. Choose Import in the selected database’s navigation. The import form appears.

    Import in the selected database navigation, outlined and marked 5.
  6. Open the file picker under File to import. Your computer’s file chooser appears.

  7. Select the checked backup file from your computer. Its filename appears in the import form.

    The previously checked demo SQL backup selected for import, outlined and marked 7.
  8. Review the file format and import options. This example imports the checked SQL export without changing its data.

    SQL format on the own target’s import form, outlined and marked 8.
  9. Choose Import once. Wait for phpMyAdmin to report the result.

    Import for the reviewed backup and target, outlined and marked 9.
  10. After a successful import, open Structure and check that the expected tables appear.

    The expected demo_items table after successful import, outlined and marked 10.

Import into a new empty database. A backup can contain instructions that replace existing data.

Your application may also need the new database connection details after the import.

Video walkthrough

Sources

For help, contact Faciotech support.