Re: Data files from 4.1.13 with 5.0.x

> Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL > dump? Well, not to worry, I managed to start 4.1.13 and got an SQL dump. Cheers. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

relay-bin.000157' not found

Please advise me on how to restart MYSQL slave instance. All efforts have failed. When I issued the "START SLAVE" command it came back with an error -- see below. ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2 I inadvertently deleted this file. Tha

Re: MySql Administrator Tool Login

On 8/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello > > I successfully installed the mysql database on my pc. I also installed the > mysql administrator tool. I am trying to login and I need some assistance. > It is asking for stored connection, server host, username and password. I a

RE: Database Creating

I would like to create my first mysql database. Is there a gui tool that makes this easy to do? Thanks, Andrew Try Toad - http://toadsoft.com/toadmysql/mysql_freeware.htm This e-mail, including any attachments, may be confidential, privile

Re: Database Creating

On Thu, 7 Aug 2008, [EMAIL PROTECTED] wrote: Hello I would like to create my first mysql database. Is there a gui tool that makes this easy to do? http://dev.mysql.com/downloads/gui-tools/5.0.html -d -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Database Creating

Hello I would like to create my first mysql database. Is there a gui tool that makes this easy to do? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySql Administrator Tool Login

Hello I successfully installed the mysql database on my pc. I also installed the mysql administrator tool. I am trying to login and I need some assistance. It is asking for stored connection, server host, username and password. I am not sure what to put in here. When I installed the database I

Re: Strange issue in a stored procedure [SOLVED]

Nicolas Sebrecht a écrit: > mysql> CREATE DATABASE dbtest; > mysql> DELIMITER $$ > mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$ > mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130)) > -> BEGIN > -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1)); > -> END$$

RE: removing duplicate entries

I think got it in the end by doing a union and a join. delete AA, PA from ACCOUNTACTION AA, ACCOUNTPAYMENTACTION PA where AA.ID = PA.ID and AA.ID in (select D.ID from (select A1.ID from ACCOUNTACTION A1 left join ( select * from ACCOUNTACTION A2

Re: removing duplicate entries

On Thu, Aug 7, 2008 at 2:34 AM, Magnus Smith <[EMAIL PROTECTED]> wrote: > Yes I can see you are correct. I tried setting up a little test case > myself. > > CREATE TABLE ACCOUNTACTION ( > ID INT NOT NULL PRIMARY KEY, > ACTIONDATE DATETIME, > ACCOUNT_ID INT NOT NULL > )

RE: removing duplicate entries

Yes I can see you are correct. I tried setting up a little test case myself. CREATE TABLE ACCOUNTACTION ( ID INT NOT NULL PRIMARY KEY, ACTIONDATE DATETIME, ACCOUNT_ID INT NOT NULL ); CREATE TABLE ACCOUNTPAYMENTACTION ( ID INT NOT NULL PRIMARY KEY,

Strange issue in a stored procedure

Hello, I need help since I fail to set up a basic stored procedure. Here are the executed commands and the error I get: mysql> CREATE DATABASE dbtest; mysql> DELIMITER $$ mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$ mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130)) ->