Re: [Maria-discuss] R: doubt trigger

2015-11-13 Thread Justin Swanhart
Hi, Well, I would suggest Flexviews. This is exactly what it is designed for. Or you can roll your own. Assuming the views are based on a single table, create a trigger on the table that logs the changes. You can automate the construction of such a log table and appropriate triggers, but you c

Re: [Maria-discuss] MariaDB 10.0.22 now available

2015-11-13 Thread Marco Nicosia
Hello! Did the bug reported by Reindl invalidate the 10.0.22 release? I see that it is still marked as stable and available for download. The reason I ask is, not being on 10.1 yet, we rely on the mariadb-galera combined releases, which seems to have stopped at 10.0.21: https://downloads.mariadb

[Maria-discuss] R: doubt trigger

2015-11-13 Thread Federico Razzoli
Standard SQL has triggers FOR EACH STATEMENT, but MariaDB has not. I would use a stored procedure instead. Regards Federico Ven 13/11/15, Roberto Spadim ha scritto: Oggetto: [Maria-discuss] doubt trigger A: "Maria Discuss" Data: Venerdì 13 nove

[Maria-discuss] doubt trigger

2015-11-13 Thread Roberto Spadim
hi guy, i'm with a doubt thre's a trigger to execute after insert/update/delete complete? not row by row i want to change some tables and automatically execute a procedure to recalculate some values, but i will insert/update/delete many rows, that's why i want to execute it after query execution,

Re: [Maria-discuss] mysql_install_db as user

2015-11-13 Thread Felipe Gasper
Ahh. Ok, so something wrong with how we upgraded to 10.1, then .. thanks! Sent from my android device. -Original Message- From: Sergei Golubchik To: Felipe Gasper Cc: MariaDB discuss Sent: Fri, 13 Nov 2015 6:30 Subject: Re: [Maria-discuss] mysql_install_db as user Hi, Felipe! On Nov

Re: [Maria-discuss] mysql_install_db as user

2015-11-13 Thread Sergei Golubchik
Hi, Felipe! On Nov 13, Felipe Gasper wrote: > > > > There's no special logic around it in MySQL 5.6 and no changes in > > MariaDB 10.1. > > > > chown is done if user=xxx is specified on the command line or in the > > my.cnf file. And if chown fails, you'll see the error message and > > mysql_insta

Re: [Maria-discuss] mysql_install_db as user

2015-11-13 Thread Felipe Gasper
On 13 Nov 2015 2:51 AM, Sergei Golubchik wrote: On Nov 12, Felipe Gasper wrote: Hello, Is this script supposed to be runnable as a normal (i.e., non-root) user? In MySQL 5.6 there is logic that prevents the chown() of the mysql data dir when running as non-root. MariaDB 10.1.8 doesn’t seem to

Re: [Maria-discuss] mysql_install_db as user

2015-11-13 Thread Sergei Golubchik
Hi, Felipe! On Nov 12, Felipe Gasper wrote: > Hello, > > Is this script supposed to be runnable as a normal (i.e., non-root) > user? > > In MySQL 5.6 there is logic that prevents the chown() of the mysql > data dir when running as non-root. MariaDB 10.1.8 doesn’t seem to have > this logic, so th