Hi

Is there a way to find out when the MySQL Slave has been restarted.

Thanks and Regards

Kaushal

Check the error.log on both server and client, should show where
connected and disconnected.

Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.

Ben

Kaushal Shriyan wrote:
> Hi
>
> Is there a way to find out when the MySQL Slave has been restarted.
>
> Thanks and Regards
>
> Kaushal
>

On Fri, Apr 18, 2008 at 7:06 PM, Ben Clewett <ben@clewett.org.uk> wrote:

> Check the error.log on both server and client, should show where connected
> and disconnected.
>
> Or write a small program to execute SHOW SLAVE STATUS every minute and log
> the results. Which I belive is done for you in the MySql dashboard program
> suit.
>
> Ben
>
>
> Kaushal Shriyan wrote:
>
> > Hi
> >
> > Is there a way to find out when the MySQL Slave has been restarted.
> >
> > Thanks and Regards
> >
> > Kaushal
> >
> >
Hi

I could see the restart in tail -f /var/log/mysql/mysqld.err file while
doing slave stop and slave start, but when i use mk-slave-restart -u root -p
test -h localhost --verbose. it gets hung.

Any clue

Thanks and Regards

Kaushal

I'm attempting to create a MySQL stored procedure, however, when I attempt to
create even a simple "Hello, world" procedure, I get the following error:

ERROR 1307 (HY000): Failed to CREATE PROCEDURE test_procedure_k

which is listed as:

Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED)
Message: Failed to CREATE %s %s

I've googled for the solution, and the only problems I can find are people who
haven't upgraded correctly. This is a clean installation, though, and I
don't recall any errors when installing. I'm not ruling anything out, but I
don't think that's the case.

The results of mysqlcheck mysql for the proc tables are:

mysql.proc OK
mysql.procs_priv OK


Anyone have any thoughts, or come across this before?

TIA,

kabel

can u please try this a root user

mysql -uroot

regards
anandkl


On 4/18/08, kabel <lists@voidship.net> wrote:
>
> I'm attempting to create a MySQL stored procedure, however, when I attempt
> to
> create even a simple "Hello, world" procedure, I get the following error:
>
> ERROR 1307 (HY000): Failed to CREATE PROCEDURE test_procedure_k
>
> which is listed as:
>
> Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED)
> Message: Failed to CREATE %s %s
>
> I've googled for the solution, and the only problems I can find are people
> who
> haven't upgraded correctly. This is a clean installation, though, and I
> don't recall any errors when installing. I'm not ruling anything out, but
> I
> don't think that's the case.
>
> The results of mysqlcheck mysql for the proc tables are:
>
> mysql.proc OK
> mysql.procs_priv OK
>
>
> Anyone have any thoughts, or come across this before?
>
> TIA,
>
> kabel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
>
>

On Friday 18 April 2008 10:26:16 Ananda Kumar wrote:
> can u please try this a root user
>
> mysql -uroot
>
> regards
> anandkl
>

Same result, unfortunately.

kabel