I'm trying to move a live Drupal 7.39 site to my local Acquia dev set up which installs Drupal 7.41.
I follow what I think is standard procedure, which is to get a clean install, copy my site's sites folder, and then upload the database and run the update script.
I'm using the drush command
drush sql-drop -y && drush sqlc < dump.sql. The first part of the command runs, the database tables are dropped, but then I get a
1045 error (28000) for my database user.
What perplexes me, is that the first part of the call works, but it fails in the second part. The sql file is too large to import through phpmyadmin, and I'm really dumbfounded here.
Should I update the live site to 7.41 before migrating it? I don't want to do this because I don't want to do updates on the live site.
What is causing this issue? I think it's a conflict with the SQL settings in the settings.php file, but they match the database user and authentication but I don't know enough about the guts of drush to figure out how to fix this.