Move multisite to different domain

  • Resolved ultimateuser

    (@ultimateuser)


    11 years, 7 months ago

    Hi

    Im running WP 3.5.2 and BP 1.8 (multisite).

    I’m trying to move my WPMU SQL database from one domain to another. Once I start importing the SQL file I get the following error:

    —
    Error
    SQL query:

    —
    — Table structure for wp_s8jkr8_2_bp_activity
    —
    DROP TABLE IF EXISTS wp_s8jkr8_2_bp_activity ;

    MySQL said: Documentation

    #1046 – No database selected
    —

    Is there a way to resolve this so I can still move my database?

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)

  • Error 1046 means that you didn’t tell the server what database to import the database into.

    If you are using CLI:

    mysql -u {DB-USER-NAME} -p {empty.DB-NAME} < {db-you-want-to-import.sql}

    If you are using phpmyadmin make sure you first create a new database. Then go into that new database and go to the import page.

    Thread Starter ultimateuser

    (@ultimateuser)

    Thanks that worked!!

    Fantastic! Go ahead and click that resolve button ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Move multisite to different domain’ is closed to new replies.