Transferring Databases Print

  • migratingzillionkinghost, migrating, database, phpmyadmin, wordpress, troubleshooting, cpanel, php, migration, password
  • 0

Moving the data.

EXPORTING

From phpMyAdmin on the old host, or a command-line export.

Export as SQL, with structure and data.

FOR LARGE DATABASES

phpMyAdmin has limits. A large export may fail or time out.

Open a ticket; we can import larger files directly.

CREATING THE DATABASE HERE

cPanel: create the database, create a user, assign the user with all privileges.

Note the prefix. Your account username is prepended to both names.

IMPORTING

Through phpMyAdmin for smaller files.

UPDATING YOUR APPLICATION

The configuration file needs the new database name, user and password.

For WordPress that is wp-config.php.

THE MOST COMMON MIGRATION FAILURE

Forgetting the prefix, so the application cannot connect.

The symptom is a database connection error.

VERIFYING

Check the table count matches the source.

Check the site loads and content appears.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot