maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

All,

I got a replciation problem and planned to take master server dump using
below command and tried to restore in slave server:

mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob
--master-data=1 -A --routines > ~/dump.sql

I got into this error:
https://jira.mariadb.org/browse/MDEV-10119

Then I tried this method:
http://lists.askmonty.org/pipermail/commits/2016-June/009504.html

My question:

Is it ok if the GIS procedure currently with definer as
definer=`root@localhost` instead of blank as definer=`` for the following
two procs in mysql:

Slave_MariaDB [(none)]> select db, name, definer from mysql.proc;
+---------+------------------------+-----------------+
| db      | name                   | definer         |
+---------+------------------------+-----------------+
| mysql   | AddGeometryColumn      | root@localhost  |
| mysql   | DropGeometryColumn     | root@localhost  |


Master_MariaDB [(none)]> select db, name, definer from mysql.proc;
+---------+------------------------+-----------------+
| db      | name                   | definer         |
+---------+------------------------+-----------------+
| mysql   | AddGeometryColumn      | @               |
| mysql   | DropGeometryColumn     | @               |