CiviCRM Community Forums (archive)

Not sure if this belongs in this forum or the Upgrading Civi forum, but here goes...

I'm migrating a pre-existing DB from one hosting company to another. WordPress install. Exported the DB from the first host....no problem there. Then went to the new host, went to PHPmyAdmin, uploaded the DB and then this error came up:
--
Error

SQL query:

CREATE ALGORITHM = UNDEFINED DEFINER = `myUsername`@`localhost` SQL SECURITY DEFINER VIEW `civicrm_view_case_activity_recent` AS SELECT `ca`.`case_id` AS `case_id` , `a`.`id` AS `id` , `a`.`activity_date_time` AS `activity_date_time` , `a`.`status_id` AS `status_id` , `a`.`activity_type_id` AS `activity_type_id`
FROM (

`civicrm_case_activity` `ca`
JOIN `civicrm_activity` `a` ON ( (
`ca`.`activity_id` = `a`.`id`
) )
)
WHERE (
(
`a`.`activity_date_time` <= now( )
)
AND (
`a`.`activity_date_time` >= ( now( ) - INTERVAL 14
DAY )
)
AND (
`a`.`is_current_revision` =1
)
AND (
`a`.`is_deleted` =0
)
AND (
`a`.`status_id` <>1
)
);

MySQL said:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
I changed the username on top to myUsername for security purposes.

So why is this happening and is there some guide on how to properly import this?

I did. And unfortunately, the response I got back was 'Unfortunately, the way cPanel works we wouldn't be able to assign additional privileges beyond what is listed on the grant user privileges in your cPanel.'

Great.

Now how am I going to be able to import this database over?

They do offer that.

I went to PHPmyAdmin, selected the DB to download, clicked Export, went to custom, selected all the tables but five: civicrm_acl_cache, civicrm_acl_contact_cache, civicrm_cache
,civicrm_domain and civicrm_group_contact_cache.Then I checked Disable foreign key checks and Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement and then hit GO.

That was right, wasn't it?

The info came from here: http://wiki.civicrm.org/confluence/display/CRMDOC/Alternate+Moving+the+database+using+phpMyAdmin

You need the functions to be in the new DB. Using your approach above, I would suggest you:

1. Install CiviCRM on the new host into a fresh, empty database
2. Then import your MySQL dump

Since you are including DROP TABLE it should drop only what is being replaced, and leave all the other required items in place.