Edit SQL file for import
Required: You'll need a text editor to make the necessary changes in this SQL file. There are many third-party text editors available, however we recommend Notepad++ for this plain text file.
Before you can import the SQL file that yous exported in step two, you must edit the file to remove lines that will interfere with the import process in the next step.
- Locate the SQL file that you downloaded to your local file system.
- Select to open the file with the text editor of your choice.
- Locate the following lines and delete them:
-- -- Database: `r7n04293example` -- CREATE DATABASE `r7n04293example` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `r7n04293example`;
- Save the changes.
- Find more information at WordPress.org.