Comments on: Migrating Ownership of Your Stored Routines, Views, and Triggers in MySQL https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/ Fri, 17 Sep 2021 10:00:10 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Francisco Miguel Biete Banon https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973320 Fri, 17 Sep 2021 10:00:10 +0000 https://www.percona.com/blog/?p=77159#comment-10973320 MySQL Shell is definitely better, but one thing I’m struggling to achieve is how to dump the DDL of all the routines, excluding the DDL of my tables… excludeTables should be able to accept wildcards or at least have the option for “all”

mysqlpump is lacking the skip-lock-tables options to play nice with PXC in strict mode and for some reason, even when excluding the tables I keep getting ALTER TABLE for the indexes and USE schema…

]]> By: lefred https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973250 Thu, 08 Jul 2021 21:30:04 +0000 https://www.percona.com/blog/?p=77159#comment-10973250 No as single file is not compatible with parallel load… however you can create a nice single zip (or tar, thx, …) file containing all that 😉

]]> By: Sveta Smirnova https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973249 Thu, 08 Jul 2021 21:27:07 +0000 https://www.percona.com/blog/?p=77159#comment-10973249 Can it create nice single SQL file that contains all databases, tables, routines and other objects?

]]> By: Sveta Smirnova https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973248 Thu, 08 Jul 2021 21:24:21 +0000 https://www.percona.com/blog/?p=77159#comment-10973248 Well, you are not supposed to update privilege tables directly. But regardless, this won’t help you if you want to migrate from Server A where you have user A to server B where you have user B and do not have user A: the dump file would not simply be imported.

]]> By: lefred https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973247 Thu, 08 Jul 2021 20:37:03 +0000 https://www.percona.com/blog/?p=77159#comment-10973247 Hi Sveta,

thank you for blogging about this problematic with mysqldump. I replied with another post using the same example but with MySQL Shell that must be preferred to mysqlpump. see: https://blogs.oracle.com/mysql/migrate-ownership-of-your-stored-routines%2c-views-and-triggers-for-mysql-in-2021

cheers,

]]> By: Timur Solodovnikov https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comment-10973243 Wed, 07 Jul 2021 16:23:02 +0000 https://www.percona.com/blog/?p=77159#comment-10973243 What about migration from user A to user B?

what are caveats of doing this: update mysql.proc set defer = ‘user B’ where defer = ‘user A’;
?

]]>