In provision/db/mysql/mysql_service.inc, there is a 'sed' on some MySQL data which can cause problems when migrating a site with views/triggers.

Attached a tiny patch to make that sed more tolerant to various MySQL versions.

i.e. my sqldump had:

/*!50017 DEFINER=`example`@`localhost`*/

And the sed regexp expected a space after the hostname:

/*!50017 DEFINER=`example`@`localhost` */

Noticed this on a MySQL server running 5.1.49-3~bpo50+1.

CommentFileSizeAuthor
provision-sed.patch1.2 KBbgm
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bgm’s picture

Status: Active » Needs review
Steven Jones’s picture

Status: Needs review » Fixed

Thanks! Patch tested, and added.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

  • Commit e0f7158 on 6.x-1.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-subdir-multiserver, 6.x-2.x-backports, dev-helmo-3.x authored by bgm, committed by Steven Jones:
    Issue #1283926 by bgm: Fixed Small improvement on the trigger/views...
  • Commit 38801f8 on 7.x-2.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-subdir-multiserver, 6.x-2.x-backports, dev-helmo-3.x authored by bgm, committed by Steven Jones:
    Issue #1283926 by bgm: Fixed Small improvement on the trigger/views...