Re: errors while uploading my php site ...... ! ! ! !

Toby: Wrong forum. Go to php.net and search around there. Off the top of my head, my guess is the provider has a global include that sends headers before your page gets a chance to do so. You could try creating a page called woka-woka.php containing the following and see what it looks like:

Regarding he problem int he field length

Dear Friends I observed the very strange problem with my Mysql , My be this is the feature or I have not configured it properly please do tell me the reasons and remedy. Problem is I am inserting the fields through VB. When I insert the record in the table of Mysql . Mysql inserts the record

Re: errors while uploading my php site ...... ! ! ! !

Hi. On Wed 2002-08-14 at 06:15:22 +, [EMAIL PROTECTED] wrote: > hi guys > > this is a weired problem . > > my site s almost done and workin fine on my machine > > ive just uploaded it and it AINT worin on the host > i confirmed php and mysql support > ve made all the tables and everyth

errors while uploading my php site ...... ! ! ! !

hi guys this is a weired problem . my site s almost done and workin fine on my machine ive just uploaded it and it AINT worin on the host i confirmed php and mysql support ve made all the tables and everything the errors im getting are : Warning: Cannot send session cookie - headers alre

RE: Problem in BLOB Field with zips

Thanks for helping; I can understand my mistake. My zip files size larger than 64 k because of this if i use blob field my zip does nt works. My script is : For upload -- Usa Rice Veri Girisi

Re: OOT : contact address (was: Where is Monty ?)

Hello. On Wed 2002-08-14 at 11:08:36 +0700, [EMAIL PROTECTED] wrote: > > Sorry, out of topic and i make the subject special so > MySQL should be interested to read this email > > Actually, we need to know email address of Mr Monty W. the > creator of MySQL, CTO of MySQL AB. > > I have a product

OOT : Where is Monty ?

Sorry, out of topic and i make the subject special so MySQL should be interested to read this email Actually, we need to know email address of Mr Monty W. the creator of MySQL, CTO of MySQL AB. I have a product (corporate portal and workflow) that use MySQL and we want to make a partnership

Re: Creating a database

Andrew, What you have done is correct. A database is merely a container. A container which is empty until you fill it will tables and then populate those tables with data. Regards, Jonathan Duncan Andrew Conkling <[EMAIL PROTECTED]> said: > I am trying to host a message board through a se

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

In the last episode (Aug 13), Don said: > Thanks for the links to the manual. > I still have a couple more specific questions... > > Should I use a source or binary install? Whichever you used to install 3.21 would be preferable. That way they install in the same place. > Can I simply stop my

Creating a database

I am trying to host a message board through a service from www.phpbb.com. To install it, I need to create a blank mySQL database. I've perused the documentation and have not been able to figure out how. When I have "succeeded", it seems all that is created is an empty folder with the name I gave t

Re: Problem with BLOB Field

You may use ADO Stream object for retriving and saving BLOB data. >>> deep kapasi <[EMAIL PROTECTED]> 08/13/02 06:03PM >>> Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyO

zombie slave process on my master

Our server seems to think it is a slave. It has a slave thread rnning, whose only action is to complain once a minute about not being able to connect to master "". This just started one day, when we took the server down and brought it right back up. I'd like to get rid of the slave thread, but

MysQL + OOo

I have installed in Linux Red Hat the server of MysQL, and I have the user management WEBMIN. >From a PC with Windows'98 and OOo 1.0.1 (F4) I connect (ODBC) to the server MySQL (Linux), and I can create my databases , but when I want to modify a field or record, it does not leave me. Nevertheles

Thanks SV: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

Thanks to Dan Nelson and Mike Hillyer, Indexing brought the search downto 2.03 sec compared to 3 min and 16 sec ! Thanks again. Rgs Steinar Kolnes -Opprinnelig melding- Fra: Dan Nelson [mailto:[EMAIL PROTECTED]] Sendt: August 14, 2002 1:14 AM Til: Steinar Kolnes Kopi: Mysql List Emne:

RE: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

Hi Kolnes, Two things: 1. INDEX The number of rows should be immaterial if you have the right indices. In this case, for instance, you search through two different fields so a compound index would make the search much faster: ALTER TABLE subscribers ADD INDEX (first, last) I would sugge

RE: load data infile --- problem

Try putting the file into the MySQL directory, or one the that mysql has permissions on. I bet 2 cents it will work. > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 6:52 PM > To: LR P; [EMAIL PROTECTED] > Subject: Re: load data infile -

RE: upgrading from MySQL 3.21.33 to MySQL 3.23.51

Thanks for the links to the manual. I still have a couple more specific questions... Should I use a source or binary install? Can I simply stop mysqld, then install over the current directory tree? +-Original Message- +From: Dan Nelson [mailto:[EMAIL PROTECTED]] +Sent: Tuesday, August 1

Re: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

In the last episode (Aug 14), Steinar Kolnes said: > I have to make a large 6.5 million names and numbers database in > MySql(maybe not so large for some of you). Yet it is very simple, > here is my sql file: > > create table subscriber > ( > id bigint unsigned not null auto_increment

3 Questions

Greets Folks, These questions may sound kinda basic, but here goes... 1.) What if I want to print (on paper) the contents of my MySQL database, then how do I do it? Everything I have done is for the web so far, so that's why I ask. I was thinking I should just use the reports off the web pa

RE: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

You need an index, it should drastically cut the query time. See: http://www.mysql.com/doc/en/CREATE_INDEX.html#IDX1466 Mike Hillyer Dynamergy Software -Original Message- From: Steinar Kolnes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 4:50 PM To: Mysql List Subject: Need

Re: load data infile --- problem

At 22:21 + 8/13/02, LR P wrote: >thanx 4 your reply: > > >this is the error message that i got when i tried using the full pathname. > >mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; >ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) >mysql> % perror 13 Err

Re: Msql-Mysql-modules vs. DBD-mysql?

At 15:14 -0400 8/13/02, Don wrote: >Hello [help], > >I installed DBD-mysql-2.1017 today and I started getting errors regarding, >mysql.so and lost my ability to connect to MySQL via Perl, the error >returned was; > >fatal relocation error: file >/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/aut

Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

Hi there, I have to make a large 6.5 million names and numbers database in MySql(maybe not so large for some of you). Yet it is very simple, here is my sql file: create table subscriber ( id bigint unsigned not null auto_increment primary key, subscr_id

Transactions not supported by database - Perl

Attempts to disable auto-commit mode in Perl using the DBI command $dbh->{AutoCommit} = 0; returns the following message, "Transactions not supported by database". I am using the latest version of MySQL-Max (3.23.51) as well as the latest version of DBD::mysql. Executing the following command at

RE: Problem with BLOB Field

I would be suspicious that the problem is with ADO or the underlying COM technology. The maximum size of a string in VB is 64K. Perhaps the largest field size ADO can pass back is similarly limited? John Bonnett -Original Message- From: deep kapasi [mailto:[EMAIL PROTECTED]] Sent: Tuesda

Help on installing MySQL source on Solaris 2.6 with gcc 2.95.3

Hello there, I have been trying to install MySQL on Solaris 2.6 with gcc 2.95.3. Below is what I did. (1) I configure it like this CC=gcc CFLAGS="-O6" \ CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/opt/gnustuff/m

Re: load data infile --- problem

thanx 4 your reply: this is the error message that i got when i tried using the full pathname. mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) mysql> i've tried using another user account (of course i've set a

Mysql database replication

I'm trying to set up a replication database and cannot get the slave to parse the log files on the master. The slave is connecting to the master as indicated in the log file. I have tried to connect directly to the master database from the mysql client on the slave and have no problem using the

Problem with /usr/ccs/bin/ld on HP-UX 11.00 during compilation

>Description: I cannot get mysql to compile. It fails when attempting to use ld: /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -felide-constructors -fno-excepti ons -fno-rtti -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_ BROKEN_PREAD -DDONT_USE_FIN

Re: help with syntax of left outer join

Desmond Lee wrote: > Hi there > > I want to do a left outer join but i also have a bunch of where conditions > in my sql statment that i need. Can anyone help me out: > > SELECT title, authorName, journalName, journalPages, aname, tname, > avg(ranking) > FROM publications, area, topic, pu

Changing passwords and deleting users

Hi All; I am working on a front end to my database, but I am running into a bit of trouble. I have a user who has the proper privileges and grant option create other users, but I need to know this: can that user delete users he has created (or at least disable them), and can users change their ow

Re: Msql-Mysql-modules vs. DBD-mysql?

At 03:14 PM 8/13/02 -0400, Don wrote: >What is the difference between the 2 modules, Msql-Mysql-modules and >DBD-mysql? The Msql-Mysql modules are an old implementation of Perl access to MySQL, intended to be compatible with the even older Msql database engine. The past 5 years have seen the de

Re: help with syntax of left outer join

Ah Never mind, i got it. I did some stupid stuff, but figured it out. Here's the working query: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications LEFT OUTER JOIN ranking ON (publications.pubID = ranking.pubID), area, topic, p

Re: help with syntax of left outer join

Whoops... forgot the "on" in the join stament. I change it to include the on, but still no luck. Does anyone have any idea? SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications LEFT OUTER JOIN ranking ON (publications.pubID

Re: sql

This behavior is okay and is normal. MySQL sees the varchar(20) column [identified by `item`] and because one column is variable, MySQL changes all columns to be variable... Have a look at the MySQL manual here: http://www.mysql.com/doc/en/Silent_column_changes.html On Tue, 13 Aug 2002, Pushk

loosing connection

Hi: I'm running mysql 3.23.39 on Windows 2000. I built some applications using php. Once in a while I loose connection with the database even when I use mysql_close() at the end of each script. The only why so far I can get it back is by stopping mysql and starting with t

Re: MySQL eating all memory

maybe too high sort-buffers and so on (in my.cnf) ? Thomas On Tue, 13 Aug 2002 22:02:42 +0200 <[EMAIL PROTECTED]> wrote: > Hi, > > mysql 3.23.51 is running on a Linux 2.4.18 box (4cpu, 2GB) with Apache 1.3.39. > The server is under load (~160 mysqld processes; 80-120 queries/second > shown by

RE: sql

I believe this is one of those few cases where the database will silently optimize your datatypes, it will be transparent from the client point of view, but will make the database more efficient. Nothing to worry about. Mike Hillyer Dynamergy Software -Original Message- From: Pushkar Pr

Help With Joins

I am having some problems getting multiple joins to work. I have the following code: mysql> select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO -> from customers left join work_order -> on (customers.customer_id=work_order.customer_id) -> wher

help with syntax of left outer join

Hi there I want to do a left outer join but i also have a bunch of where conditions in my sql statment that i need. Can anyone help me out: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications, area, topic, pubTopicInt, LEFT OUTER

sql

I'm not very familiar with dbs, I'm creating tables in mysql 3.23.49 and even though I specified a field as CHAR (e.g. customer CHAR(9)) when I do a show create table on this table it displays that this field is a VARCHAR(9). | sales | CREATE TABLE `sales` ( `item` varchar(20) default NULL, `e

Re: Win2K Problem?

There are no error messages. I installed the service as Administrator and now MySql shows up in the Task Bar but, with a Red Light. Using winMySqlAdmin my databases do not show up. Once again, it all works great if I log on to my client as Administrator. Thanks, Bob Hiller - Original Message

MySQL and OpenMosix

Hello all, Does MySQL works well with OpenMosix? Has anyone ever tried it? Is there any special configuration to MySQL that I should be aware of? Thank you in advance, Carlos Fernando Scheidecker Antunes Linux User #207984

Re: Lock Tables Bug

It is not a bug. As soon as Computer1 releases the lock, Computer2 will have its query processed. Never write a program that keeps a lock for more than a few miliseconds. Eric Cotting wrote: > MYSQL Server: 3.23.49a-log > MYSQL Client: 3.23.3 alpha > MYSQLGUI: 1.7.5 > Operating System: Windows N

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

In the last episode (Aug 13), Don said: > Due to some recent headaches I have decided to come out of the dark > ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was > wondering if anyone had any upgrade tips and/or precautions to > recommend before I start. Definitely read the mysql manua

MySQL eating all memory

Hi, mysql 3.23.51 is running on a Linux 2.4.18 box (4cpu, 2GB) with Apache 1.3.39. The server is under load (~160 mysqld processes; 80-120 queries/second shown by "mysqladmin status"). The problem is that mysqld´s memory usage is growing all the time from 17MB after start up to 500MB 5 hours late

upgrading from MySQL 3.21.33 to MySQL 3.23.51

Hello, Due to some recent headaches I have decided to come out of the dark ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was wondering if anyone had any upgrade tips and/or precautions to recommend before I start. Thanks, Don [EMAIL PROTECTED] --

Msql-Mysql-modules vs. DBD-mysql?

Hello [help], I installed DBD-mysql-2.1017 today and I started getting errors regarding, mysql.so and lost my ability to connect to MySQL via Perl, the error returned was; fatal relocation error: file /usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/mysql/mysql.so: symbols mysql_init: r

Lock Tables Bug

MYSQL Server: 3.23.49a-log MYSQL Client: 3.23.3 alpha MYSQLGUI: 1.7.5 Operating System: Windows NT, Windows 2000 When I place a table lock on a table with one computer and issue a query on another while the lock is in affect, the computer that issues the query halts execution of the query with

RE: Replication Question

At 11:28 -0700 8/13/02, Vicky Gonzalez wrote: >From: Paul DuBois on August 13, 2002 11:13 AM wrote in response: >At 11:10 -0700 8/13/02, Vicky Gonzalez wrote: >>Hi all, >> >>I am a newbie here. I was hoping someone would be able to tell me if >>hostnames for the Linux OS is required for MySql Repl

RE: Replication Question

From: Paul DuBois on August 13, 2002 11:13 AM wrote in response: At 11:10 -0700 8/13/02, Vicky Gonzalez wrote: >Hi all, > >I am a newbie here. I was hoping someone would be able to tell me if >hostnames for the Linux OS is required for MySql Replication, and if >so why? I have been combing the m

Re: Replication Question

At 11:10 -0700 8/13/02, Vicky Gonzalez wrote: >Hi all, > >I am a newbie here. I was hoping someone would be able to tell me if >hostnames for the Linux OS is required for MySql Replication, and if >so why? I have been combing the manual and archives, but had no luck >in finding this answer. Wh

Replication Question

Hi all, I am a newbie here. I was hoping someone would be able to tell me if hostnames for the Linux OS is required for MySql Replication, and if so why? I have been combing the manual and archives, but had no luck in finding this answer. Any and all help is greatly appreciated. Thanks!!! ~Vi

Re: How to create temporary table in 4.0?

Hi, There is a bug in GRANT for CREATE TEMPORARY TABLE privilege which is fixed now in the 4.0.3 tree. Regards, Jocelyn - Original Message - From: "Philip Mak" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 7:38 PM Subject: How to create temporary table in

Re: How to create temporary table in 4.0?

>I can't get CREATE TEMPORARY TABLE to work due to a privilege problem. Run the mysql_fix_privilege_tables script. There are new privileges in 4.0.2, one of which applies to temporary tables. >Does anyone know what I'm doing wrong? > >mysql> update user set create_tmp_table_priv='Y'; >Query OK,

How to create temporary table in 4.0?

I can't get CREATE TEMPORARY TABLE to work due to a privilege problem. Does anyone know what I'm doing wrong? mysql> update user set create_tmp_table_priv='Y'; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 s

Re: Definition of structure MYSQL

Hi, If you have MySQL source/binary distribution, you must find in the "include" directory, the "mysql.h" file. The rule is the same for the both version (MySQL ver 3.x and MySQL ver 4.x) Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail

RE: Definition of structure MYSQL

It should be in mysql.h Check your installation and make sure it was installed. Our sysadmin originally installed MySQL without it - after all, he didn't need it so it must not have been important ;) Also, you will need to be sure and install the libmysqlclient and link with it. Regards, Ken

Re: Rename Table in Replication failed / command missing in slave log

> Lutz, > > - Original Message - > From: "Lutz Maibach" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Sent: Tuesday, August 13, 2002 5:09 PM > Subject: Re: Rename Table in Replication failed / command missing in slave > log > > > > Hi Heikki, > > > > > Lutz' problem looks

Re: How I compiled MySQL on Solaris 8

- Original Message - From: "John Warburton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 3:17 AM Subject: How I compiled MySQL on Solaris 8 > Hi All > > It seems that compiling MySQL on a Solaris 8 box is a non-trivial task if your > environment is different

Re: MySQL eating processer

Hi, To display the full query, just type SHOW FULL PROCESSLIST; Regards, Jocelyn - Original Message - From: "John Wards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 5:10 PM Subject: Re: MySQL eating processer > also some of the queries are copying to a

Definition of structure MYSQL

I have just installed mySQL - I have tried versions 3.23.51 win and 4.0.1 alpha win - but I cannot find a definition of MYSQL in any of the include or other files. Obviously, as a result, no client that I try to write in C will even compile. I have looked at the manual, and I have also bough

Re: Invalid table creation....

Robert, Tuesday, August 13, 2002, 6:21:08 PM, you wrote: R> I am using MySQL version 3.23.33 R> I was just playing around showing some one here at work some things when I R> accidently created a table named '44'. The server allowed me to do so - R> but will now not enable me to rename or drop t

Re: Problem in BLOB Field with zips

Aziz, Tuesday, August 13, 2002, 4:17:35 PM, you wrote: AD> How we can import a zip file into the blob field ? AD> I can import zip file into mysql but when i export it. The zip files doesnt AD> works. And its size becames smaller. AD> Is there anybody can help me??? How did you insert and retr

Re: Warning mysql.dll

Gelu, Saturday, August 10, 2002, 9:22:16 PM, you wrote: GG> In Win32 distribution version of MySQL(ver 4.x) , mysql.dll don't have entry GG> point for mysql_ssl_clear(). It's true. It was removed in 4.0.2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This emai

Re: MIN/MAX( IF( ...) ) problems: min bigger than max

Richard, Tuesday, August 06, 2002, 9:05:16 PM, you wrote: RU> Using MySQL 3.2.3.51-nt RU> I think there's something wrong with the way I'm combining the IF and MIN/MAX functions... RU> I'm using aggregate functions of the form MIN( IF( condition, int, NULL ) ), and MAX with the same predicate

Replication

MySQL Replication > I have successfully set up replication on the following platforms: > > Master - 3.23.51 running on Solaris 2.8 > Slave - 3.23.45 running on rh linux 6.2 > > When testing a network failure, the slave just seemed to hang and no error > messages were reported on either

Re: Invalid table creation....

At 11:21 -0400 8/13/02, [EMAIL PROTECTED] wrote: >I am using MySQL version 3.23.33 > >I was just playing around showing some one here at work some things when I >accidently created a table named '44'. The server allowed me to do so - >but will now not enable me to rename or drop the table (or add

Re: MySQL eating processer

John Wards wrote: > also some of the queries are copying to a tmp table and i know this aint > good! but I can't see the full query in show processlist how do you do this. > > Cheers > John > - Original Message - > From: "John Wards" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: T

Invalid table creation....

I am using MySQL version 3.23.33 I was just playing around showing some one here at work some things when I accidently created a table named '44'. The server allowed me to do so - but will now not enable me to rename or drop the table (or add data to it for that matter). Here is a dump of it's

Re: Problem in BLOB Field with zips

What size are the ZIP files? The default BLOB field has a size limit of 64KB. If your ZIP files are larger, they are being clipped. Use MEDIUMBLOB or whatever is most appropriate for your needs. tim. > How we can import a zip file into the blob field ? > > I can import zip file into mysql but

Re: MySQL eating processer

The question you should ask yourself is "What is it that my site may be doing that is causing MySQL to spike so much?" I came into a similar situation and found that there were 2 major things that were impacting the usage of the database. The first would be the database structure that you are

RE: Cyber security

Spam is such an ugly word. We believe that the attached piece, while not directly concerned with MySQL directly, may be of general interset to the list subscribers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 12:08 PM To: Andy Wood

Re: MySQL-Server doesn't connect to any port

> Florian Boehl wrote: > > Hi, > > > > I've got a problem with my mysql-server. I'm using Debian GNU/Linux > > (Sid). If I start the server there are no error messages at all but the > > server doesn't connect to any port so communication with it can only be > > done by the socket file. Has anyon

Re: MySQL eating processer

also some of the queries are copying to a tmp table and i know this aint good! but I can't see the full query in show processlist how do you do this. Cheers John - Original Message - From: "John Wards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 4:03 PM Subj

MySQL eating processer

Hi, MySQL is using between 40-60% of the processer and I can't figure out why. Has anyone got any handy hints how to start getting this down other than telling my users to ef-off. I am getting about 100,000 page imps a day which is a fair few but not that much. I am unsure where to start! Cheer

Re: BLOBs and DataBase... is it likely to corrupt it with them ?

On Tue, 13 Aug 2002, Mauricio Sthandier R. wrote: > I'm working with BLOBs in mySQL and Visual Basic... i read that > storing images in the database has worst performance than the > filesystem, but anyway I'm planning to store them in MediumBlobs. My > specific problem is that I don't know if I'm

Re: MySQL-Server doesn't connect to any port

Florian Boehl wrote: > Hi, > > I've got a problem with my mysql-server. I'm using Debian GNU/Linux > (Sid). If I start the server there are no error messages at all but the > server doesn't connect to any port so communication with it can only be > done by the socket file. Has anyone of you ever

Re: query quandary

Mark, I'm a great believer in 'divide and conquor', so let's take your clear statement of problem and knowing that we can't achieve it by brute force/direct attack, let's break it down and solve it a piece at a time: table contains title and date of records a) sort so that records are listed by

Re: Help! Urgent!

On Tue, 13 Aug 2002, John Wards wrote: > Hi folks i am in a bit of a panic. > > My server began playing up today and after ruling out apache and php it has > come down to mysql. > > I need to find out what queries the database is running that is making it so > slow. I can't figure out the comma

Re: Problem in BLOB Field with zips

On Tue, 13 Aug 2002, Aziz Durmaz wrote: > How we can import a zip file into the blob field ? > > I can import zip file into mysql but when i export it. The zip files doesnt > works. And its size becames smaller. Aziz, you are not extremely generous in describing what you tried to do and how yo

Re: BLOBs and DataBase... is it likely to corrupt it with them ?

I store images in the database for a few reasons. I do make sure they are in their own table though and link to another table via a key so I would have tbllisting with all the textual data information on a listing and then tbllisting_image which is just the primary key linking to tbllisting and a

Re: MySql <- Access

Could you use this in Access, perhaps ? SELECT * INTO mysql_table IN "" [ODBC;DSN=mysql_sample_DSN;SERVER=localhost;UID=root;PWD=] FROM access_table You need myODBC 2.5 at least., and set up a DSN for your mysql database. It has worked fine for me with string, numeric and memo fields. It transp

MySQL-Server doesn't connect to any port

Hi, I've got a problem with my mysql-server. I'm using Debian GNU/Linux (Sid). If I start the server there are no error messages at all but the server doesn't connect to any port so communication with it can only be done by the socket file. Has anyone of you ever had a similar problem? Thanks to

python classes and mysql

If I create multiple classes in python to deal with different aspects of a program and each of those classes needs to access mysql what is the best way of handling connections/cursors? 1) Each class opens a connection and creates a cursor. 2) The toplevel opens a connection which is passed to the

Re: How to integrate MySQL into my application?

On Tue, 13 Aug 2002, Tobias Eriksson wrote: > I heard that one can instead of having the mysql database running as a > server (separate process), one can integrate it as part of the > application through a shared lib (DLL or so lib). > > Anyone who's got a reference to a document describing thi

RE: mysql 4.1?

Sorry, but I can't seem to locate the page that addresses this question specifically -- so, what version is scheduled to support views? > -Original Message- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 5:40 AM > To: [EMAIL PROTECTED] > Subject

Next working binary version ?

Hi list, I've just a tiny question. I used mysql 3.23.49 linux binary package but i've got some problems with it. I should upgrade quite shortly because 3.23.49 binary package is buggy ... ). We have load problems, memory eating ... But i can't use mysql 3.23.51 binary package. ( see Re: 3.23.5

BLOBs and DataBase... is it likely to corrupt it with them ?

I'm working with BLOBs in mySQL and Visual Basic... i read that storing images in the database has worst performance than the filesystem, but anyway I'm planning to store them in MediumBlobs. My specific problem is that I don't know if I'm risking too much the database, perhaps the chance it will

Help! Urgent!

Hi folks i am in a bit of a panic. My server began playing up today and after ruling out apache and php it has come down to mysql. I need to find out what queries the database is running that is making it so slow. I can't figure out the command to use and what format it shoudl be in Thanks for

strange behaviour of aggregate functions in if() clauses

MySQL v3.23.49 linux Hi, We came across something strange here. select count(*), user from mysql.user; is illegal (ERROR 1140: Mixing of GROUP columns ... if there is no GROUP BY clause). But, select if( count(*) and user, 1, 0 ) from mysql.user; actually works. Is this a bug or

Re: Problem with BLOB Field

Try ActualSize instead. - Original Message - From: "deep kapasi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 8:33 AM Subject: Problem with BLOB Field > Hi, > > I have already posted this query 4-5 days ago but no >

socket protocol?

Anyone know offhand where in the source the socket protocols (commands, structures,...) are defined? Would like to write my own interface but not if I need to wade through code for weeks.. Having troubles with the mysql++ package so would prefer to develop my own. thank you, lennie

Problem in BLOB Field with zips

How we can import a zip file into the blob field ? I can import zip file into mysql but when i export it. The zip files doesnt works. And its size becames smaller. Is there anybody can help me??? - Before posting, please ch

Re: NULL values -- expected behavior or bug?

Empty strings are NOT nulls. They are just zero length strings. Aron Pilhofer wrote: >>Changing the column to allow NULL doesn't mean that any of the existing >>values will be *changed* to NULL. That seems to be what you're expecting, >>but why? >> > > >No, no. Maybe I didn't explain well enou

RE: Problem with BLOB Field

There was a reply posted last week --- James Frankman <[EMAIL PROTECTED]> wrote: > Blob limit is 64K use MEDIUMBLOB for your column and I got this from http://www.mysql.com/doc/en/Storage_requirements.html TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8 BLOB, TEXT L+2 bytes, where L <

Problem with BLOB Field

Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC 3.51.03 I have create a table which has BLOB field in which i want to save a bitmap file. To save record i create a AD

OLE object disappears in Access using ODBC

I have a lot of data in Excel and Access, and want to make it an SQL database. I don't have a lot of experience yet with MySQL, but maybe somebody can help me. Currently I want to use Access as graphical interface to MySQL, using MyODBC. In the future I want to make a GUI in PHP or ColdFusion. I

Re: Rename Table in Replication failed / command missing in slave log

Hi! The following might fix Pete's RENAME TABLE bug: ... August 12, 2002: If you ran in the AUTOCOMMIT mode, executed a SELECT, and immediately after that a RENAME TABLE, then RENAME would fail and MySQL would complain about error 1192 'Can't execute the given command because you have active lock

Re: problem : Mysql connectivity using username and password usingJSP in Linux OS

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 naveed abdul wrote: | | | Dear Sir/madam, | we are able to connect Mysql database using JSP in Linux RedHat-6.2 | OS (with out using user and password). |when we are trying to connect using user and password it was not able | to connect. | |

  1   2   >