Re: Show ROUTINE body, not PROCEDURE

2013-03-25 Thread Dotan Cohen
On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley peter.braw...@earthlink.net wrote: Log in as admin@localhost. Thanks. I don't have the admin or root privileges on this database. Is that the only way to see the code behind the function? -- Dotan Cohen http://gibberish.co.il

Re: Show ROUTINE body, not PROCEDURE

2013-03-25 Thread Peter Brawley
On 2013-03-25 4:28 AM, Dotan Cohen wrote: On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley peter.braw...@earthlink.net wrote: Log in as admin@localhost. Thanks. I don't have the admin or root privileges on this database. Is that the only way to see the code behind the function? Ask admin to

Re: Possible issues with replication filters

2013-03-25 Thread shawn green
Hello Dimitre, On 3/24/2013 5:23 PM, Radoulov, Dimitre wrote: Hi all, we need to move a few databases from one host to another. During the process we need to use replication filters (to replicate only the databases to be moved). The current MySQL version is 5.5, the new one will be 5.6. We're

Benetl, a free ETL tool for MySQL, out in version 4.3

2013-03-25 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.3. This version brings a new way of reading control_file.xml files, several code corrections. This versions is correcting two bugs: Trouble with entity_id when inserting raw data. Trouble with sql script creation when setting

Re: Show ROUTINE body, not PROCEDURE

2013-03-25 Thread hsv
2013/03/25 11:28 +0200, Dotan Cohen Thanks. I don't have the admin or root privileges on this database. Is that the only way to see the code behind the function? Well, you showed us DEFINER: admin@localhost for the function; here is a snippet from MySQL help about SHOW CREATE FUNCTION