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=
localhost SQL SECURITY DEFINER VIEW
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?