Info about MYSQL and MyOLEDB

Dear sirs, we produce software for the Public Administration, and are conducting some test in order to decide our development strategy. At the moment we are testing the compatibility of our .NET products and your DB engine (MySQL) installed on a Linux server, using the MyOLEDB provider. Our probl

Re: basic question

Make it TIMESTAMP But remember that this data type gets updated every time the record is changed. Hope this helps. Thanks Emery - Original Message - From: "Edward Peloke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 5:50 PM Subject: basic question > sql qu

possible conversion error ?

HI ALL, I have an interesting question : I have a program that does dumps information to a flat file ( a lot of information) and a another that runs as as daemon and inserts the data from the flat file into a mysql server. a line from the flat file looks like : TIME="20021010 15:28:53.059", I

Not able to connect

Hi all, I am not able to connect to my database using the IP no of my machine using the following PHP script. I have recived the error exlained below when I tried to connect the database. But When I changed the host name as "localhost", I was able to connect. Please suggest how to overcome th

how to get all tables

Hello, What is the sql command which is the same as command "show tables" ? Other database stores all tables in a system table, is there one in mysql ? Thanks, Tom __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.y

[Q] To check whether slave replacates correctly or not.

Hi guys, I'd like to set up master-slave replication with two servers using MySQL 4.0.4. I'll make some scripts, which monitors if slave does replication well. But I'm not sure how to do that. Anybody can suggest some tricks or ideas? -- Chung Ha-nyung Sayclub

Re: Are there ANY terminal-based frontends for Linux?

Hi, Lots of people will end up wanting to forget about the terminal part of your question and just say MS Access. I would not love to have to deal with a large number of people using Access, even with mySQL behind it. Maybe you can find something that uses the ncurser lib? That would be my fir

Re: Stored Procedures

I believe you'll be waiting until version 4.1.0 for full Stored procedures support. At that point I'm not sure what we'll be waiting for. There are a few features that will be missing, but they will be the kind of things that financial institutions need, IIRC. Most of us won't care about those.

Error building on Solaris sparc 9

Hi everybody there! This isn't the first time I build mysql on Sparc-Solaris but is the first time on Solaris 9, following the manual suggestions I build gcc-3.2 on the same box as well as gnu-binutils-2.13, but I'm not being successful on mysql-3.23.52. Does any body have an idea of what's t

RE: Lost connection to MySQL server during query

Hi, How did you solve the problem, Lost connection to MySQL server during query, please let me know this i am facing the same problem. thanks, swati --- Vernon Webb <[EMAIL PROTECTED]> wrote: > Sorry all! > > I have resolved the issue. > > -- Forwarded Message --- > From: "Ver

Are there ANY terminal-based frontends for Linux?

Are there ANY MySQL terminal-based frontends (for Linux) that will allow inputting data via forms, queries,reports? There are a lot of administration tools - that's not what I want. How do I set something up for inputting and simple queries that takes advantage of the *relational* database? The

Re: Problems with local-infile

At 22:57 -0400 10/13/02, Edward C. Jones wrote: >I have installed mysql-3.23.52 as part of the Gentoo Linux >distribution. I am accessing MySQL via mysql-python AKA MySQLdb >which calls the MySQL C API. During testing I start MySQL using >"safe_mysqld" and shutdown MySQL using "mysqladmin -u ro

Problems with local-infile

I have installed mysql-3.23.52 as part of the Gentoo Linux distribution. I am accessing MySQL via mysql-python AKA MySQLdb which calls the MySQL C API. During testing I start MySQL using "safe_mysqld" and shutdown MySQL using "mysqladmin -u root --password= shutdown". When I do a "LOAD

Interview with MySQL designer Monty Widenius

Just wanted to let the list know of an opportunity to ask any questions you want of Monty Widenius. For those that may not know, Monty is the designer and lead programmer for MySQL. You can submit your questions to: http://codewalkers.com/interviews/Monty_Widenius.html All questions will be vote

Re: Stored Procedures

MySQL does not support stored procedures. - Original Message - From: "Ian Hagan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 13, 2002 7:10 PM Subject: Stored Procedures Hello All List Members, My name is Ian Hagan. I am a database developer specialising in Delphi.

OK... stuck on can't connect from client

I'm on Linux Redhat 7.2 and MySQL v. 3.23.41 I can make connections from the server... including the use of other hostnames for test purposes. All my PHP/MySQL sites are up and running. I can access the database through phpMyAdmin. I cannot connect from a client app such as Mascon. I notice that

Stored Procedures

Hello All List Members, My name is Ian Hagan. I am a database developer specialising in Delphi. I am new to Mysql. (Using a Windows 98 platform; installed version 3.23.51-max) Can anyone help me with stored procedures in Mysql?? The Manual does not contain much info and refers me to several exa

RE: Lost connection to MySQL server during query

Somehow MySQL got broke and by removing MySQL and reinstalling it, removing the /var/lib/mysql folder and restaring MySQL put me back at the where it was once I first configured MySQL. Then I copied the database folders back to the folder, but I had changed the password and forgot to change

RE: Lost connection to MySQL server during query

At 17:29 -0500 10/13/02, Vernon Webb wrote: >Sorry all! > >I have resolved the issue. Don't leave us hanging. How? > >-- Forwarded Message --- >From: "Vernon Webb" <[EMAIL PROTECTED]> >To: "MySQL List" <[EMAIL PROTECTED]> >Sent: Sun, 13 Oct 2002 17:18:16 -0500 >Subject: Lost con

RE: Lost connection to MySQL server during query

Sorry all! I have resolved the issue. -- Forwarded Message --- From: "Vernon Webb" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sun, 13 Oct 2002 17:18:16 -0500 Subject: Lost connection to MySQL server during query After spending the entire day trying to figur

Lost connection to MySQL server during query

After spending the entire day trying to figure out what the you-know-what has happended to MySQL on my box, and after throughly messing things up and fixing them again it has come down to a final error message when trying to access some databases (some mind you, not all): Lost connection to My

Re: full-text search problems (newbie)

On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote: > Hi! > > On Oct 13, Alan wrote: > > > > mysql> select title from content where match > > (title,center_content,right_content) against ('updates'); > > +-+ > > | title | > > +-

Re: full-text search problems (newbie)

Hi! On Oct 13, Alan wrote: > > mysql> select title from content where match > (title,center_content,right_content) against ('updates'); > +-+ > | title | > +-+ > | eXI Systems' Latest Updates | > +-

Re: full-text search problems (newbie)

On Sun, Oct 13, 2002 at 02:48:38PM -0500, Paul DuBois wrote: [snip] > >As far as I can tell, this *should* be working. Can anyone help please? > > Try dropping the FULLTEXT index and then add it again. (Alternatively, > dump and reload the table). I did drop the table this morning, just in cas

Re: full-text search problems (newbie)

At 11:11 -0700 10/13/02, Alan wrote: >Hi folks, new to the list, hoping I'm posting to the right one. > >I've been using the full-text search for a clients site and it works >great... the only problem is I want to change the minimum word length >from 4 to lower, such as 2 or 3. Reading the docs t

HA in MySQL

Hello @ll, I need to build a simple HA (High Availability) scheme to be used in a database environment. What I need to have is a database server (I'd like to run MySQL, that's the reason I'm posting here) with fail-over. So I'll have two real servers (ServerA and ServerB) running Linux and som

Re: innodb not using correct index

Walt, - Original Message - From: "walt" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, October 12, 2002 11:20 AM Subject: innodb not using correct index > Is there a way to find out what index an sql query is using? I know you can > use explain, but those are jus

Re: Mysql problems

Are you sure mysql owns all the .frm files ? mike wrote: >I am getting: > >./bin/myisamchk: error: 'data/mckesson/tempbak.frm' doesn't have a >correct index definition. You need to recreate it before you can do a >repair > >on a number of my tables. I have recently imported this data, from a >

Re: Repair TABLE - OPERATION FAILED

perror 28 Error code 28: No space left on device tl wrote: >Hello, >Please help me. > >mysql> repair table none; >+++--+-+ >| Table | Op | Msg_type | Msg_text| >+++--+---

Re: ROW LEVEL Locking not affected

Shilline, - Original Message - From: "Shilline Lee" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, October 13, 2002 7:16 AM Subject: ROW LEVEL Locking not affected > > Hello all: > > I did a row level lock with my database ( MySQL-4.0.3-beta with InnoDB ) > but

Re: comma-separated keys?

On 10 Oct 2002, at 21:28, Jan Peuker wrote: > normally two tables are joined by two singular keys, for instance "id" > which is (1) in both tables. But how do I join them over a id-field > like this:(1,2,4)? I know, there is the WHERE id IN(...) function, but > if I do a: > SELECT dogs.name FROM

Re: InnoDB indexing questions

Lourdes, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, October 11, 2002 11:38 PM Subject: InnoDB indexing questions > Hello, > > I have some doubts about the index behaviour in InnoDB. > > I have a table named 'Albaranes'. The definition

RE: MySQl db as filesystem.

> -Original Message- > From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 11, 2002 5:53 AM > To: Ed Carp > Cc: [EMAIL PROTECTED] > Subject: RE: MySQl db as filesystem. > > On Fri, 2002-10-11 at 10:06, Ed Carp wrote: > > > > At 12:58 +0200 10/10/02, Alex Polite w

Performance when using two BETWEEN statements in the WHERE clausemultiple times

I sent a similar question a few days ago. I don't think there was a response. If there was, sorry that I missed it. I have worked around the issue, but would like to know whether there is something I can do to improve the orignal query. I have a table with two spatial indices -- ra and decl

Re: Alternative for NOT EXISTS

John Ragan wrote: >try corereader. it will run queries against your >mysql, oracle, and ms sql server (and anything else >laying around). you can switch between your servers >with a click. > > Am I the only one getting tired of these non-SQL related advertising responses? Feel free to pu

re: Re: I could't find my.cnf

Perumal, Friday, October 11, 2002, 2:06:49 PM, you wrote: P>Please give me an idea for the below problem. P> I installed mysql-max on linux machine, but mysql.sock file is not P> available in /temp directory. It gives 'Can't connect to local mysql server P> through socket 'temp/mysql.s

re: Mysql problems

mike, Friday, October 11, 2002, 12:19:40 AM, you wrote: m> ./bin/myisamchk: error: 'data/mckesson/tempbak.frm' doesn't have a m> correct index definition. You need to recreate it before you can do a m> repair Don't use myisamchk with *.frm files! m> on a number of my tables. I have recently im

Mysql 4.0.4 + InnoDB leads to corrupted tables ?

Hi, I recently updated from 4.0.3 do 4.0.4 . everithing was running fast ans smooth (as always). Then I enabled for the first time the InnoDB feature. I was surprised to find out that everithing worked fine from the very beginning. The next day I start having "handler error" on non-inno tables

hints for converting to mysql

Hello, Does anyone have any pointers or links to "how-tos" for converting from a microsoft sql server to mysql? I know it's much more complicated than simply "converting", but I was just looking for pointers. Basically we have an accounting system that was written for us by an employee. Hes a Mic

full-text search problems (newbie)

Hi folks, new to the list, hoping I'm posting to the right one. I've been using the full-text search for a clients site and it works great... the only problem is I want to change the minimum word length from 4 to lower, such as 2 or 3. Reading the docs this is simple, and I followed the instruct

re: Repair TABLE - OPERATION FAILED

tl, Friday, October 11, 2002, 11:55:41 AM, you wrote: t> mysql> repair table none; t> +++--+-+ t> | Table | Op | Msg_type | Msg_text| t> +++--+-

re: transer db problem

Aaron, Thursday, October 10, 2002, 9:18:48 PM, you wrote: AB> I setup a mysql db on an i386 box. After a while, I AB> needed to transfer that db to an s390 box. So I went AB> ahead with the mysqldump, etc.. and when I transferred AB> the db, I noticed that on the s390, the fields that AB> recor

RE: MySQl db as filesystem.

On Fri, 2002-10-11 at 17:07, Ed Carp wrote: > > Should'nt be too hard to do thanks to PODFUK® AKA uservfs: > > Just goes to show you that Linux is so flexible, any hare-brained idea can be >implemented in software . But you didn't answer > my question - why would you want to do such a thing?

Re: Problem with mysql jdbc Connector

janesh wrote: > HI > I am accessing mysql through Websphere 5.0 through jsp file . it says > SQLException: Cannot connect to MySQL server on host:3306. Is there > a MySQL server running on the machine/port you are trying to connect to? > (java.security.AccessControlException) > SQLState: 08S01 >

Dynamic output detail menus from a MySQL output page.

Howdy all! I'm trying to make my table-outputted page of data from my database have a MouseOver menu. (ie Column1 2 3 4 data1 a b c data2 g h j ) Currently all the data has a dynamically created link to the search again (so I can search f

basic question

sql query when I am defining a table, how do I set the default of a datetime column to the current time? I tried setting the default to now() but it just fills the column with 00:00 etc.. Thanks, Eddie - Before posting, plea

Re: Mysql 4.0.4 + InnoDB leads to corrupted tables ?

Andrea, - Original Message - From: ""Andrea Forghieri"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, October 12, 2002 2:02 AM Subject: Mysql 4.0.4 + InnoDB leads to corrupted tables ? > Hi, > > I recently updated from 4.0.3 do 4.0.4 . > everithing was running f

Re: I could't find my.cnf

Start the server. Are you sure that is not /tmp/mysql.sock ? If not then make sure the directory exists, and start the server. Perumal wrote: >Dear sir, > > Please give me an idea for the below problem. > > I installed mysql-max on linux machine, but mysql.sock file is not >available in

Storing results from a Query in an existing Table

Hello All: I have learned to extract columns from one table and create a new table from those columns->i.e: CREATE TABLE Wines SELECT Country,Varietal,Producer,Vineyard,Year,Size FROM AH; Now I would like to SELECT the same columns from other tables and "append" them to Wines. I have trie

REGEXP

Hello, mysql>LOAD DATA LOCAL INFILE 'access.log' INTO TABLE tmp FIELDS TERMINATED BY 'REGEXP \"^[ ]{1,}$\"' OPTIONALLY ENCLOSED BY '' ESCAPED BY ' ' LINES TERMINATED BY '\n' ; How can I make that it would work as I expected? How terminate fields by space(s)? Thanks Very much. Alvydas ---

Re: MySQl db as filesystem.

Jan Steinman wrote: > Today's "modern" operating systems really stopped evolving in the 80's. Many ideas >like database filesystems never really got a chance to show their utility. isn't the next windows operating system (longhorn) supposed to have a new filesystem that's based on SQL Server? i

Re: LOAD DATA INFILE problem

* Clayburn W. Juniel, III <[EMAIL PROTECTED]> [021012 07:30]: > >I am attempting to delete a table from a database, > >then recreate it and load data into the table. > >The drop and create commands are working properly, > >here's a screen dump: <..> > >mysql> LOAD DATA INFILE > >"

Re: Lost connection to MySQL server during query

Network problems ... something is breaking TCP/IP. - Original Message - From: "Yanglong Zhu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I

Re: Lost connection to MySQL server during query

Gerald R. Jensen wrote: >Connection type, network configuration, operating system, ODBC >configuration, etc. can be factors. You haven't shared any of that >information, so it is hard to speculate. > Sorry, I'm on a University wide LAN, running mysql 3.23.49 on RH7.3 . I don't think I'm using OD

Re: Server comparison running Mysql

On Sunday, October 6, 2002, at 01:53 AM, James Riordon wrote: >> Have you tried monitoring server B via 'top' or something and see what >> processes are taking up CPU time and/or swapping. > > > Hello, > > I have monitored top for a bit. It is definitely MySQL-Max that is > taking up the

Re: Storing results from a Query in an existing Table

At 9:03 -0800 10/12/02, Tim Johnson wrote: >Hello All: > I have learned to extract columns from one table and >create a new table from those columns->i.e: > >CREATE TABLE Wines SELECT >Country,Varietal,Producer,Vineyard,Year,Size FROM AH; > >Now I would like to SELECT the same columns from ot

Re: Magazine article database

From: Michael Picco <[EMAIL PROTECTED]> > I am interested in creating a magazine article database using MySQL and > Python, as an attempt to learn both. A very good idea, learning by doing. > It occurred to me that an attempt such as this could be reinventing the wheel. Well, yes. But isn't

Relating two tables

Hello All: I'm attempting to split tables and set up relationships between tables importing from another (unnormalized) database type. So far I have extracted fields representing one-to-many from one table and created a table with this description. +--+--+--+-

Re: REGEXP

At 18:35 +0200 10/12/02, tl wrote: >Hello, > >mysql>LOAD DATA LOCAL INFILE 'access.log' INTO TABLE tmp FIELDS >TERMINATED BY 'REGEXP \"^[ ]{1,}$\"' OPTIONALLY ENCLOSED BY '' >ESCAPED BY ' ' LINES TERMINATED BY '\n' ; > >How can I make that it would work as I expected? >How terminate fields by s

HELP - Having serious trouble here...

I have been using MySQL for nearly a year now with no problems, until now. I rebooted my box this morning and since rebooting I have had nothing but trouble. First off I have noticed (I never looked before because I had no need to, but there is nothing in my "msqld.log" They are all 0k. Seco

adding a string to enum

When I try to add a string to the end of an enum list I get the following error message: You have an error in your SQL syntax near '\','Historical Knowledge','Chronological Thinking, Comprehension, Analysis and I' at line 1 The schema for the field is: standards_topic enum('','Historical Knowl

trying to use Password

Hello MySQL, Backpacker in the foot hills of learning mysql installed 4.0.4 beta-max-nt on win2k Pro SP3 and using Innodb type When I connect using MyODBC 3.51 I get the following error. Run-time error '-2147467259 (80004005) [MySQL][ODBC 3.51 Driver]Access denied for user:'[EMAI

Offsite Apps won't run

I'm running a Linux Redhat 7.2 webserver. Recently, after making a change to the server name, I found that I can no longer connect to MySQL via programs such as Mascon or MACSQL (think that is the customer's app?). All on machine functions seem to be operational. phpMyAdmin still works for the sev

Re: Storing results from a Query in an existing Table

Greetings.. The MySQL Documents will be a nice place. Maybe this will help if you want to copy all the data as well as columns from the - create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table (this will create the table with the exist

Re: Relating two tables

Tim, > Pointers to documentation would be appreciated as well. We've begun such a list at http://www.artfulsoftware.com/dbresources.html. PB [filter fodder mysql] - Before posting, please check: http://www.mysql.com/ma

Re: index in mysql

When you specify a column with primary an index of name Primary is made on the column. For making a column unique, you have to first make a index on it which is of type UNIQUE. So automaticallt a index is made on it. Rgds Insane - Original Message - From: "Inbal Ovadia" <[EMAIL PROTECT

re: 2 MySQL Servers running on the same machine

Benoit, Thursday, October 10, 2002, 11:32:14 PM, you wrote: BSJ> Is there any documentation/hints/tips avaible on how BSJ> to install 2 (or more) MySQL servers (and clients) on BSJ> the same Windows 2000 box? Some time ago there was a discussion in the mailing list: http://lists.mysql.com/c

Re: making two fields primary key ????

This is covered in the manual for mysql . Look up primary key. To create table with primary key the syntax will include: PRIMARY KEY (colname1, colname2 ...) To alter an existing table will be miore difficult, since you have to ensure the data already in the table does not breach the new primar

Re: Bug?

At 17:30 -0700 10/12/02, Okami no Kaze wrote: >I'm attempting to make a search engine with a MySQL >back end, and have run into a little problem. > >I'm using the query: > >SELECT * FROM listings WHERE MATCH (Name, Description, >Keywords) AGAINST ("searchString" IN BOOLEAN MODE) >LIMIT 0,25 > >And

Re: Offsite Apps won't run

John: How are you connecting the nodes running Mascon, etc. to the server ... MyODBC, libmysql, etc.? If the problem started when you changed the server name, then check the DNS settings on the client machines. It would seem they are trying to connect to a non-existant DNS name. Gerald Jensen

trying to use Password

Hello Alan, Thanks for your comments MyODBC 3.51 has not been setup, just installed. I am using ADO 2.6 with myOdBC as its driver. if the UID & PWD are removed from the connection string it works ok Also the connection Property("User ID") is empty if the property is set to

Sub selects

Hi All! This is my first question to the list. Can some one help out a newbie with a simple question please? The closest thing I found is a php query to do this using temporary tables but it takes too long. Table 1 NameDate John01/10 Jack01/10 Jill01/10 Mary02/10 John02/1

Re: Lost connection to MySQL server during query

Connection type, network configuration, operating system, ODBC configuration, etc. can be factors. You haven't shared any of that information, so it is hard to speculate. - Original Message - From: "Yanglong Zhu" <[EMAIL PROTECTED]> To: "Gerald R. Jensen" <[EMAIL PROTECTED]> Cc: <[EMAIL P

Bug?

I'm attempting to make a search engine with a MySQL back end, and have run into a little problem. I'm using the query: SELECT * FROM listings WHERE MATCH (Name, Description, Keywords) AGAINST ("searchString" IN BOOLEAN MODE) LIMIT 0,25 And it returns: You have an error in your SQL syntax near

Re: Lost connection to MySQL server during query

Gerald R. Jensen wrote: >Network problems ... something is breaking TCP/IP. > Gerald, I can view the webpages on the server, though. Doesn't it use the same TCP/IP? > >- Original Message - >From: "Yanglong Zhu" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, October 12, 2

Magazine article database

I am interested in creating a magazine article database using MySQL and Python, as an attempt to learn both. It occurred to me that an attempt such as this could be reinventing the wheel. Has such a thing been done. If so, where might I find it? Thank you. Michael Picco KD6BMV

"CAST" should be listed as a Reserved Word

Hi, when I upgraded from MySQL 4.0.1-alpha to 4.0.4-beta, I stumbled over the fact that "CAST" is now a reserved word (I had a table with a column named "Cast"). The "CAST" keyword is already mentioned in the "News-4.0.2" and in the "Cast functions" info nodes, but I suppose it should also be li

Re: mysql OSX 10.2

At 1:24 PM +0200 10/12/02, Pierre Vaudrey wrote: >Could you help me to fix it ? The recently released Blue World Lasso Professional 6 runs on Mac OS X 10.2 and includes MySQL. You can check it out (free of charge) for 30 days. Details at . Hope that h

index in mysql

Hi all, I have a quation about index: In mysql, if i create table table_name with column loc_name (and another columns), and the col_name has PRIMARY KEY and UNIQUE constraints, Is an index created atoumaticly on this column? Thanks, Inbal ---