|  Home

WordPress Help

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.

  1. Locate the SQL file that you downloaded to your local file system.
  2. Select to open the file with the text editor of your choice.
  3. Locate the following lines and delete them:
    -- Database: `r7n04293example`
    CREATE DATABASE `r7n04293example` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
    USE `r7n04293example`;
  4. Save the changes.

More info

Was This Article Helpful?
Thanks for your feedback. To speak with a customer service representative, please use the support phone number or chat option above.
Glad we helped! Anything more we can do for you?
Sorry about that. Tell us what was confusing or why the solution didn’t solve your problem.