Re: help for pdf file

Hi ~Elle~, No rpm, or any package is needed. It's just plain PHP that's being used in FPDF, no binaries whatsoever. Just download the classes and follow the many examples on the site to start using them. Regards, Jigal. - Original Message - From: "Elly Wisata" <[EMAIL PROTECTED]> > Any

mysqlbinlog: unknown command errors

Hi, I'm having problems running queries in my binlog that contain binary data. Apparently the / character is being interpreted as a mysql command and I get errors. The queries must have gone through on the original machine because they're there in the binlog. Specs are: original server: mysqld Ver

Re: Xserve G5

> Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh > OSX? > > We are thinking of purchasing some new hardware to run our MySQL server. The > 64-bit architecture is something we would like to take advantage of. > > Is this good, bad, otherwise? Any comments would be app

unable to resolve hostname...

Ok, I am going about this as I normally have umpting times # scripts/mysql_install_db and I get Neither host 'isdesign.isdesigndev.com' and 'localhost' could not be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this

RE: help for pdf file

Any rpm version? ~Elle~ -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 5:17 PM To: [EMAIL PROTECTED] Subject: Re: help for pdf file > I don't know this related to php subject or mysql subject, but does anybody > knows how to create a pdf

RE: 4.1 Stable Enough For Beginner To Use? [SOLVED]

Thanks to all who responded. I think I will attempt to rn MySQL 4.1 for my web sites. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bookings

I am (trying) to make a booking systems. Currently I have a table with 3 timestamps that record bookingDate, bookingFromDate and bookingToDate I have another table that records 'seasons'. This table contains two timestamps that record seasonStartDate and seasonEndDate also I have the rates as seas

Re: Xserve G5

The benchmarks look good for opterons and mysql, i just scored a Sun Fire V100, still havent benchmarked that yet though. > Not to start a flame war, but just a question/suggestion... > > Do you specifically want a Mac (i.e. are you a Mac shop), or are you > looking for inexpensive 64 bit? > > If

Re: A problem with access to data source, please help!!!!

I had a bunch of problems setting up OpenCMS until I figured it out. OpenCMS tries to connect via the network socket, so the connection to the database may look like it's coming from the.host.name.com. You may need to add the full host name of the machine you are installing on to the privilege

Re: Xserve G5

Not to start a flame war, but just a question/suggestion... Do you specifically want a Mac (i.e. are you a Mac shop), or are you looking for inexpensive 64 bit? If the latter applies, you might want to look at an AMD64 box running Linux (SuSE and Mandrake are two that come to mind as having 64

Re: Feature request related to COMPRESS and UNCOMPRESS functions

> Here is the background: Anyone that is running a huge system like MARC > that has millions of uncompressed blob records in huge tables, needs to be > able to migrate, in real-time and without down-time, to compressed blobs. > Therefore, we need a way to know if a given field is compressed or not

Re: Using mod_auth_mysql with Apache 2

Look in /etc/httpd/conf.d. These config files are included by a line in httpd.conf. Now, find the config file for mod_auth_mysql. At the top, there may be something like ...stuff there... . For some reason, the installed RPM is not defining HAVE_MOD_AUTH_MYSQL, thus it isn't loading. Comm

RE: More on indexes?

Hi Eve: Indexing is use to speed up search in the tables. You can have Primary Key Index to force unique key ( Ex: Client_Cod), or normal index in columns you use to get data in an alternate way(Ex: Client_Name). If you have very little data in your tables, the speed will not notice the speed but

More on indexes?

Hi, I've been following the list to get a better grip on MySQL, and have been hearing a lot about indexing. I'm beginning to think I should have indexed some of my tables in the past. Can anyone point me in the right direction as to the purpose of indexes, why they are used, the benefits, and whe

RE: Re[2]: Type TEXT

If speed is a concern and storage is not, I believe that the fixed length char() will provide a better speed. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Richard Davey [mailto:[EMAIL PROTECT

Re[2]: Type TEXT

Hello Jim, Monday, March 1, 2004, 8:58:51 PM, you wrote: JM> Thanks. What (if any) difference is there then be between a varchar(255) and JM> a tinytext column? On the surface nothing I believe. Varchar too is a variable length data type. There may well be internal differences in the way MySQL

RE: UID/PW Question???

During the last week I have asked couple of questions regarding setting up MySQL & have gotten good answers. Since my knowledge of MySQL is in the beginer level, and I am very close to finishing up working with MySQL, I have several questions still un answered. I will try asking one question at a

Re: "hot" innodb backup options

Anonymous wrote on Mon, 01 March 2004 13:26All, I have a database where the tables are InnoDB. I am working on the backup procedure, and would like to implement a process where the database is backed up without having to shut it down (live, or hot backup). Reading the documentation, it appears

Re: "hot" innodb backup options

this is just my $0.02, but I would think $500/yr is certainly worth it. you'll get a fully supported product, and the money goes to a good cause. jeff Kevin Williams wrote: All, I have a database where the tables are InnoDB. I am working on the backup procedure, and would like to implement a pr

memory issue: paging, disk activity, table size -> was: optimizing a select statement

Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command. The activity monitor shows t

Re: Best Database

check into innodb and transactions Respectfully, Ligaya Turmelle ""Paul Higgins"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi everyone, > > I want to create a table that will consistently have data added and removed > from it. Is there anything I should know/consider before

Xserve G5

Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh OSX? We are thinking of purchasing some new hardware to run our MySQL server. The 64-bit architecture is something we would like to take advantage of. Is this good, bad, otherwise? Any comments would be appreciated. Th

RE: Executing REPLACE from IF statement?

And to finish it off, I just removed pb.ticker="SAP500" statement. -Original Message- From: Pilarinos, Dionysios Sent: Monday, March 01, 2004 4:56 PM To: [EMAIL PROTECTED] Subject: RE: Executing REPLACE from IF statement? After some thought, this is what I came up with: REPLACE current

RE: Executing REPLACE from IF statement?

After some thought, this is what I came up with: REPLACE current_profile select c.* FROM product_bench pb, current c, bench_current bc WHERE pb.ticker="SAP500" and c.ID=pb.ID and bc.ticker=pb.ticker and DATE_FORMAT(c.mdate,'%m/%d/%Y') = bc.mdate Now all I have to do is make this run for each

RE: Replication / Synchronizing DB across different machines

I believe Gowtham's response is accurate. If the link goes down it is going to unclear which update becomes the final one, and it will be possible for one side to contain the row after one update, and the other to contain the row after the other update, thus being out of sync. Mysql has no suppor

Re: Replication / Synchronizing DB across different machines

>> But what happens if there is a break of >> communication and the same record on both machines >> is modified? For example, if the sync link is ? >> down, and I update record #1 on A, while at the >> same time, another user is modifying record #1 on >> server B. When the link comes back onlin

Re: Type TEXT

- Original Message - From: "Richard Davey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 01, 2004 11:02 AM Subject: Re: Type TEXT > Hello Jim, > > Monday, March 1, 2004, 5:44:22 PM, you wrote: > > JM> Are the TEXT column types padded out to their max length by spaces? >

Executing REPLACE from IF statement?

Hi, I was wondering if someone can point out a way to make the below script update a row. Query: SELECT pb.ID, c.mdate, bc.mdate, IF(DATE_FORMAT(c.mdate,'%m/%d/%Y') = bc.mdate, "Same Date", "Not Same Date") FROM product_bench pb, current c, bench_current bc WHERE pb.ticker="SAP500" and c.ID=pb.I

Re: Embeded MySQL for Java ???

You can try with a JNI native class. Santino At 10:53 -0600 1-03-2004, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Victor Medina wrote: Hi!! No there isn't Although, you can try bdb(www.sleepycat.com), it comes with a java access class that will let you use bdb in a

"hot" innodb backup options

All, I have a database where the tables are InnoDB. I am working on the backup procedure, and would like to implement a process where the database is backed up without having to shut it down (live, or hot backup). Reading the documentation, it appears the only option I have is to purchase a solu

complicated select statements and out of memory errors

Hi there, I have some rather complicated sql statements that seem to eat up all resources from mysqld. Once I have two of them running at the same time no one can log on any more. Simple queries involving distinct get a out of memory error. We have tried changing the index buffer size from 256M

Why do we need <>~ in BOOLEAN MODE?

<>~ are supposed to adjust the weight of a word to the relevancy score, but they only work in BOOLEAN MODE and BOOLEAN MODE doesn't care about relevancy! In my opinion, they should be only allowed in the regular fulltext search in which we DO compute the relevancy. Am I missing something? Thank

Re: Type TEXT

"Jim McAtee" <[EMAIL PROTECTED]> wrote: > Are the TEXT column types padded out to their max length by spaces? No. It's variable-length column type. http://www.mysql.com/doc/en/Storage_requirements.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This e

Re: Privileging

"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote: > > I have a user that is granted all privileges for their database. When = > they run a select * on a table in that database, the request fails after = > about 1000 records. When I run the same query as root, I have no = > problems. Consequently, I

Re: Communication link failure - MySQL Server seems to stop

Hi Mark, It is not easy to produce a test case as it happens after some thousands of DB accesses. It also happens with 4.1.1-alpha (from mysql.com) . I did not try the bitkeeper version. But it seems it has something to do with using Server Prepared Statements. It did not happen when I spec

Re: BUG?

More of the same: mysql> select 260.22 + 18.81 - 279.03; +-+ | 260.22 + 18.81 - 279.03 | +-+ |

Re: Type TEXT

Hello Jim, Monday, March 1, 2004, 5:44:22 PM, you wrote: JM> Are the TEXT column types padded out to their max length by spaces? No, they're variable length and at a maximum of 65KB per row, be thankful of this! A 30 character string will take up 32 bytes for example. -- Best regards, Richard

Re: Losing indexes after building from dump.

Toby wrote: I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly th

Re: mysqld crashes, stack trace doesn't help

Claus wrote: Hi all, we have rh 9.0 (kernel 2.4.20) mysqld 4.0.15 php 4.3.3 apache 1.3.29 and a quite large (10.000 unique visitors/day) server and messageboard (phpbb). every 2 or 3 days the server crashes (mysqld crashes, then all myslqd_safe and httpd processes crashes one after one) there is

Re: BUG?

[EMAIL PROTECTED] wrote: Arithmetic results in a value of zero but mysql is treating the value as > 0. This is reproducible in a lot of different ways. Below is a pretty clear example. mysql> select version(); +---+ | version() | +---+ | 4.0.17-max-nt | +---

Re: myisamchk "operation not permitted" problem

The problem is the data file is about 25GB. The index file generally turns out to be at least half the size(~15GB)Unfortunately, I don't have 40GB free space on the machine. That's why the NFS server came into picture. I managed to start the table rebuild from a linux box running MySQL4.0.12. S

Type TEXT

Are the TEXT column types padded out to their max length by spaces? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: myisamchk "operation not permitted" problem

Rishi Pande wrote: Hello, I have been having trouble with rebuilding a database from backup. The backup consists of the MYD and frm files only. Therefore, I need to rebuild the myi file. I am using MySQL4.0.14 on Mac OS X. I use the myisamchk command to rebuild the database, in the follow

Re: Can't execute ./bin/mysqld_safe from dir /var/lib

jda wrote: I had MySQL running just a couple days ago, but now it is not. The command and error: # /usr/local/mysql/support-files/mysql.server start Can't execute ./bin/mysqld_safe from dir /var/lib There is mysql directory under /var/lib, but I am not executing from there. If i go to /usr/local/

Optimising LIMITs

Hi all, I have what is probably a quite standard question and would love to know how you would all approach this scenario: I have a table in a database that has approx. 190,000 records in it. The table is currently 128MB in size and I'm happy that it is well constructed with no data duplication a

Re: problem with 4.0.18

Andrea Riela wrote: Andrea Riela wrote: Could you help me? well, I've tryed with ktrace, see my kdump: http://www.nesys.it/kdump Andrea: Could you ktrace mysqld itself rather than mysqld_safe ? -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For

BUG?

Arithmetic results in a value of zero but mysql is treating the value as > 0. This is reproducible in a lot of different ways. Below is a pretty clear example. mysql> select version(); +---+ | version() | +---+ | 4.0.17-max-nt | +---+ 1 row in set (0.00 sec)

Re: Embeded MySQL for Java ???

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Victor Medina wrote: > Hi!! > > No there isn't > > Although, you can try bdb(www.sleepycat.com), it comes with a java > access class that will let you use bdb in a embeded environment, one > thing i must say, is that it does not use jdbc, instead it u

Re: When I woke up this morning...

Is there anything else running on the machine that might have used up a bunch of memory or CPU (check in your Task Manager - see how much free memory you have). Queries will run much faster if the data is cached in memory. If some other process has requested and received most of the memory in your

Re: Communication link failure - MySQL Server seems to stop

hl said: > Hi, > > What can I do to find the cause / correct the following problem? > > More often I get the following with Connector/J: > > error com.mysql.jdbc.CommunicationsException: Communications link > failure due to underlying exception: > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFExc

Re: When I woke up this morning...

Analyze your table. Your cardinality is invalid. >> Original Message << On 3/1/04, 10:22:36 AM, Brian Power <[EMAIL PROTECTED]> wrote regarding When I woke up this morning...: > Hi all, > I'm a having a stange problem with mysql-nt on win2000. > Querys that la

When I woke up this morning...

Hi all, I'm a having a stange problem with mysql-nt on win2000. Querys that last night were taking just 2 seconds are now taking 1m 30secs +. I have a table... FieldType Collation NullKey Default Extra Privileges Comment --- -

Re: my.cnf Setup!!

Kirti S. Bajwa wrote: Hello List: I have setup MySQL and it is working fine. I tested connection to MySQL. Now I have gone one step futher and added a password for mysql, as follows: shell> ./mysqladmin -u root password mysqlpw Now I want to setup myc.cnf. Our SQL server is a standalone ser

Re: The very first day of march :-) (select (curdate()-1);)

Bernard Clement wrote: Your select works fine within the month to the exception of the first day because curdate()-1 is treated as a numeric field (see curdate in http://www.mysql.com/doc/en/Date_and_time_functions.html) The following seems to be what you want to do: mysql> select date_format(c

Re: Strange bug(?) with Phrase search in BOOLEAN MODE

Hi! On Mar 01, William Au wrote: > Sergei, but this is a phrase search. The original query is: > > match (keywords) against ('"16-bit Touch"' IN BOOLEAN MODE) > > So shouldn't all words that are actually searched on be present > in a particular order? Ok, sorry. If the original query is '"16-b

A problem with access to data source, please help!!!!

Hi, I am trying to configure Open CMS 5.0.0 with mysql. But while Database and and table creation I am getting following error. Could no connect to database via: jdbc:mysql://localhost:3306/ java.sql.SQLException: Server configuration denies access to data = source --

RE: my.cnf Setup!!

Hello List: I have setup MySQL and it is working fine. I tested connection to MySQL. Now I have gone one step futher and added a password for mysql, as follows: shell> ./mysqladmin -u root password mysqlpw Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9, Dual CPU, 1.5GB

Re: Weird behaviour

Excuse my blindness please! Thank you, Bostjan On Monday 01 of March 2004 16:19, Michael Stassen wrote: > This is documented behavior : > > Please note: the `_' and `%' wildcards are allowed when specifying > > database names in GRANT statements that grant

Re: Another loss of mysql

There are many companies that develop on MySQL then market the product with Oracle for the same reasons you statethe name. curtis On Mon, 1 Mar 2004, Leo wrote: > After two years of developing a new system based on MySQL > for the company i work at... > > it turned out to face a failure..

BOM Select statement

I have a file called STRUCTUR which is typical of any Bill-Of-Materials in an MRP system. The format is similar to this: STRUCTUR.ITEM, STRUCTUR.QTY, STRUCTUR.PARENT_ITEM You define multi-level material lists for items and for components of those items ... Here is an example ITEM; QTY; PA

Re: Weird behaviour

This is documented behavior : Please note: the `_' and `%' wildcards are allowed when specifying database names in GRANT statements that grant privileges at the global or database levels. This means that if you wish to use for instance a `_' character as par

Re: Strange bug(?) with Phrase search in BOOLEAN MODE

Sergei, but this is a phrase search. The original query is: match (keywords) against ('"16-bit Touch"' IN BOOLEAN MODE) So shouldn't all words that are actually searched on be present in a particular order? Bill Sergei Golubchik wrote: Hi! On Feb 27, Haitao Jiang wrote: Thanks! That was wh

Re: Dumping MySQL result set to a spreadsheet

SELECT into OUTFILE " Should get you a tab delimited file there are more options for using different delimiters and field encapsulations, etc. Its in the manual. curtis On Sun, 29 Feb 2004, Joshua Beall wrote: > Hi All, > > I am wondering if anyone can point me to a utility that will le

Re: Design Advice?

> If you are not using 5.0 and don't want to switch to 5.0, then using > database "view" will also work. This link tells how to create views: > http://www.mysql.com/documentation/maxdb/6d/117c44d14811d2a97400a0c9449261/content.htm What version does this work for? We're using 4.0.14 and it doesn'

RE: unique values across more than one column

Hi, Could you just break out the email information into its own table? Then you could have columns like the following: UserID (foreign key), email (varchar), type (int: 1=primary email, 2=alias email). Then you can just have the email column defined as a unique index and relate the email to the

Re: Weird behaviour

Same for version 3.23.58. On Monday 01 of March 2004 13:47, Bostjan Skufca (at) domenca.com wrote: > Hello > > I am using MySQL 4.0.18 and i have come accross weird behaviour. > > I created the databas and user like this: > CREATE DATABASE dev_project; > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DR

Auto-Confirmation

Thank you for submitting your request to Quest Software Technical Support. We are unable to process your request because our records indicate that you are not registered for Technical Support. To register, logon to our Supportlink web site http://www.quest.com/support , and self-register from

Weekly activity report

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Weird behaviour

Hello I am using MySQL 4.0.18 and i have come accross weird behaviour. I created the databas and user like this: CREATE DATABASE dev_project; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES ON dev_project.* TO [EMAIL PROTECTED] IDENTIFIED

Hardware devices price-list

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The very first day of march :-) (select (curdate()-1);)

Your select works fine within the month to the exception of the first day because curdate()-1 is treated as a numeric field (see curdate in http://www.mysql.com/doc/en/Date_and_time_functions.html) The following seems to be what you want to do: mysql> select date_format(curdate()- interval 1 da

Re: The very first day of march :-) (select (curdate()-1);)

040300 | +---+ 1 row in set (0.00 sec) mysql> Until yesterday select (curdate()-1); worked fine. Are you sure of that? As far as I know, you have to use a function like date_add() or date_sub() to to date addition / subtraction. What you're doing is turning 2004-03-01 into the n

Re: help for pdf file

At 17:01 +0700 1-03-2004, Elly Wisata wrote: I don't know this related to php subject or mysql subject, but does anybody knows how to create a pdf file from php & mysql? Or maybe somebody can show me a url contain about it which is clear. Coz I found some url discussing about it but quite confusing

Re: help for pdf file

> I don't know this related to php subject or mysql subject, but does anybody > knows how to create a pdf file from php & mysql? http://www.fpdf.org is a free PHP library which can help you produce pdf files. You have to write your own functions for formatting tables, etc. but the actual creation o

The very first day of march :-) (select (curdate()-1);)

Hi, Look at what happened today : mysql> select curdate(); ++ | curdate() | ++ | 2004-03-01 | ++ 1 row in set (0.00 sec) mysql> select (curdate()-1); +---+ | (curdate()-1) | +---+ | 20040300 | +---+ 1 row in set (0.00

help for pdf file

I don't know this related to php subject or mysql subject, but does anybody knows how to create a pdf file from php & mysql? Or maybe somebody can show me a url contain about it which is clear. Coz I found some url discussing about it but quite confusing. Thanks in advance ~Elle~

Another loss of mysql

After two years of developing a new system based on MySQL for the company i work at... it turned out to face a failure.. not because the performance.. nor the price... finally the company choose Oracle Application Suite because the Oracle brand it self is a guarantee to bussiness competition i m

Re: Dumping MySQL result set to a spreadsheet

Neale Banks wrote: > Should we presume you haven't noticed the, admittedly not widely > publicised, Database Access features of OpenOffice.org? You can use odbc > or jdbc (I can only vouch for the latter, on Linux) to connect to the > mysql server from within OOo. "Should" work just fine on your