Importing database after changing primary domain.

  • Dan Stephens

    (@dtspdx)


    11 years, 2 months ago

    I built a site for my church on a secondary domain (parksideconnection.org) and now it’s live so I want to change everything inside of WP to our primary domain (parksidechurchcamas.org). My host is 1and1. I followed the instructions found here and got to the step of importing my database. I get an error 1064 at this point. In order to minimize downtime, I have not dropped the previous tables from the database, because I wanted to make sure the new database loaded successfully before dropping the old tables.

    SQL query:

    – phpMyAdmin SQL Dump
    — version 2.6.4-pl3
    — http://www.phpmyadmin.net
    —
    — Host: db447425066.db.1and1.com
    — Generation Time: Feb 17, 2013 at 02:45 PM
    — Server version: 5.0.96
    — PHP Version: 5.3.3-7+squeeze14
    —
    — Database: db447425066
    —
    CREATE DATABASE db447425066 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

    MySQL said:

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘– phpMyAdmin SQL Dump
    — version 2.6.4-pl3
    — http://www.phpmyadmin.net
    -‘ at line 1

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Importing database after changing primary domain.’ is closed to new replies.