RE: parameters?

sorry...this is the error i get: Warning: Supplied argument is not a valid MySQL result resource in /www/prunet/agent_result.php3 on line 110 -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 18, 2001 1:55 AM To: Matt Wagner; Craig Westerman Cc:

Re: MS Excel to MySQL upload macro?

At http://www.icarz.com/mysql/index.html you can download a VB API that you can also include in excell. It's an API that connects directly to mysql. The API (MyVbQL.dll) is free and comes with an example program in VB. Regards, Tadej - Original Message - From: Matt Wagner [EMAIL

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

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

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 trust

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. It seems after a

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 from Sun. I have done

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

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 updated

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.1 =

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

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

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

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 write

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

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

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

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

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

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,

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 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 for slowness.

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,

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:

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

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 :

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 . ,\ . $headerlines

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

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,

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

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

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

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

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: 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. Is there a way

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

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

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

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