Cannot Import Multi-site Databse

  • dterrazas

    (@dterrazas)


    11 years, 2 months ago

    My university wanted to switch from example.domain.edu to newexample.domain.edu.

    I setup a new multi site instance of WP 3.5.1, on the same server which uses a dynamic IP address.

    I created a new database, I copied over original files from original site to the new instance and updated .htaccess and wp-config.php etc..

    Then I exported the database from the original site and when I try to do an import it starts to copy all the table but then errors out with the message:

    CREATE ALGORITHM=UNDEFINED DEFINER=cumulti_wp@localhost SQL SECURITY DEFINER VIEW wp_ms_posts…

    Access denied; you need the SUPER privilege for this operation

    If I try and login as the root I do not have access to phpMyAdmin for this site.

    Any clues or suggestions as to what I am doing wrong?

    Thank You

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 2 months ago

    If I try and login as the root I do not have access to phpMyAdmin for this site.

    That’s your problem. You need SQL access.

    Thread Starter dterrazas

    (@dterrazas)

    11 years, 2 months ago

    I have access through phpMyAdmin to the database but I am not logged into the server as the super admin. The only account that is linked to the mySQL database is the account that accesses the database through web_config.php file.

    Does this make sense?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 2 months ago

    Yes, but you need to talk to your host about how to set that up on the server. If you don’t have access from WP to the DB, it can;’t work. If you can’t import content into the DB, it can’t work.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cannot Import Multi-site Databse’ is closed to new replies.