I am trying to use drush to move my live database down to my dev database. I am doing
drush sql-sync @live @devel --sanitize
However I get the error:
"ERROR 1227 (42000) at line 1478250: Access denied; you need the SUPER privilege for this operation"
I think it is due to the views in the db from uc_views module, is there any way around this?
I also tried to do
drush sql-sync --skip-tables-key uc_views @live @devel --sanitize
where uc_views is an option declared in drushrc.php with an array of the db views from uc_views, but to no avail. Here is my drushrc.php
$options['skip-tables']['uc_views'] = array('uc_order_products_pair_vw', 'uc_order_products_qty_vw', 'uc_order_products_user_vw');
I would actually prefer to copy the database views from uc_views rather than exclude them if that is possible.