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: > 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 '/apache

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 -p lefeber But let's see who of us are right =) Sincerely, Jan -- Mr. Jan-Aa

Re: Symbolic Links to Data

2001-11-25 Thread jaab
Martyn, On Sun, 25 Nov 2001, Martyn Wendon wrote: > No problems in general with the installation. Everything has been working > fine, I need to move the database files as I am running out of space on the > /var partition. This is surely an access rights problem. If you'd su to the user running

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 stron

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 > >

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 t

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: DBMS that integrates well with object-oriented programming

2001-11-15 Thread jaab
Dear Bennett, On Thu, 15 Nov 2001, Bennett Haselton wrote: > After converting the data in my project from text files to MySQL tables, > things are certainly working more smoothly than they were before, but since > I use objects (in Perl, which barely supports objects, but that's another > story)

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: innodb on linux raw partitions

2001-08-21 Thread jaab
On Mon, 20 Aug 2001, Matt Wagner wrote: > It has been a great combination for me. Although I've never gone thru > an HD crash/recovery with this setup yet... :) Well, I just did, and it works like a charm. There is only one thing to watch out for: if you restart the system with the failed disk di

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 O

Re: MySQL working on a cluster

2001-06-11 Thread jaab
On Thu, 7 Jun 2001, Nelson Gomes wrote: > On a cluster, is it possible to have several MySQL instances (one per node) > each having several mysqld processes, working concurrently on NAS (network > storage) device, that is mounted on every node, and accessed through a > shared filesystem ?? > > How

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 ur

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",

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 /var/li

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 r