Re: date calculation

2001-11-29 Thread jaab
On 29 Nov 2001, [EMAIL PROTECTED] wrote: I need to calculate the difference in seconds for two registers type datetime, My question is if exists some function or trick on mysql for perform it? I need this for calculate some information about time for a billing system so I need precision of

RE: HELP! Hosed Database!

2001-11-26 Thread jaab
On Mon, 26 Nov 2001, john wrote: use: cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber I have this strange feeling that the line should read cat lefeber.txt | /apache/mysql/bin/mysql -u user -ppass lefeber But let's see who of us are right =) Sincerely, Jan -- Mr.

RE: HELP! Hosed Database!

2001-11-26 Thread jaab
On Mon, 26 Nov 2001, john wrote: my mistake, I copied the line and forgot to remove the first lefeber. Mmm no, what I was referring to was that Ben might be confusing installation directory with mysql binary location. I think we all mean the latter in this case. Which would then be

Re: InnoDB Compiler error (as well)

2001-11-23 Thread jaab
Ashley, On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: And while I'm sure someone is bound to tell me to stop using RedHat's GCC 2.96 because of bad code, I'm sorry. Everything else that I need/use compiles just fine and I never have problems with them, except MySQL. I would strongly

Re: localhost problem

2001-11-21 Thread jaab
On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why why why? http://www.pafo.net/mysql4.gif i am running, win98, p-III 1000, 512ram, the latest mysql, using tiny personal firewall and i am connected thru a

Re: localhost problem

2001-11-21 Thread jaab
On Wed, 21 Nov 2001, Pafo wrote: am still getting the same message http://www.pafo.net/mysql5.gif Try without the password. As below, mysql -u root. On Wed, 21 Nov 2001, Pafo wrote: i still cant get pass this problem, i have now uninstalled PWS and still i cant access why why

Re: What maintenance is needed for MyISAM tables?

2001-11-16 Thread jaab
On Thu, 15 Nov 2001, Rick Robinson wrote: I'm using a MyISAM table in a high availability environment as a rudimentary persistent FIFO queue. The table definition is simple - the key is an auto_increment unsigned bigint and the data is a blob (it holds the contents of a C structure with a

Re: What sites?

2001-10-18 Thread jaab
On Thu, 18 Oct 2001, Philip Johannessen wrote: Im currently in a debate with someone who prefers PostgreSQL. He says that MySQL is unstable etc. Can you please give me examples of some well known sites built on MySQL so I can tell him that MySQL rocks? Have a look at http://www.20min.ch/.

Re: What does tmp_table_size *really* do?

2001-06-16 Thread jaab
On Fri, 15 Jun 2001, Dan Nelson wrote: 30 seconds of cscope browsing on the mysql source shows the follwing ^^ What is cscope? Where can I get it? =) Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich

Re: Question for a MYSQL expert (I assume this list has some)...

2001-06-03 Thread jaab
Dear Kenneth, did you ever consider looking at other technologies than the database driven one? Javaspaces seems to me a very interesting solution for handling distributed storage, and your case seems to be difficult to handle from a database-centric point of view. If you're interested, these

RE: Insert Automatically

2001-05-31 Thread jaab
Dear Kal, On Thu, 31 May 2001, KAMRY wrote: database,sql,query Is it possible to do a script file like in Oracle with statements like these: insert into countries (id,country,country2) values(IDDI, Venezuela, ); insert into countries (id,country,country2) values(IDDI, Vietnam, ); insert

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Mike Trotzke wrote: Never actually reads CONNECTED, even after hours. I suspect this has something to do with the problem. Permissions are currently wide open as follows (though I've tried everything): /var/ drwxr-xr-x root root

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Jeremy Zawodny wrote: Unfortunately didn't solve it for me. :( I tried copying /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting... same behavior. Damn, I was looking forward to going out celebrating :-). *dang*. Ok. You did do a myisamchk -eoB