WordPress.org

Ready to get started?Download WordPress

Forums

Cannot Import Multi-site Databse (4 posts)

  1. dterrazas
    Member
    Posted 1 year 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

  2. 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.

  3. dterrazas
    Member
    Posted 1 year 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?

  4. 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.

Topic Closed

This topic has been closed to new replies.

About this Topic