RE: Way way OT

2001-08-31 Thread Chris Bolt
> > I am looking build my own E-mail Server for my Domain and would like > > some pointers > > > > Is there an E-mail Server that uses MySQL > > Exim, Postfix, and Sendmail can all use MySQL to varying degrees. > There are probably others. qmail; http://cr.yp.to/qmail.html, http://www.lifewithq

Optimum table and select

2001-08-31 Thread Edward Meyer
I have a table with the following columns id => int not null auto_increment stockid => integer tdate => date price => float primary key (id) key (productid) The table has 8,000,000+ rows holding 8000+ different stockids. I have to pull various information from the table the first que

RE: HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

2001-08-31 Thread Greennet
Pablo, Try this. The key part is putting LIBS="-lz" in. The rest of it was specific to my configuration. SSL_BASE=/usr/local/openssl-0.9.6b \ LIBS="-lz" \ ./configure \ (etc) Hope this helps! Eric -Original Message- From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]] Sent:

Re: MySQL Replication

2001-08-31 Thread Jeremy Zawodny
On Thu, Aug 30, 2001 at 12:49:15PM -0400, Luc Foisy wrote: > > Has anyone tested dropping a master database? By accident, yes. > I have dropped the master database that was replicating just to see > how it would affect the slave. The slave kept its data. Was it up-to-date with the master, or wa

Re: auto_increment

2001-08-31 Thread Jeremy Zawodny
On Fri, Aug 31, 2001 at 04:07:14PM -0500, Tony Bibbs wrote: > > can anyone tell me why an auto increment field would jump from 231 > to something large like 883607 and then give me failure on future > insertions because of a duplicate key? Sounds like a corrupt index. > I'm running mysql 3.23.39

Re: Problems Creating BDB Type Tables

2001-08-31 Thread Jeremy Zawodny
On Sat, Sep 01, 2001 at 05:30:16AM -, sameer ranadive wrote: > > Dear Sir, > > We are developing supply chain management where we are using EJB and > mysql as back end. We want to use transaction safe tables, but I > tried 'show variables;' command to know about table support for > mysql sup

Problems Creating BDB Type Tables

2001-08-31 Thread sameer ranadive
Dear Sir, We are developing supply chain management where we are using EJB and mysql as back end. We want to use transaction safe tables, but I tried 'show variables;' command to know about table support for mysql support. Only 'have_isam' is 'YES' all other are 'NO'. Does this means I did

Re: mysqld as root

2001-08-31 Thread Jeremy Zawodny
On Thu, Aug 30, 2001 at 02:12:33PM +0300, Sinisa Milivojevic wrote: > > > from the manual: > > F.2.26 Changes in release 3.23.15 > >  To start mysqld as root, you must now use the --user=root option. > > > > This does not seem to be true (tested on freebsd 3.23.41 etc), the > > reason I have a

Re: Licensing terms for an Intranet site

2001-08-31 Thread Jeremy Zawodny
On Thu, Aug 30, 2001 at 12:01:09PM -0400, Jay Fesco wrote: > > Is anyone else getting a strange flag associated with Jeremy's > email, or is it just me? Every one of his posts comes in flagged > in Outlook, and the headers have a line which reads: > > X-message-flag: Mailbox corrupt. Pleas

Solaris 2.6 /mysql-3.23.41 compile problems

2001-08-31 Thread Jeff Dickison
Hi everyone, I am trying to get mysql-3.23.41 to compile under Solaris 2.6 sparc with gcc 2.95.2 and have been running into some problems. Currently I am using this as my comfigure : ./configure --prefix=/usr/local/mysql \ --with-client-ldflags='-R /usr/local/lib'\ --enable-thread-safe-

Re: Way way OT

2001-08-31 Thread Jeremy Zawodny
On Fri, Aug 31, 2001 at 11:50:25AM -0600, [EMAIL PROTECTED] wrote: > > I am looking build my own E-mail Server for my Domain and would like > some pointers > > Is there an E-mail Server that uses MySQL Exim, Postfix, and Sendmail can all use MySQL to varying degrees. There are probably others.

NewLine between statements

2001-08-31 Thread Peter Harvey
MySQL Anyone know what the deal is with sending multiple statements to the server and getting errors at ";\n" on the first statement? Even the result will come back with something other than '\n' in error messages. I am using MyODBC but I am not certian that it is a MyODBC behaviour. Any pointe

Re: weird error that I have not encountered in 2 years

2001-08-31 Thread s . keeling
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote: > so how to fix the error ? > > How did file /usr/local/mysql/bin/mysql > > become a text file ? You tell us. Regardless, is your data still intact? Make sure it's safe, rip out mysql, and re-install. Binaries don't just "b

Re: weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam
so how to fix the error ? How did file /usr/local/mysql/bin/mysql become a text file ? chris - Original Message - From: "Lezz Giles" <[EMAIL PROTECTED]> To: "christopher sagayam" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, September 01, 2001 2:36 AM Subject: Re: weird err

cross-updates with replication

2001-08-31 Thread Todd Goldenbaum
hi, I am setting up replication between two servers, and I have it working for the most part- however- when I do cross-database updates, the changes don't go through to the slave. as in: use mysql; update test.test_table set a=1; I followed the instructions in the manual for replicating

Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Chris Johnson
I've used all three, Access, Oracle and MySQL. I have the least expertise with Access. My impressions are: * Access is very limited in what it can do with respect to real database manipulations, those contained in SQL. It does not handle large amounts of data well. Access is really a very fan

creating a new table from existing one

2001-08-31 Thread John Hunter
I have a database of minute by minute stock prices and I would like to summarize daily information in a 'daily' table, which contains information about the max, min, range of prices, total volume, etc... This works so far: CREATE TABLE daily ( ticker VARCHAR(8) not null, date DAT

novice join question

2001-08-31 Thread Russell Uman
i have three tables. products, class, and dept. class and dept each have two fields - code and text. products has a field named class (containing class codes) and a field named dept (containing dept codes) for some depts, all the products that have that dept have the same class for other depts,

Re: MySQL locks up

2001-08-31 Thread Jens Hjalmarsson
>> I just moved my databases from one machine to another. I recompiled >> the whole thing, but I have some problems. MySQL now locks up, and >> takes 100% cpu, after an hour or two. I need to shut it down and >> restart it, and then it goes another hour again. >> The machine is a dual pIII 866 wit

Qs: Time for ALTER, space requirements

2001-08-31 Thread Jeff Leung
Hi, I am running MySQL 3.23.14-alpha for Solaris 2.6 and am running into disk space problems with an ISAM table I have in it. Table info: 15.8M rows of datetime, varchar 16, varchar 64, varchar 128, varchar 64, varchar 64, varchar 32, varchar 15, varchar 32, varchar 64. So currently it is takin

Re: weird error that I have not encountered in 2 years

2001-08-31 Thread Lezz Giles
I'm not a mysql person, but I've seen similar stuff. I think that for some reason Unix thinks that the file you're trying to execute is not an executable, so it is trying to run it as a shell script. Try this first: file /usr/local/mysql/bin/mysql and when it tells you that it is a text file,

Re: Why there are no API-function for transactions?

2001-08-31 Thread Joshua J. Kugler
It's because the begin transaction and end transaction are SQL commands sent to the server, they are not C API functions. See http://www.mysql.com/doc/C/O/COMMIT.html j-k - On Friday 31 August 2001 04:04, Andre Konopka wrote: > Hi, > > maybe I'am wrong but I didn't find any transaction

server rejecting 15MB insert statement

2001-08-31 Thread Anthony Lau
Hello, I am trying to insert large TEXT data into a MySQL database. The server rejects insert statements that include a 15MB text file. The manual says to change "max_allowed_packet" for the server to accept large data. I have set this on the server side to 65535KB, which appears to be the larges

Re: DBUG_PRINT

2001-08-31 Thread Sergei Golubchik
Hi! On Sep 01, Mallikarjuna Rao N wrote: > Hi all, > How can I get the output of the DBUG_PRINT (which is > everywhere in the code of the mysql) option to > print the output as it is intended (functions and their > parameters) > and further extension to my question is how to get > separat

Re: MySQL locks up

2001-08-31 Thread Adams, Bill TQO
Jens Hjalmarsson wrote: > Hello, > > I just moved my databases from one machine to another. I recompiled > the whole thing, but I have some problems. MySQL now locks up, and > takes 100% cpu, after an hour or two. I need to shut it down and > restart it, and then it goes another hour again. > Th

weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam
can anyone please tell me what is happening here ? [root@ns dump]# /usr/local/mysql/bin/mysql /usr/local/mysql/bin/mysql: DROP: command not found /usr/local/mysql/bin/mysql: syntax error near unexpected token `(' /usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE TABLE bad

MySQL locks up

2001-08-31 Thread Jens Hjalmarsson
Hello, I just moved my databases from one machine to another. I recompiled the whole thing, but I have some problems. MySQL now locks up, and takes 100% cpu, after an hour or two. I need to shut it down and restart it, and then it goes another hour again. The machine is a dual pIII 866 with 2gb r

Re: WHERE IN ( MAX ) in MySQL

2001-08-31 Thread Chris Johnson
I think you will you have to do it in 2 steps using a temporary table. This is one of MySQL's biggest weak points. ..chris - Original Message - From: "Mattias Jiderhamn" <[EMAIL PROTECTED]> I have a table CREATE TABLE currency_rate ( currency_id VARCHAR(3), currency_date DA

DBUG_PRINT

2001-08-31 Thread Mallikarjuna Rao N
Hi all, How can I get the output of the DBUG_PRINT (which is everywhere in the code of the mysql) option to print the output as it is intended (functions and their parameters) and further extension to my question is how to get separate the DBUG_PRINT output(once I get it, I am sure there a

Re: HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

2001-08-31 Thread s . keeling
On Fri, Aug 31, 2001 at 05:37:58PM -0300, Pablo Javier Gonzalez Mateos wrote: > Hello, im in this situation: > > i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS > > when i compile the php with mysql everything works fine, but after y > compile the apache with this command: > > ./configu

Re: Trouble connecting to MySQL server using MySQLGUI and VCC

2001-08-31 Thread Chris Johnson
The remote hosts you mention are not allowed to access the database. This is a permissions problem, in particular the value of "hosts" in one of the permissions tables. It sounds like they only allow connections from the localhost or their own network. ..chris - Original Message - From

auto_increment

2001-08-31 Thread Tony Bibbs
can anyone tell me why an auto increment field would jump from 231 to something large like 883607 and then give me failure on future insertions because of a duplicate key? I'm running mysql 3.23.39 on RH 7.1 --Tony - Before po

RE: 'select * where x is null' not working

2001-08-31 Thread Don Read
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote: > Thanks for your quick response! More below.. > > Plus, all this just started happening yesterday, after everything worked > fine for many days. That leads me to believe there is a problem with a > corrupt table or something. How about t

HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

2001-08-31 Thread Pablo Javier Gonzalez Mateos
Hello, im in this situation: i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS when i compile the php with mysql everything works fine, but after y compile the apache with this command: ./configure --activate-module-=src/modules/php4/libphp4.module make and after a few seconds this error

RE: 'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik
Thanks for your quick response! More below.. > > mysql> select contact_info, expired from orders where order_num = '1'; > > +--+-+ > > | contact_info | expired | > > +--+-+ > > | NULL | NULL| > > +--+-+ > >

RE: 'select * where x is null' not working

2001-08-31 Thread Don Read
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote: > Weird things have just started happening in at least one table of my MySQL > 3.22.32 database. The symptoms are like this: > > mysql> describe orders; > +--+--+--+-+-+---+ >| Field| T

Rubi-con Technology/Security Conference

2001-08-31 Thread Denis Baldwin
MySQL'ers, I am one of the core members of the Rubi-con Security and Technology conference held in Detroit every year. At this year's conference, when asked what our attendees would like to see most next year, many of them said they wanted someone to explain how MySQL works, what it's ma

Berkeley or InnoDB?

2001-08-31 Thread Ary Medeiros
I'm porting an application to MySQL and I need to support transactions. I will appreciate so much if someone could give me some impressions about which one is better. BerkeleyDB or InnoDB? Thanks in Advance, Ary.

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Alexander Skwar
So sprach »s . keeling« am 2001-08-31 um 11:51:00 -0600 : > Is anyone else getting these goofy bounces from 123box.co.uk besides > me? Should I report them to Spamcop? :-) i'm getting these as well. > database, sql, ... Alexander Skwar -- How to quote: http://learn.to/quote (german) http:/

'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik
Weird things have just started happening in at least one table of my MySQL 3.22.32 database. The symptoms are like this: mysql> describe orders; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--

Re: Changing Database Location ?

2001-08-31 Thread David Turner
This is one thing I really can't stand about mysql. We should have the option when creating databases and tables of specifying where the database is located and the datafile and indexfile. Dave On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote: > On Fri, 31 Aug 2001, Peter Moscatt wr

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Colin Faber
Yes. "s . keeling" wrote: > > Is anyone else getting these goofy bounces from 123box.co.uk besides > me? Should I report them to Spamcop? :-) > > database, sql, ... > > -- > Any technology distinguishable from magic is insufficiently advanced. > [EMAIL PROTECTED] TopQuark Software & S

MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread s . keeling
Is anyone else getting these goofy bounces from 123box.co.uk besides me? Should I report them to Spamcop? :-) database, sql, ... -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software & Serv. Contract programmer, server bum.

Way way OT

2001-08-31 Thread massey
Way OT but I had to ask the Red Flag got my Attention. I am looking build my own E-mail Server for my Domain and would like some pointers Is there an E-mail Server that uses MySQL What is the easyest to setup, I do not need a full blown one to handle lists and such and my Client can connect t

mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-08-31 Thread Simon J Mudd
I've not been using mysql for some time but did have it running for a couple of small databases I use at home. It doesn't appear to work now, the most obvious sympton being that msyqlshow shows a list of blank table names. [root@phoenix mysql]# rpm -q redhat-release redhat-release-7.1-1 [root@ph

Re: Changing Database Location ?

2001-08-31 Thread Simon J Mudd
On Fri, 31 Aug 2001, Peter Moscatt wrote: > Can you change the location of a MySQL database ? The default is > '/var/lib/mysql'. The easy way I've always used is to change the name of the /var/lib/mysql directory and make a symbolic link to another directory. You need to reset up the mysql dat

Changing Database Location ?

2001-08-31 Thread Peter Moscatt
Can you change the location of a MySQL database ? The default is '/var/lib/mysql'. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: mysql_connect () and mysql_pconnect are not recognized ! Pls help.

2001-08-31 Thread Tony Wells
It sounds like the PHP module was compiled without MySQL support. root wrote: > > Hi, > > I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from > an RPM. > My problem is whenever I try to call mysql_connect (), from a php3 > script, I got the error function not found or misco

Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Adams, Bill TQO
Gene Gurevich wrote: > them to Oracle. The developers are now considering > switching from Access to MySQL and I'm trying to > figure out what are the advantages of that move. I Any DB is better than Access for a sizable table. Once access gets to about 100k records in a table it completely bom

RE: MySQL vs Oracle vs Acess

2001-08-31 Thread Simon Green
OK Well as you know MySQL has less bells and whistles vs oracle. This makes it very fast. The other thing with MySQL is that it is very reliable. The last thing is that it can deal with very big databases. So if you need a very fast DB but not all the stuff of oracle MySQL is you database. We use

Re: Access and MySQL

2001-08-31 Thread Adams, Bill TQO
Stephen Johnson wrote: > I have a client that uses an Access dB in house and wants that database to > automatically update a MySQL database that I am creating for their website. > Is this possible and if so where can I find some reading material on how to > accomplish it? > > Thanks for the info

Re: Access and MySQL

2001-08-31 Thread Paul Groves
/ - Original Message - From: "Stephen Johnson" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 4:29 PM Subject: Access and MySQL > I have a client that uses an Access dB in house and wants that database to > automatically update a MySQL database that I

MySQL vs Oracle vs Acess

2001-08-31 Thread Gene Gurevich
Hi This is a very generic quesiton and I would appreciate any info. I am an Oracle dba; our developers are now using access for their own small projects. When these projects grow and become too large for Access we move them to Oracle. The developers are now considering switching from Access to M

Access and MySQL

2001-08-31 Thread Stephen Johnson
I have a client that uses an Access dB in house and wants that database to automatically update a MySQL database that I am creating for their website. Is this possible and if so where can I find some reading material on how to accomplish it? Thanks for the information -- Stephen Johnson

Re: problems with perl DBI:DBD mysql

2001-08-31 Thread Rodney Broom
From: Rudy Metzger <[EMAIL PROTECTED]> > ERROR MESSAGE --- > Can't locate auto/DBI/do.al in @INC... It sounds like your DBI didn't get built correctly. If you think that it probably was built right, then you can start by trying to find do.al:

Re: safe_mysql not working properly, can any body help

2001-08-31 Thread dwilkers
Plesae review your log files! On Fri, 31 Aug 2001, nirav shah wrote: > Dear friends, > > I have got mysql current 3.23 version installed > with linux in my pc. > > but it is not working properly when i give > command > > $ safe_mysqld > > Here after few seconds, it dis

Re: Virtualizing MySQL

2001-08-31 Thread Kyle Hayes
On Thursday 30 August 2001 14:09, Mustafa Hashmi wrote: > Thanks for the response Joshua, > > That is an option - however not one I would be very comfortable with. I > have a similar setup for virtual hosts generally - wanted something more > flexible and powerful for a virtual server implementati

Internet Usage Surging and Outsourcing Web Hosting Saves Millions!

2001-08-31 Thread info
It's been a hot summer indeed, not only for the weatherman, but for Internet folks as well. The latest round of economic warnings come at a time when everyone has been once again scared by the media. Don't believe all the hype that you hear on the news. As a matter of fact, a surprising new st

order by...group by...complicated query

2001-08-31 Thread hassan el forkani
hi, i am trying to build a message board in php with mysql as back end; what i want to do is to query the database in a certain way that the result is returned in the correct order for php to display the discussion thread properly here is my table structure: mysql> show fields from posts

Re: Why there are no API-function for transactions?

2001-08-31 Thread Heikki Tuuri
Hi! Sending SQL strings in PHP like "set autocommit=0" "commit" "rollback" seemed to work for Andre. Regards, Heikki http://www.innodb.com -Original Message- From: Andre Konopka <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Date: Friday, August 31, 2001 3:32 PM Subject: Re:

Re: problems with perl DBI:DBD mysql

2001-08-31 Thread dwilkers
Hi, I am sure there are cleaner ways, but this works for my scripts just fine. use DBI; $drh=DBI->install_driver('mysql') || warn "no Driver\n"; $dbh=$drh->connect("search:localhost","user_1") or warn "No connect\n"; $cursor=$dbh->prepare("select email from opt2 where resend=100"); $cursor->ex

Query Question

2001-08-31 Thread Carl Schrader
I'm doing a query like: select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE '%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title What I need is to have the results that match Title LIKE '%TOMMY%' to appear first and then the rest. I have been doing 2 separate queries and filtering the

Why there are no API-function for transactions?

2001-08-31 Thread Andre Konopka
Hi, maybe I'am wrong but I didn't find any transaction-oriented C-API functions??? How can I build a web transaction application with MYSQL/INNOBASE? I would prefer PHP, but PHP uses the C-library to connect to mysql and there are no transaction C-API functions... Thanks Andre ---

problems with perl DBI:DBD mysql

2001-08-31 Thread Rudy Metzger
maybe not the 100% correct list, but then again... SCRIPT - #!/usr/bin/perl -w use DBI; my $dbh = DBI->connect( "DBI:mysql:database=xxx", "xxx", "xxx" ) or die( "Cannot connect

Re: safe_mysql not working properly, can any body help

2001-08-31 Thread Joshua M . Schmidlkofer
You need to look at the mysql error log, usually in your data directory. 99% of the time, if this is your first attempt to use MySQL you don't have the permissions tables created yet. There should be a mysql_install_db script that cam with your system, see if you have that, and try running

Re: Window-based client program for MySQL (server in Linux)

2001-08-31 Thread j.urban
There is indeed a PHP client called PHPMyAdmin (http://www.phpwizard.net/projects/phpMyAdmin/) and there are several Windows-based clients including urSQL (http://www.urbanresearch.com/ursql). On Fri, 31 Aug 2001, Biniam Gebremichael wrote: > > I have MySQL server installed in my linux box.

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Martin MOKREJŠ
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote: > =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > > Hi again, > > I have the following problem: > > > > "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert >--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum" > >

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > And should say that > > update rep set low='0.00' where id=148; > > solved my problem for command: > mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert > --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum >

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Martin MOKREJŠ
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote: > May be you used some special chars in column names. In that case you > should use instruct mysqldump to use backticks for table and column > names. Ehh, now I know what you meant: - to use -Q option to mysqldump , ok but it anyway did not hel

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > On Fri, 31 Aug 2001, Sinisa Milivojevic wrote: > > Ehh, now I know what you meant: - to use -Q option to mysqldump , ok > but it anyway did not help. > > I'm pretty sure the problem is with text "nan" being in place of a float > number. > > --

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Martin MOKREJŠ
And should say that update rep set low='0.00' where id=148; solved my problem for command: mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum ... to be complete. ;) -- Martin Mokrejs - PGP5.0i key i

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > On Fri, 31 Aug 2001, Sinisa Milivojevic wrote: > > Ehh, now I know what you meant: - to use -Q option to mysqldump , ok > but it anyway did not help. > > I'm pretty sure the problem is with text "nan" being in place of a float > number. > > --

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > Hi again, > I have the following problem: > > "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert >--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum" > ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

Re: duplicate delete query

2001-08-31 Thread Gerald Clark
ALTER IGNORE TABLE mytable ADD UNIQUE (email); will both add a unique key ( which will avoide this problem in the future ) and delete the duplicates. Rory O'Connor wrote: > excuse me if this is too newbie...but I need to perform a duplicate > delete on my database using the e-mail address as

Re: just starting problem - WinNT

2001-08-31 Thread Gerald R. Jensen
Neil: Did you add c:\mysql\bin to your system's path? The installer does not. Did you install MySQL as a service (c:\mysql\bin\mysqld-nt --install) and start the service (net start mysql)? Gerald Jensen - Original Message - From: "Neil Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > Hi again, > I have the following problem: > > "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert >--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum" > ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

Problem with MySQL

2001-08-31 Thread Ghislain Gadbois
Description: I use the MM JDBC driver version 2.0.4 to access my MySQL database from my Java app. If I do "SELECT NOW()", it returns a String object and not a Date object. I tried to call different functions (e.g. "SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)") in order to have a Date in m

user defined data types

2001-08-31 Thread Ravi Pawar
I am a Sybase user who has recently shifted to MySQL. I searched and searched but couldn't get the answer to my question. Question is: Q -> How do I declare a User Defined Data Type? In sybase the procedure is: sp_addtype names, "char(40)", "not null" go Here names becomes a user defined datatyp

safe_mysql not working properly, can any body help

2001-08-31 Thread nirav shah
Dear friends, I have got mysql current 3.23 version installed with linux in my pc. but it is not working properly when i give command $ safe_mysqld Here after few seconds, it displays message that mysqld ended. So i am not able to start the server. When i verified m

WHERE IN ( MAX ) in MySQL

2001-08-31 Thread Mattias Jiderhamn
I have a table CREATE TABLE currency_rate ( currency_id VARCHAR(3), currency_date DATE, currency_rate NUMERIC(16,8), PRIMARY KEY (currency_id, currency_date) ); and want to list the latest registered rates of all currencies. Normally I would go about like this: SELECT curr

Re: Is this a bug?

2001-08-31 Thread Sinisa Milivojevic
Jeremy Zawodny writes: > On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote: > > Hi People, > > > >I'm trying to execute this Simple query: > > > > SET SQL_SAFE_MODE=0; > > > > The server doesn't like it; However, SET any other option will work fine > > except this one. > >

MYSQL crashes-SOLUTION found!

2001-08-31 Thread moka
I am posting this in the hope it will be useful; I seem to have solved the problem. The problem was(on 3.23.38) and Linux 2.2.18 or 2.4.0 This is a huge system, all SCSI, 2GB or RAM, 2PIII x1000MHz processors and 37GB in the volume group corresponding to /var/lib/mysql There is an AHA2916

Re: just starting problem - WinNT

2001-08-31 Thread alec . cawley
> I am using, well trying to use mysql through WinNT. I have > successfully installed mysql and have had a look at the client > programs provided with the package. I'm trying to use mysql > through the DOS command prompt under Windows but when I type > C:\mysql I get an error message saying that

is there facility with replication?

2001-08-31 Thread Kiyoko Takanabe
Dear all. about to load sharing DB server, I'd like to use facility which automatically part and execute requests from client , such as : update -> Master?load ->Slave. previously, Client > Master --- Slave ^ update|--- Slave |

Re: just starting problem - WinNT

2001-08-31 Thread Paul Groves
- Original Message - From: "Neil Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 12:11 PM Subject: just starting problem - WinNT > I am using, well trying to use mysql through WinNT. I have > successfully installed mysql and have had a look at the client

just starting problem - WinNT

2001-08-31 Thread Neil Davies
I am using, well trying to use mysql through WinNT. I have successfully installed mysql and have had a look at the client programs provided with the package. I'm trying to use mysql through the DOS command prompt under Windows but when I type C:\mysql I get an error message saying that 'it's a

ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

2001-08-31 Thread Martin MOKREJŠ
Hi again, I have the following problem: "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert --quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum" ERROR 1054 at line 52: Unknown column 'nan' in 'field list' I have even tried "OPTIMIZE TABLE REP; REPAIR TABL

Re: Window-based client program for MySQL (server in Linux)

2001-08-31 Thread Arjen G. Lentz
Hi, - Original Message - From: "Biniam Gebremichael" <[EMAIL PROTECTED]> > I have MySQL server installed in my linux box. And want a windows based > client program that can be used to create and modify table designs and > other functions. > Is there any PHP client for such purpose A ve

Re: Support Contracts

2001-08-31 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > Anyone, > > I apologize for broadcasting to the group, but I've been trying to set-up a >maintenance contract > and licenses for about a month and no-one seems to be listening to the sales and >licensing > e-mail drops for MySQL AB Company. > > I assume those that

Unknown database problem

2001-08-31 Thread Artem Koutchine
Hi! I having a very weird unpredictable problem. A script run from cron at 2:00am every day must conect to database 'ubex' and do some stuff with it. The script is in perl and uses DBI. It works fine pretty much all the time but sometimes (1 or 2 time per month) it gives an error: Unknown databa

Window-based client program for MySQL (server in Linux)

2001-08-31 Thread Biniam Gebremichael
I have MySQL server installed in my linux box. And want a windows based client program that can be used to create and modify table designs and other functions. Is there any PHP client for such purpose or any library to enable Microsoft Access to interface the server. Thanks Biniam ---

Is replication inteligent enough for ..... ?

2001-08-31 Thread Warren van der Merwe
mysql Hi I have a triangluar replication system working 100%, A -- > B, B -- > C, C -- > A. What I know want to know is, is replication intelligent enough that if A had to sometimes connect to C, and replicate, and then the next day connect to B again, and so on and so on, would everything st

Work Smarter Not Harder? Consider this....

2001-08-31 Thread reports12345
Dear Friends & Future Millionaire: AS SEEN ON NATIONAL TV: Due to the popularity of this letter on the Internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investig

Please help me , about mysql replicate!

2001-08-31 Thread Wang Aocheng
Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! wac - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Reply-to and this list

2001-08-31 Thread Jason Brooke
> There is also a famous document about reply-to: > > http://www.unicom.com/pw/reply-to-harmful.html Here's another point of view as well: http://www.metasystema.org/essays/reply-to-useful.mhtml As little as it has to do with databases, just for the record I'm on a bunch of lists - some munge r

Re: how to write procedure.

2001-08-31 Thread Jean-Luc Fontaine
Carl Troein wrote: > On 31-Aug-01, G.S.Murthy wrote: > > >>Hi >>I was unable to write stored procedures in windows version of mysql. How >>to write a stored procedures in winmysql version. >> > > Did you read the manual? There's no such thing as stored procedures > in MySQL. Who told you that t

Re: how to write procedure.

2001-08-31 Thread Carl Troein
On 31-Aug-01, G.S.Murthy wrote: > Hi > I was unable to write stored procedures in windows version of mysql. How > to write a stored procedures in winmysql version. Did you read the manual? There's no such thing as stored procedures in MySQL. Who told you that there is? :-o //C - points out that

Re: Reply-to and this list

2001-08-31 Thread Carl Troein
On 31-Aug-01, Claudio Cicali wrote: > There is also a famous document about reply-to: > > http://www.unicom.com/pw/reply-to-harmful.html Hmm.. good point, but it says nothing about using from: rather than reply-to. I guess the same arguments could be applied tho. Maybe I should just bring my A

Re: myisampack dumps core on some tables

2001-08-31 Thread Martin MOKREJŠ
On Fri, 31 Aug 2001, Michael Widenius wrote: > > "mmokrejs" == mmokrejs writes: > > mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote: > mmokrejs> Hi, > mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was > mmokrejs> probably too big? I haven't found an

how to write procedure.

2001-08-31 Thread G.S.Murthy
Hi I was unable to write stored procedures in windows version of mysql. How to write a stored procedures in winmysql version. My mail id is [EMAIL PROTECTED] please mail if any one knows. GSMurthy - Before posting, please che

  1   2   >