[Maria-discuss] mysqldump 10.1.16
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 | @ |
On 15/02/17 19:02, Karthick Subramanian wrote:
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`
yes. This is the proper state for the procedure.
instead of blank as definer=`` for the
This is incorrect. Fix your Master_MariaDB. Drop the procedure and create again as per maria_add_gis_sp.sql
following two procs in mysql:
Use SHOW CREATE PROCEDURE mysql.AddGeometryColumn\G https://mariadb.com/kb/en/mariadb/show-create-procedure/ to show information rather than selecting from the underlying tables.
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 | @ |
Thank you Daniel for your information. This is awesome. BTW, the script that you have mentioned "maria_add_gis_sp.sql" - where can I get this. How do we come to know in future for any fixes from MariaDB corp. Thank you. On Thu, Feb 16, 2017 at 9:39 AM, Daniel Black <daniel.black@au1.ibm.com> wrote:
On 15/02/17 19:02, Karthick Subramanian wrote:
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`
yes. This is the proper state for the procedure.
instead of blank as definer=`` for the
This is incorrect. Fix your Master_MariaDB. Drop the procedure and create again as per maria_add_gis_sp.sql
following two procs in mysql:
Use SHOW CREATE PROCEDURE mysql.AddGeometryColumn\G
https://mariadb.com/kb/en/mariadb/show-create-procedure/
to show information rather than selecting from the underlying tables.
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 | @ |
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Daniel Black -
Karthick Subramanian