Choose another country or region to see content specific to your location and shop online.
SG

Edit SQL file for import

Home / Help Center / Websites / Managed WordPress / Edit SQL file for import

Step 4 of the Move a Managed WordPress site to an unmanaged WordPress account series.

Required: You’ll need a text editor to make the necessary changes in this SQL file. There are many third-party text editors available, we recommend Notepad++. Do not edit the file in a word processing application like Microsoft Word.

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.

  1. Locate the SQL file that you exported.
  2. Open the file with the text editor of your choice.
  3. 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`;
  4. Save the changes.

The file is ready to be imported in the next step.

More info

Managed WordPress hosting

Reseller login

If you’re a reseller, use the button below to sign in. (your reseller account is separate to your regular account)

New customer

New to ELITEWEB.Co? Create an account to get started today.

Registered users

Have an account? Sign in now.