Import into the intended destination database and check whether the file can overwrite existing tables.
Steps
- Create an empty destination database and user if you are migrating a new site.
- Open that database in phpMyAdmin and choose Import.
- Select the SQL file, review its format, and start the import.
- Wait for a completion result, then update the application database configuration and test the site.
Good to know
Back up any existing destination before importing. If the import fails partway through, do not assume repeated attempts are safe; partial tables may remain. For large files or version incompatibilities, send Support the error text without attaching private database contents unnecessarily.
Need help? Open a support ticket and include your domain and the step where you need assistance. Never include your password.