Innobase on WinNt.

I am trying to install Mysql (3.23.36) on windows NT. I have installed the software, but cannot find how to use the Innobase table structure. Can someone please point me in the right direction (apart from installing it on something else). I have tried putting in the setting from the 8.7.2 INNOB

concatenate with group by

Hi, All. Do you know how make concatenate of column values (TEXT type) with group by other column? I need do it use only SQL query!!! For clearness, please, take a look on example. I have table: idc1c2 11"apple" 21"plum" 31"vine" 42"apple" 52"pear"

Starting Mysql with system

How can i put mysql to start with my system, i´m worcking with RedHat Linux 7.0 , and nowadays i´m starting the daemon manually trhough mysqld. Thanks in advance, Gabriel. - Before posting, please check: http://www.mysql.co

Mysql and MS Access

Hi, I am trying to access a Mysql database from MS Access using the Mysql ODBC driver. I can connect to the database and open the table and browse the data but I can not modify anything (the file is read only). The username I am connecting with have Select, Insert, Update and Delete permiss

Is updating a subsection of a field possible?

I've got a table with 500+ records in it now... and I need to update just a small section of one of the fields (an URL) to change a parameter on it... I know I'm probably going to be told "NO", but I thought I'd ask before I go start writing a program to do this Is it possible to upd

Q: How to set autocommit in my.cnf and etc

Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at th

Termcap not found in install...

Hi everybody... I'm pretty much trying to install MySQL by compiling the sources (I like to avoid RMPs as much as I can), but I'm getting an error at configure time. This is what I do: # ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql There is some output and then it stops at the

possible deady

I am curious if any knows of possible deadlock conditions that can ocurr when using the lock tables command in MySQL when you are referenceing multiple tables? _ Get your FREE download of MSN Explorer at http://explorer.msn.com --

RE: most viewed

Sorry...I guess I just figured it'd be something a little more than SELECT and LIMIT. I was trying stuff like this: SELECT views,count(*) AS MAXIMAL FROM $mysql_table GROUP BY views ORDER BY MAXIMAL DESC LIMIT 10 My bad. tyler -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: mysqld daemon ended

"Graham Nichols" <[EMAIL PROTECTED]> wrote: > I have installed mysql 3.22.32 on our local intranet for testing and it > runs ok. Then, I transferred the same .tar file to a linux server of the > 'net and installed as before. When I run ./scripts/safe_mysqld & > from the mysql-3.22.32 directory I g

Re: most viewed

You should definitely read up the manual. If you don't do this, will not do you homework and simply expect an answer handed down to you, you might get disappointed. Question you have asked is like MySQL 101. To get you started this time, however, here it is: select * from table bands order by

Re: most viewed

"Tyler Longren" <[EMAIL PROTECTED]> wrote: > I've got a table that contains a list of bands. There's a field named > views. This field contains how many times each band's page has been viewed. > > Ex: > id artist views > 1 No names 6 > 2 WISH 10 > 3 Deftones 45 > > > What's the SQL to select the

mysqld daemon ended

Hi, I have installed mysql 3.22.32 on our local intranet for testing and it runs ok. Then, I transferred the same .tar file to a linux server of the 'net and installed as before. When I run ./scripts/safe_mysqld & from the mysql-3.22.32 directory I get a message telling me that the daemon has

most viewed

I've got a table that contains a list of bands. There's a field named views. This field contains how many times each band's page has been viewed. Ex: id artist views 1 No names6 2 WISH10 3 Deftones45 What's the SQL to select the top 2 most v

[Fwd: Odd mysqlhotcopy behavior]

I'm still having bizarre problems with mysqlhotcopy and I'm wondering if there is an underlying problem MySQL 3.23.36 (happened on 35 too) mysqlhotcopy v1.11 RH 6.1, updated as necessary Perl 5.6.0 DBI/DBD up to date. I backup around 10 databases with a total of 188 tables. Most tables are

Mail Marshall E-mail Viruses - An Apology

Hi, My apologies on behalf of Mail Marshall for the flood of virus alerts. They started at 0:01 on1/4/01 NZST (hmm... maybe there is something there), and continued until our support staff re-installed the latest virus ID file - we didn't have time to find out why it happened. So, to those

How do I

I am using the following command to import date. The teldirt.txt file is just a list of commands to remove 4 existing tables in the TelDir database and then the SQL statements to add the tables and new data... mysql --user=root --password=** TelDir < d:\database\teldirt.txt >> d:\database\import

Re: Restore from Logs?

It seems to me that you have misunderstood the manual. As you have pointed out yourself, you are running MysQL on Windows platform. The syntax you are referring below is for UNIX/Linux systems... (shell> means current shell in use your system and the rest are commands available on UNIX systems).

Re: Still can't get it working.

"Tatti" <[EMAIL PROTECTED]> wrote: > Edit the `bin/mysqlaccess' script at approximately line 18. Search for a > line that looks like this: > $MYSQL = '/usr/local/bin/mysql';# path to mysql executable" > > Guess what? Ther is no such line in my mysqlaccess.conf The file it's referring

Restore from Logs?

Hello, I'm having some trouble understanding the syntax for populating a backup with logged updates. In the manual, is says: shell> ls -1 -t -r file_name.[0-9]* | xargs cat | mysql I'm running MySQL on Win98 and Win2000. I've tried using the syntax above, but to no avail. Any help would be

RMON to mySQL

Hi All, I am interested if anyone knows of any product which can grab RMON II data from switches and store the data into a mySQL database? Thanks Solomon - Before posting, please check: http://www.mysql.com/manual.php (th

what is this message ?!

Hi , I have posted a message to list that contain a question about a message the shows for one of my clients that a Cistron radius patched to authenticate through MySQL . this is message is : 010401 22:18:51 Aborted connection 6202623 to db: 'morva' user: 'radius ' (Got an error reading communi

Still can't get it working.

Lindsay and Eric has been ever so helpful but no matter what I do I can't get this installation right. I am no on my sixth re-installation. In the manual it says: "If you would like to use mysqlaccess and have the MySQL distribution in some nonstandard place, you must change the location where

RMON to mySQL

Hi All, I am interested if anyone knows of any product which can grab RMON II data from switches and store the data into a mySQL database? Thanks Solomon - Before posting, please check: http://www.mysql.com/manual.php (th

Choosing between the three types of transaction-supporting table

Hi folks, The recent additions of storage handler for transaction-supporting table confuses us. From what I read on the list, Innobase is generally much faster than BerkeleyDB. But I can live with slower speed since my application will not be expecting high rates. It is reliability and tested

RE: Dual Processor and MySQL !

> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: domingo, 01 de abril de 2001 15:07 > To: Nemholt, Jesper Frank; [EMAIL PROTECTED] > Subject: RE: Dual Processor and MySQL ! > > > Hi , > > Thank you very much for your compelete description about

Re: Cannot find mysql.sock

Michael Tefft wrote: > > Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that > the socket: '/var/lib/mysql/mysql.sock' exists! Is mysqld up and running? If yes, try starting the server next time with the option "--socket=/v

Re: SQL Import on MySQL

There are a number of syntax differences between MSSQL and MySQL ... if you are going to be doing a lot of conversion work, grab a copy of MS's help file so you can compare it to the functions in the MySQL manual. To answer you question more directly, MySQL doesn't need the dbo (database object)

Re: limit text column

you probably want something like: select substring_index( mycolumn, ". ", 2) from mytable; Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.

limit text column

Hello, Is it possible to limit the output of a text column to the first two sentences in the column? Thanks for the Help, Mike

Re: Mac OS X

There is a binary tarball on www.mysql.com that works on the retail release of Mac OS X. I have also built from the .36 source, but that requires editing one line of source code. Here are directions: http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html Look at the user comments. The line

Cannot find mysql.sock

I have installed the latest stabel MySQL server and client. When I try to run mysqladmin, I keep getting the following message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Patch: Slow 'sending data'

Hi! While extending our multi-thread test suite for MySQL I noticed a that during some conditions simple SELECT's could sometimes take a long time. I found the problem to be the following: If you do a FLUSH TABLE, CHECK table or REPAIR table, tables that are waiting for a lock will have to reo

Re: Locked tables while "Sending data" !?

Hi! > I just come across this old email: > > On Thu, Mar 09, 2000 at 03:14:28PM +0200, sinisa wrote: > > > > This happens in the case when mysql does not have to create temporrary > > tables in order to obtain result set, but is reading from the live > > table itself. > > > > Changing a table d

add index on text

Hi Can anyone help me? I'm trying to put an index on a text column named invariant. I tried this command : alter table cinvariant add index (invariant); I got this: ERROR 1170: BLOB column 'invariant' used in key specification without a key length ok so I tried this alter tabl

Id of row

Thank for the answer to my last question, but now I have another one : I'm searching for a data type that represents the Id of a row. Like rowid in oracle database. rowid is a string that represents block id, row id and more ( I really don't remember the exact arguments). Does mySql contains t

RE: Dual Processor and MySQL !

Hi , Thank you very much for your compelete description about MySQL and multi processor platforms . According to your mail if I have several connection to my SQL server and I have more than 1 CPU and installed the SMP on my machine the MySQL performance will be better than a single CPU and If I h

RE: Dual Processor and MySQL !

> -Original Message- > From: Hamid Hashemi Golpayegani [mailto:[EMAIL PROTECTED]] > Sent: sábado, 31 de marzo de 2001 17:09 > To: [EMAIL PROTECTED] > Subject: Dual Processor and MySQL ! > > > Hi , > > Sorry for this question may be this question asked before but > I can't find > it . >

Re: Show grants ??? Doubt

Whoof What a relief But one more doubt is "mysqlaccess" not shipped with on win32 platforms.The version i'm using is 3.22.32 shareware. I don't seem to find it Cheers Sajan - Original Message - From: Benjamin Pflugmann <[EMAIL PROTECTED]> To: P.V. Sajan <[EMAIL PROTECTED]> Cc:

perror

Hello All !! C:\mysql\bin>perror 1064 Illegal error code: 1064 This is impossible but its true as i've simply pasted the screenshot. I guess 1064 error stands for syntax.error The version i'm using is 3.22.32 shareware.on win98 Could anyone please explain this weird thing coz . 1064 is a ve

MySql with EJB CMP

Hello all , Can anybody tell me what to do to setup MySql with EJB ? It is running very fine for creation of the CMPs but it is not getting the DATA while executing FindByPrimaryKey option , it is able to create the instance of the Interface but could not get the DATA from it. Neelesh - O

mySQL and MacOS X: very slow

Hi all, I benchmarked mySQL 3.23.36 on the new MacOS X and got the following results: ATIS : 101.00 alter-table: 767.00 big-tables :90.00 connect: 178.00 create : 957.00 insert : 38029.00 select : +3274.00 wisconsin : 307.00 That's too slow especially the ti

Re: data types

On Sun, Apr 01, 2001 at 11:02:22AM +0100, Einav Lavi-Lapidot wrote: > Hi all , > > Can I get a list of all data types at mySql 3.23 ? I'm starting to > work with it, and it would be very helpful. Thanks, einav. Certainly. They're all documented in the manual: http://www.mysql.com/doc/ Jere

data types

Hi all , Can I get a list of all data types at mySql 3.23 ? I'm starting to work with it, and it would be very helpful. Thanks, einav. Einav Lavi-Pdut software engineer [EMAIL PROTECTED] - Before posting, please check: ht

mysqladmin question

Hello, I have an error when the system (Linux 7)goes to rotate the logs. I get an error sent to me by cron daemon that access is denied for user root @ localhost using password=no. I had this same problem when I first installed the RPM when I was trying to set a root password. when I issued

confirm subscribe to mysql@lists.mysql.com

Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like archive@jab.org added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the "reply" button. If th

Re: How to have faster select?

Read the manual, the most frequent words are stopped in index. Chai-Hup Chen wrote: > Hi, > Thanks a lot, the select is much faster now. But I find something > weird, it return nothing when match against the string "the", which > return 255568 entries when select "% the %", is it possible mys