Edit SQL file for import
Step 4 of the Move a Managed WordPress site to an unmanaged WordPress account series.
Before you can import the SQL file downloaded in Export your site database, edit it to remove lines that will interfere with the import process.
- Locate the SQL file that you exported.
- Open the file with the text editor of your choice.
- Locate the following lines and delete them:
-- -- Database: `example-database-name` -- CREATE DATABASE `example-database-name` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `example-database-name`;
- Save the changes.
The file is ready to be imported in the next step.
- You can find more information in the official WordPress documentation.