Re: MySQL Documentation - how do you do it ?

David Herring writes: > > > Good morning, > > Let me first start by praising the MySQL documentation. It is > excellent - both in content and in it's indexed, linked, and > searchable layout. > > On that later point, I would like to know how you acheived this ? > What tool(s) was used to creat

RE: FreeBSD and multiple daemons

Jerry, Thats a reasonably serious hardware platform, you should not encounter 30 second delays, did you compile mysql yourself or use a pre-compiled binary... Sid > -Original Message- > From: PR [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, August 19, 2001 4:28 PM > To: [EMAIL PROTECTED

Re: database/php question

The way I do it is use this header command: Below that you can use a normal HTML table to lay out your data. Make sure you only use and tags, there should be no or tags in the page. D'Arcy - Original Message - From: "Kit Kerbel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: S

Re: database/php question

This is actually very easy. Change the content type of the document that you send back and then just send all the data back in a . Make the first line of your php and only send a table, no etc. Regards, Gary "SuperID" Huntress === FreeSQL.

FreeBSD and multiple daemons

I'm having a problem with my server getting bogged down once in a while and I'm pretty sure it's due to the mysql daemon getting maxed out with what it can do... when this happens there might be anywhere from 100 to 150 processes in the processlist and it might take as much as 30 seconds to return

how to contribute new prebuilt clients for Cygwin

Hi, I would like to contribute a new minimal package containing prebuilt client binaries for Windows/Cygwin. This would help to rectify two problems: 1) The existing ports (see http://www.mysql.com/downloads/os-win32.html) are badly outdated 2) They do not comply with the GPL as they distrib

database/php question

This is kinda off topic, but, I have a mysql database and I am generating an html table from one of my queries. I want to be able to download this html table, but in excel format. Any suggestions on a way to do this? Thanks, Kit ___

could not insert BLOB data types in table

Hi all, I could not insert BLOB data types in a table. I want that the INSERT statement should insert a picture in a field of a table. Like, INSERT INTO testtable (id, picture) values (1,picref) Here I want to know what should be the picref I know picref is a variable in a programming la

mysqlctl configtest?

In Apache web server, the command used to start/stop the web server also has an option called "configtest". One can type "apache configtest" and it will tell you if the configuration file has a valid syntax. This is to save you from the situation where you modified the configuration file, then sto

Re: Case-preserving is not consistent

At 04:23 19/08/2001 -0700, Lars Bruun Hansen wrote: Hi, This behavior is fixed in the release 3.23.41. Into the next 6 hours I will send the distribution files for our Web master, so maybe at Monday or Tuesday you can get it from our download page. Take a look in the printed samples below, how i

granting permissions

i currently show localhost with no user name having no permissions. what is the sql statement for granting localhost with no user name all of my privileges. i have mysql root access privileges. thankyou steve marx

Re: Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE

At 08:52 16/08/2001 +0200, Luciano Pulvirenti wrote: Hi! Sorry but I wasn't able to repeat the bug reported. However I did my tests with the DOS mysql client and others GUI clients, since the Mascom trial package that I have denied the start on my Win9x machines, so I assume you have an environme

RE: Database File group ownership

On Sat, 18 Aug 2001, Philippe Paravicini wrote: > could you not add the 'animel' user to the 'mysql' group? > > > I have done "chgrp animel *" on the directory that contains the files of > > the database "animelyrics", but new tables that I create are group "mysql" > > instead of group "animel".

RE: Database File group ownership

could you not add the 'animel' user to the 'mysql' group? -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]]On Behalf Of Philip Mak Sent: Saturday, August 18, 2001 7:10 PM To: MySQL Mailing List Subject: Database File group ownership I have a database called "animelyrics". I

Re: Case-preserving is not consistent

On Sun, 19 Aug 2001, Lars Bruun Hansen wrote: > mysql> show tables from test; > ++ > | Tables_in_test | > ++ > | MyTable| > ++ > > mysql> alter table MyTable add (y char(1)); > mysql> show tables from test; > ++ > | Tables_in

Case-preserving is not consistent

Version: MySQL v. 3.23.40 (Windows NT) Hello, I would like MySQL to preserve the case of my table names and therefore I have set lower_case_table_names=0 in my configuration. I use Windows NT. This works fine for CREATE TABLE statements but the moment I use a ALTER TABLE statement the na

Database File group ownership

I have a database called "animelyrics". I want to make it so that the files inside this database are readable to the UNIX user "animel", so that I can do backups easier. I have done "chgrp animel *" on the directory that contains the files of the database "animelyrics", but new tables that I crea

mySQL dies on win98

I am using my laptop running win98 to develop a php site using Apache/mySQL. Inevitably, after working for about 45min-60min, I can no longer connect to mySQL, and apache will no longer refresh the pages properly. At this point, restarting the mySQL server and Apache does not do any good. The onl

Multiple SELECTS v.s. one SELECT

I'm using the Tangram perl module, which makes MySQL act like an object oriented database. My database has a table of stories (STORY). Each STORY is written by an AUTHOR. So, the database design is like this: CREATE TABLE story ( id int PRIMARY KEY NOT NULL, title VARCHAR(80),

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2

And here is mysqladmin extended-status: Sat Aug 18 20:42:36 EDT 2001 +--++ | Variable_name| Value | +--++ | Aborted_clients | 1 | | Aborted_connects | 4 | | Bytes_received

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2

Yes, I fixed the SCSI performance. Here is the mysqladmin variables: [root@dagger /root]# mysqladmin variables -p +-+- - --

Re: dbi->connect

Umm, you didn't specify a username or password...you instead passed 'undef'. This is the connect string I use: $dbh = DBI->connect( "DBI:mysql:database=$pb_db; host=$pb_server; port=$pb_port", $pb_user, $pb_password, {Rai

Re: MyODBC, MySQL, and a little bit of perl

On Sat, Aug 18, 2001 at 04:25:50PM -0700, John Meyer wrote: > Here's the error message that I am getting: > > [911] [2] [0] "[Microsoft][ODBC Driver Manager] Invalid string or buffer > length" > > > And here is the code > > > my $sqlcommand = "INSERT INTO > EMAILS(PERSONALITY_ID,EMAIL_HEADE

MyODBC, MySQL, and a little bit of perl

Here's the error message that I am getting: [911] [2] [0] "[Microsoft][ODBC Driver Manager] Invalid string or buffer length" And here is the code my $sqlcommand = "INSERT INTO EMAILS(PERSONALITY_ID,EMAIL_HEADER,EMAIL_EMAIL,EMAIL_FROM,EMAIL_SUBJECT) VALUES(" . $personalid . ",\"" . $header

Re: CHAR transformed to VARCHAR in CREATE TABLE

Hi, This behaviour is normal. As long as you have varchar, blob or text field, the row format used is "dynamic", and so char are converted to varchar type. If you want to convert you all your varchar to char, just execute ALTER TABLE your_table ROW_FORMAT=fixed Take a look at : http://www.mysq

Re: aggressive dolphin?

OK this thread needs to die a quick death since it is not database related, or go someplace useless like USENET under alt.hate.animals.flipper-was-an-axe-murderer Chris > From: "Arjen G. Lentz" <[EMAIL PROTECTED]> > Date: Sat, 18 Aug 2001 17:04:38 +1000 > To: <[EMAIL PROTECTED]>, <[EMAIL PROTEC

CHAR transformed to VARCHAR in CREATE TABLE

>Description: In a CREATE TABLE statement, if coexists CHAR data and VARCHAR data, the CHAR data is "promoted" to VARCHAR. >How-To-Repeat: CREATE DATABASE bug_3_23_41; USE bug_3_23_41; CREATE TABLE charAccepted ( Id int (10) unsigned NOT NULL auto_increment, SID char(32)

Re: aggressive dolphin?

- Original Message - From: "Theo Richel" <[EMAIL PROTECTED]> > I am a very dedicated user of Mysql, but I am somewhat disappointed that you > chose the dolphin for your logo because of the good nature of this animal. > [...] > Unlike most animal killers, which eat their prey, dolphins see

Re: mysql becomes slow

Carsten H. Pedersen schrieb am Samstag, 18. August 2001, 19:24:39: > Sinisa writes: >> Osus writes: >> > ... >> > Hi, >> > SELECT * FROM table WHERE OK=1 >> > it gets about 4 or 5 second at least. >> > I have indexes. That main table have 27 indexes to supply all >> > possible searches. > ...

Hierarchical trees in MySQL

Hi there, I have heard that MySQL has some special functions or it's some other way capable to handle hierarchical forms in table. Let me give an example: Table contains following rows: IDNameParentID 1Main10 2Main20 3Main30 4Child1-11 5Child2-12

dbi->connect

I am using Perl DBI to interface with MySQL and when i execute the following statement: $dbh = DBI->connect('DBI:mysql:database=dbmysql2', undef, undef, {PrintError =>0}) || die $ DBI::errstr; it causes the error: [Fri Aug 17 09:59:50 2001] productioncontent14.pl: Access denied for user: '@localho

normalization question

I have a table which needs to store which emails each member has read and had their account credited for. Currently, I have a field "read_array longtext" in my main members table, and each time a member reads an email, it simply concats to the end of this array. For example, they read email 288, t

Re: mysql becomes slow

I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with "LIKE %value%" queries, is there anything els

Re: mysql dbi connect

On Sat, Aug 18, 2001 at 11:07:06AM -0400, Steven Marx wrote: > I am having a problem with MySQL. I am seeking some advice on either what is wrong > or how to pursue the cause of this bug. > > I am using Perl DBI to interface with MySQL and when i execute the > following statement: > $dbh = DBI->c

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2

Am Samstag, 18. August 2001 19:18 schrieb Gary Huntress: > My opinion onlyif you are a dot com, and are having critical problems > with a production server that you rely on to make your $$$, then you should > suck it up and pay for support. We pay $40k/year for commercial support > on our "i

RE: mysql becomes slow

Sinisa writes: > Osus writes: > > ... > > Hi, > > SELECT * FROM table WHERE OK=1 > > it gets about 4 or 5 second at least. > > I have indexes. That main table have 27 indexes to supply all > > possible searches. ... > Having 27 indexes and using queries with LIKE "%...%" is a nice > recepee

Re: lotus -> mysql

On 18 Aug 2001 18:53:16 +0200, Siim Einfeldt aka Itpunk wrote: > > Hi, > > I need to convert lotus database to mysql, how to do it? Right now the > lotus datbase in a text file...what can I do it now? LOAD DATA check the manual for exact syntax for your case. -- For technical support

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2

My opinion onlyif you are a dot com, and are having critical problems with a production server that you rely on to make your $$$, then you should suck it up and pay for support. We pay $40k/year for commercial support on our "important" Sybase database, and its worth every penny. Regards, G

MySQL Spawns Many Processes and Uses 100% CPU! PART #2

CONTINUED FROM PART #1 While this happens, I was able to do a "mysqladmin processlist" command and here is the result: [root@dagger /root]# mysqladmin processlist -p Enter password: ++---+---+---+-+--++ --

lotus -> mysql

Hi, I need to convert lotus database to mysql, how to do it? Right now the lotus datbase in a text file...what can I do it now? Thanks Siim Einfeldt - Before posting, please check: http://www.mysql.com/manual.php (the

Delphi and Mysql - Data Security

I am using Delphi to connect to and update data on a mysql server. Is there any problem with data security? Will it automatically establish a secure connection? Thanks everyone for all your help. Elizabeth

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

Thank you for the tip, but this is not our problem. We are running SCSI disks with over 40 MB/sec throughput. Any other ideas? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: "Werner Stuerenburg" <[EMAIL PROTECTED]> To: "Ryan Shrout" <[

Re: Databases and ADODB

Greetings: We have been using it with great success for our enterprise level network monitoring system. We use mySQL as the back end database server, PHP for the user interface, and a combination of Perl / C++ for the actual monitoring. At 04:32 PM 8/18/2001 +0200, you wrote: >Anyone made goo

Re: locking question

On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote: > > hi, > I'm new to this list, but not so new to using MySQL and have a question > about locking. (This is my first foray into datalocking with MySQL.) > > I'd like to lock a table (a row in that table would be better) for read > and

mysql dbi connect

I am having a problem with MySQL. I am seeking some advice on either what is wrong or how to pursue the cause of this bug. I am using Perl DBI to interface with MySQL and when i execute the following statement: $dbh = DBI->connect('DBI:mysql:database=dbmysql2', undef, undef, {PrintError =>0}) ||

Databases and ADODB

Anyone made good experiences with the ADODB Library for PHP4? I would like to use it for further database programming! And suggestions? -- WA-P : Jochen Kaechelin Programmierung - Beratung - Hosting Stuttgarter Strasse 3, D-73033 Göppingen Tel. 07161 - 92 95 94, Fax 92 95 98 -

migration db from mysql to MS sql7 server

Hi All ... 1- I can now make a back up for db from mysql server to my localhost. The backup that I have done gave me .sql file, I used this : mysqldump -h (server host) -u user --password=(password) --opt db_name > c:\Backups\bkp.sql but I find it difficult when any lost of data occures, to cr

Re: mysql GUI

Michael Laajanen writes: > HI, > > > I have just tried the 1,6 Solaris version of the GUI but it fails. > > On the web it says it is statically linked but it is not! > > > ldd /opt/tools/applications/mysql/1.6/bin/mysqlgui > libX11.so.4 => /usr/lib/libX11.so.4 > libsocket.so

Problem with nested delete - help

Hi, I have a problem with nested delete query. I want to delete some record from one table based on the select result of another query. e.g. delete from tab1 where uid in (select uid from tab2 where today >= 'any_date'); Will it work? I tried, but it says that 'syntex error near 'select.'

mysql GUI

HI, I have just tried the 1,6 Solaris version of the GUI but it fails. On the web it says it is statically linked but it is not! ldd /opt/tools/applications/mysql/1.6/bin/mysqlgui libX11.so.4 => /usr/lib/libX11.so.4 libsocket.so.1 =>/usr/lib/libsocket.so.1 li

are MySQL Queries limited to they ahdere to Ansi SQL?

Hi Folks below is a seltion of queries all doing very similar things I have run all on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So does this suggest that MySQL is not fully compliant with Ansi SQL? The problem seems to lie in the fact that the embedded select does

Re: mysql becomes slow

Osus writes: > Hi, > SELECT * FROM table WHERE OK=1 > it gets about 4 or 5 second at least. > I have indexes. That main table have 27 indexes to supply all possible searches. > Some searches are made on text fileds, something like "WHERE field like '%key%' >being field text field. > > I have

mysql becomes slow

Hi, I have one p3-800, 2 uwscsi hd , debian, apache 1.3.20, php4.0.5 and mysql 3.23.38 I have one web aplication with about 10.000 visits per day and about 8.000.000 pages visited per month. Only one database with about 15 tables, the main with about only 20.000 records. The problem is that t

Re: problem running compiled version of mysql-3.23.41 with innodb

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> [EMAIL PROTECTED] writes: >> Hi all, >> >> >> i am not sure if i am at the right list. >> But i will ask my question anyway. >> >> Here is the problem. >> I have compiled Mysql version 3.23.41 with Forte 6 update 1

Re: Table corruption at MySQL 4.0.0 shutdown ?

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Fournier Jocelyn [Presence-PC] writes: >> Hi, >> >> I noticed an annoying behaviour with MySQL 4.0.0. >> I have 11 tables with a lot of rows (about 1 Million and more) which are constantly >updated by a php script. >

Re: Backups from Server to localhost

sql Stefan Hinz schrieb am Freitag, 17. August 2001, 21:28:54: > It's not secure, though > (http://www.securereality.com.au/studyinscarlet.txt), so make sure to > protect the directory it's "installed" in with .htaccess when running it > on a public server. To make a long story short: dont't tr

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

> Okay, here is the problem: everyone once in a while, say once or twice a day, my >web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users >point of view). Upon SSH'ing > into the server, and running "top" I see the system load averages in the 90s (!!!) >and all

ANNOUNCE: MyVCC-0.3.2.pre-alpha released

Hi I have released a new version of MySQL Visual Control Center for Windows. This release includes the following revisions:- 1. Help viewer with help files in HTML format. These help files can also be viewed outside of MyVCC using your favorite web browser so they can also be used as the projec