Skip to content
  • Bharathy Satish's avatar
    fbbee16b
    Bug #29023216: MYSQLPUMP SHOULD WRITE USERS AND GRANTS BEFORE VIEWS · fbbee16b
    Bharathy Satish authored
                   AND STORED PROGRAMS
    
    Problem: Create a view(v1) with definer set to non existing user and then
    define another view(v2) on top of view v1 without any definer clause. Now
    when these views are backed up and tried to restore, restore fails when
    creating v2 stating non existing user does not exists.
    
    Analysis: This problem is because user account DDLs are dumped after view
    definitions are dumped.
    
    Fix: Fix is to dump view definitions at the last in the dump file.
    fbbee16b
    Bug #29023216: MYSQLPUMP SHOULD WRITE USERS AND GRANTS BEFORE VIEWS
    Bharathy Satish authored
                   AND STORED PROGRAMS
    
    Problem: Create a view(v1) with definer set to non existing user and then
    define another view(v2) on top of view v1 without any definer clause. Now
    when these views are backed up and tried to restore, restore fails when
    creating v2 stating non existing user does not exists.
    
    Analysis: This problem is because user account DDLs are dumped after view
    definitions are dumped.
    
    Fix: Fix is to dump view definitions at the last in the dump file.
Loading