~How to load a mysql data file into sybase~

Hello, I have a mysql data bcp file ( using select into outfile ) from a table in mysql database. I have a similar table existing in a sybase database. I need to bcp in the mysql data file into sybase. Can anyone help me on how to go about the same ? Thanks in advance, Abdul. ___

Re: Need for distinct sum

Many thanks for your reply Shawn - I have some comments below. > Hello, > > I need to be able to sum over distinct values but I can't seem to do it > unless I use sub-selects (which I want to avoid doing). > > To see what I mean, I've constructed a toy DB: > > DROP TABLE IF EXISTS spell; > CREA

Re: Restoring a binary log ( mysqlbinlog )

It will be written in binary file but when you do mysqlbinlog -d hrdb --start-date-time="2006-04-04 06:00:00" > src.sql It wont be loaded in src.sql --Praj On Wed, 05 Apr 2006 09:53:34 -0300 Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > Hi, please see comments below.. > > thank you > Ma

Thank you MySQL Cluster

Thank you MySQL Cluster, for ignoring my information request after submitting about a year and a half ago. I was told in email that I was supposed to be contacted, that never happened. Thank you for automatically signing me up for all sorts of MySQL mailinglists for seminars that I do not want to a

Re: Table Size

At 2:15 pm -0700 5/4/06, Ravi Kumar wrote: >What command used to check table size and database size? For table size: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html I imagine (though I don't know for sure) that you can get the same info from the information_schema database that wa

Table Size

Hi, What command used to check table size and database size? thanks - Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.

Re: Password expire?

On 4/5/06, NiCK Song <[EMAIL PROTECTED]> wrote: > Hi, experts > > How can I make mysql database users password with expire date? > Does mysql can do it? > > -- > NiCK > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[

Re: very long query for such a simple result

Hi Ed, Count(1) works just as well. Sum(1) just adds 1 for each row so it's logically equivalent. PB - Ed Reed wrote: WOW!!! THAT WAS AWESOME!!! Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where can I learn more about it? Thanks again.

Re: very long query for such a simple result

WOW!!! THAT WAS AWESOME!!! Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where can I learn more about it? Thanks again. >>> Peter Brawley <[EMAIL PROTECTED]> 4/4/06 10:13:00 PM >>> Ed,e: Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff th

Re: Password expire?

"NiCK Song" <[EMAIL PROTECTED]> wrote on 04/04/2006 11:05:57 PM: > Hi, experts > > How can I make mysql database users password with expire date? > Does mysql can do it? > > -- > NiCK > Sorry!! MySQL does not auto-expire any user accounts. You will need to script something to do that manuall

Re: very long query for such a simple result

You must be able to run it as a single call, or as a single TRANSACTION? What do you mean by "single call"? One PHP command? One command on the commandline? one script run? -Sheeri On 4/4/06, Ed Reed <[EMAIL PROTECTED]> wrote: > Thanks for the quick reply Peter. Unfortunately, this is all leg

Re: Slow query log

2006/4/5, Mechain Marc <[EMAIL PROTECTED]>: > Hi, > > Thank you for your answer. > But is there a chance to be able to do it one day? > I think it could be a nice feature. > You still have the option to sponsor that feature ;-D -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: Restoring a binary log ( mysqlbinlog )

Hi, please see comments below.. thank you Mauricio On Wed, 2006-04-05 at 09:02, Prasanna Raj wrote: > Hi All > > Correct me if iam wrong > > You might have run the create table syntax from hrdb database .So it gives > you the create table also when you do mysqlbinlog . > > CREATE TABLE intr

Re: Slow query log

Mechain Marc wrote: Hi, Thank you for your answer. But is there a chance to be able to do it one day? I think it could be a nice feature. Marc. That should be asked to one of the devs. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General

Re: Restoring a binary log ( mysqlbinlog )

Hi All Correct me if iam wrong You might have run the create table syntax from hrdb database .So it gives you the create table also when you do mysqlbinlog . CREATE TABLE intra.table1 AS SELECT * FROM table2 , which means you are under hrdb database. Else you can use below syntax which won

RE: Slow query log

Hi, Thank you for your answer. But is there a chance to be able to do it one day? I think it could be a nice feature. Marc. -Message d'origine- De : Petr Chardin [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 avril 2006 13:06 À : Mechain Marc Cc : MySQL Objet : Re: Slow query log On We

Restoring a binary log ( mysqlbinlog )

Hi , Yesterday our main database was dropped by mystake. This has never happened before. Furtunately we had a daily backup performed with mysqldump at about 06:00 am that day. As the problem ocurred at about 12:00am we had to restore the transactions from the binary log ( we have several bina

Re: Slow query log

On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote: > Is there a way to enable the Slow Query Log on the fly without having to > restart mysqld No. Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow query log

Hello, Is there a way to enable the Slow Query Log on the fly without having to restart mysqld Regards, Marc.

Re: Password expire?

NiCK Song wrote: Hi, experts How can I make mysql database users password with expire date? Does mysql can do it? -- NiCK Set a DATE field with the time of expire. Then do something like SELECT * FROM users WHERE datefield_of_insert > CURDATE(); HTH Barry -- Smileys rule (cX.x)C --o

Re: MySQL Error

john simms wrote: Hello MySQL! Hello User! At last! It has taken a couple of days - but, I have, at last, found you. *hides* haha, you think so ... You have invaded my computer without being requested, or invited. Did i? Man, my schedules are really weird nowadays. Whenever I try to access

(WORKED) Re: InnoDB how to.

Prasanna Raj <[EMAIL PROTECTED]> wrote: Gotit Thnx ;) You have set innodb_force_recovery to 3 which means , do not run transaction rollbacks after recovery. http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html 1 (SRV_FORCE_IGNORE_CORRUPT) 2 (SRV_FORCE_NO_BACKGROUND) 3 (SRV_FORCE_NO_

Re: InnoDB how to.

Gotit Thnx ;) You have set innodb_force_recovery to 3 which means , do not run transaction rollbacks after recovery. Just try removing the innodb_force_recovery from my.cnf file or change the value More info : http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html --Praj On Wed, 5 Apr 20