Re: can't install DBI on panther

On 27 Jan 2004, at 00:37, tait sanders wrote: i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back reporting heaps of errors like the following: from Perl.xs:1: /System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380: 30: sys/types.h: No such file or directory

Installation on Embedded Platform

hi All, i am planning to write an embedded application which will be running on customized OS(Red Hat Linux) x86 architecture. i heard MySQL is fast real time database, so i am planning to use the same in my application. can i install MySQL on such a platform, if so where could i get the

naeem bhatti(software eng)

i am facing a problem in mysql unicode supported or not ,acutally i would like to use utf8 but it does not save data in mysql in correct format means it changes the lang and set some dummy values plz kindly inform me i am waiting from ur response

off-topic but need help : [FWD: ezmlm warning]

Hello, Today i have received the attached message from mysql-ezmlm. But I could not understand what is going on. Is there anyone who will be able to explain what the ezmlm tries to tell me and what I have to do? Thanks in advance.

Re: Installing from SOURCE or from RPM: your recommendation

IMHO, best way is building RPM from the SOURCE with fine tuning and install it. Download the RPM from mysql.com and just issue command: rpm -ivh MySQL-xxx.rpm is wery easy instant solution. Regards. Yuriy. Hi group? What do you recommend someone who wants to install MySQL on RedHat? Using RPMs

Hi all.

I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select USERID,NAME,LNAME Where DOC contains what ever

my.cnf on Shared Hosting

Hi, I want --ansi option for MySQL setting to ensure ANSI compatibility. Most shared hosting providers don't allow access to my.cnf. Is there anyway to do this on the fly in my script, PHP/Perl sample would be appreciated. Thanks. Hassan

Simple question : Find older CHILD for each PARENT

Hi, I have a simple problem that I don't know how to solve with mysql. I have 2 tables, a parent table and a child table. parent: --- | p_id | name | --- | 1| A | | 2| B | | ... |... | | 112 | C | | 113 | D |

Re: Simple question : Find older CHILD for each PARENT

Benjamin PERNOT wrote: I want to get a list of all the parents with the age and the name of the older child they've got. Let's say that a parent can't have 2 children with the same age. I can solve my problem by using multiple queries but that's not very clean and a bit heavy (especially if

reg: Can't open named pipe to host: . pipe: MySQL (2)

Hi! May I have the reason why this error occured in my Localhost. When I try to connect to MySQL on the Localhost I met the error *Can't open named pipe to host: . pipe: MySQL (2)* I have used; Windows 2000 SP 4 MySQL Server 4.0.17 max-debug Upon looking the documentation

update or replace with select statement

Hi, I know I can do insert into mytable select * from some_other_table; but I can't find the right syntax to use with either an update or replace. Ideally I'd like to do something like this: update mytable set mytable.a=(select other_table.some_column from other_table where

Problem with timestamp default values

Hi, There seems to be a problem with setting default values for the timestamp column type in version 4.0.17: mysql create table test (t timestamp default '2001-01-01 00:00:00' not null); ERROR 1067: Invalid default value for 't' In 4.0.16 this works normally: mysql create table test (t

tables_priv not read after restarting server

Can anyone tell me why the following behaviour occurs. There is no change to the contents of tables_priv after adding the table grant to some_user before and after the database restart. The database has been upgraded from 3.23 to 4.1.1 and the mysql_fix_privilege_tables script has been run. #

Load data infile

Hi, I'm trying to figure out how to extract only some of the columns from text file. I know that I can use LOAD DATA INFILE but I didn't find the way how to use it to load data only from for example 1st, 3rd and 6th column. Could someone give me some tips, please? TIA Dusan Pavlica

Support for Motoroloa Coldfire with uCLinux?

Hi, is there or will be a support for Coldfire Processors Platforms using uCLinux as OS ? thanks in advance Hans

Re: MySQL 3.23.58 seg faults occasionally

Michael, I guess the table is corrupt and its row contains a wrong trx id. InnoDB tries to retrieve an earlier version of the row, but the roll ptr in the row is garbage too, and it contains a nonexistent rollback segment id. InnoDB: Error: trying to return an SQL NULL field in a non-null

InnoDB file format changes 2004 - 2005; Re: InnoDB development

Chris, InnoDB file format changes: 4.1.0 - 4.1.1 introduced multiple tablespaces; 4.1.1 - 4.1.2 or .3allow multiple charsets in the same database installation (currently only the default charset is used in InnoDB); 5.0.0 - 5.0.x create all new InnoDB tables in a

Re: Inserting One new User = 2 entries in mysql.user when using MySQL 4.0.17?!

Hi, finally I solved the problem by myself, yippiee :-) During the upgrade from 3.x to 4.x I didn't create the indizes for the user, host und db-tables (I didn't use the mysql-fix-privilege-tables skript cause I did not whether there was one at all). The missing indizes caused MySQL to create a

RE: Hi all.

-Message d'origine- De : Andy Fletcher [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, January 27, 2004 4:42 AM À : [EMAIL PROTECTED] Objet : Hi all. I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing.

Using raw partitions

Hi all, Does anyone on the list have experience storing their tables and associated bits and pieces on raw partitions? The reason I ask is two fold: 1. Did you notice much in the way of performance difference (which OS you're using is probably very relevant here). 2. Have you had to deal with

Re: Memory Problems on G5/OSX/MySql4.0.17

I don't think there would be any benefit to using InnoDB, at least not from a transaction support view. After your nightly optimize/repair are you also doing a flush? That may help. I haven't seen any direct comparisons between HFS+ and file systems supported by Linux. I would believe that

Persistent connection with Apache 2.0 and perl

Hi, How I can make a persistent connection in httpd.conf and get the $dbh in my perl script ? Thanks for help Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,34€/mn) ; tél : 08 92 68 13 50 (0,34€/mn) -- MySQL General Mailing List For list archives:

Re: Hi all.

MySQL can help you out here, but there are many questions you need to answer first. 1. What exactly is in the DOC column? Binary data of some disgusting, inferior proprietary word processor document format, plain text, XML, LaTeX files? 2. If you answered But I like Clippy! to the above, go to

Syntax Check: Group BY with Joins

Hi, I'm having trouble with this query: SELECT Max(DATE_ADD('1970-1-1',INTERVAL Lastupdate/3600/24 DAY)) as BaskDate, ofm_baskets.Code, Sum(ofm_baskets.Quantity) AS TotalQty FROM (ofm_basklist INNER JOIN ofm_basklupd ON ofm_basklist.Session_id = ofm_basklupd.Session_id) INNER JOIN

Re: Hi all.

At 03:41 AM 1/27/2004, you wrote: I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select

RE: Syntax Check: Group BY with Joins

Eric Try putting the HAVING clause after group by. I believe having is the last clause (may be LIMIT). David -Original Message- From: Eric Ellsworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: Syntax Check: Group BY with Joins

Re: MySQL 3.23.58 seg faults occasionally

I guess the table is corrupt and its row contains a wrong trx id. InnoDB tries to retrieve an earlier version of the row, but the roll ptr in the row is garbage too, and it contains a nonexistent rollback segment id. InnoDB: Error: trying to return an SQL NULL field in a non-null innoDB:

RE: updates on slave server??

The updates on the slave will not syncronize to the master if you have a one direction master-slave relationship setup. It is possible however to setup each server as a master and as a slave so that server 1 is the master for server 2 and server 2 is the master for server 1. Then queries will

Stored Procedure and the procs.db column

Hi all, I'm investigating the Stored Procedures in MySQL 5, and I'm wondering... I've been looking through the procs table in mysql - what does column db do? It stays null when I defined a procedure. And how can you get a list of available procedures? SHOW PROCEDURE doesn't seem to work? With

FKs in InnoDB

Hi, I'm using MySQL 4.0.16 with InnoDB tables. From the command-line mysql console Is there an easy way to see all the names of the foreign keys in my db? Basically I want to generate a file that drops all the foreign keys currently in my db. thanks, Don

Re: data file too big

Is there any chance of loosing any data if I do that. Its a production machine with over 200 thousand customer tickets don't think so... Is there any other suggestions ? If you don't use InnoDB too much (you don't have a lot of data in InnoDB tables) then you can change size of InnoDB data

Re: Syntax Check: Group BY with Joins

Thanks for the thought. The HAVING clause, while it does belong behind the group by clause doesn't seem to be the source of the problem - I get the same error even when I take the HAVING clause out. Thanks, Eric - Original Message - From: Lopez David E-r9374c [EMAIL PROTECTED] To:

RE: FKs in InnoDB

SHOW TABLE STATUS In the Comment Column you have the definition of the foreign keys. Marc. -Message d'origine- De : Don Vu [mailto:[EMAIL PROTECTED] Envoyé : mardi 27 janvier 2004 17:48 À : [EMAIL PROTECTED] Objet : FKs in InnoDB Hi, I'm using MySQL 4.0.16 with InnoDB tables. From

Re: FKs in InnoDB

Hi, SHOW TABLE STATUS In the Comment Column you have the definition of the foreign keys. I have to disagree here. The only reliable way to get FK info, is to use SHOW CREATE TABLE tablename With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS

wildcards the field

Hi, I'd like to use a mysql database as a lookup to authorize people to edit a webpage. The idea is that people would go to a main login page for authentication and then when they visit a page they are authorized to edit, they see an edit this page link. What I'm envisioning is a really

Re: If Else statement

What I have is a shell script that gathers information from a computer, and I want the script to check to see if there is currently a record that already exists that has a certain Ethernet(MAC) address. I would also like to have an ID number for the record that auto-increments so that I can have

RE: FKs in InnoDB

Thanks, marc. -Don -Original Message- From: Mechain Marc [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:23 PM To: Don Vu; [EMAIL PROTECTED] Subject: RE: FKs in InnoDB SHOW TABLE STATUS In the Comment Column you have the definition of the foreign keys. Marc.

Using Wildcards in Query

I am converting over to mySQL from Access 2.0 and I am having a little trouble with a query. Here it is: SELECT Max(WBS) AS LastOfWBS FROM Projects Where((WBS)) Like txtEntryData(0).Text #%; I am trying to get the last WBS ID starting with a particular letter the user will type in the

RE: wildcards the field

Select * from table where path like '/data1%' and id='jones' This will serach in table 'table' all the records that match /data1* Best Regards, HuMPie @ Grunn.Org - Disclamer: All you do with the suggestion in this mail is you responsibillity even if your system will

RE: Using Wildcards in Query

Think this is what you seek (sory but its copy-ed out the ms-sql online books :)) This example displays the first initial and last name of each employee, for example, A Fuller: USE Northwind SELECT SUBSTRING(FirstName, 1, 1), LastName FROM Employees Best Regards, HuMPie @ Grunn.Org

Re: Using Wildcards in Query

It sounds as if you need to use a regular expression. For very simple string comparisons, use =, as in _wbs='Fish'_ For more complex string comparisions with simple wildcards, use LIKE as in _wbs LIKE %fish% _For most complex comparisions, use a regular expression, as in _wbs REGEXP .\d_ In

Index on a bit?

Hi all, I was hoping to use a TINYINT to store 8 distinct boolean values. That works fine, but is there any way to optimize searching on a specific bit? I didn't see a way for MySQL to create an index on a specific bit of the TINYINT. Am I better off wasting space by putting each boolean value in

Replication corrupted

I rebooted the slave machine after it went unresponsive and now I can't get replication to start. Here is the show slave status printout. Anyone have any idea how to fix this? mysql show slave status \G *** 1. row *** Master_Host:

Re: Using Wildcards in Query

This worked great. Thank you very much. Douglas Sims [EMAIL PROTECTED] 1/27/2004 12:23:59 PM It sounds as if you need to use a regular expression. For very simple string comparisons, use =, as in wbs='Fish' For more complex string comparisions with simple wildcards, use LIKE as in wbs LIKE

Re: can't install DBI on panther

well I finally got DBI 1.40 installed thanks to all you lot. FYI - I installed all the developer tools - not the select few I had chosen previously, then modified the mysql_config and the makefile created. this worked. thanks heaps for all the help. ta tait On 27/01/2004, at 6:00 PM, Steve

Re: Index on a bit?

Sounds to me like you are either trying to re-invent the wheel, or you're running your database on an old 10MB hard drive. I would just use 8 discrete fields, indexed, and waste those 7 extra bytes. -Mark Mike Boone wrote: Hi all, I was hoping to use a TINYINT to store 8 distinct boolean

Re: Index on a bit?

At 04:13 PM 1/27/2004, Mike Boone wrote: Hi all, I was hoping to use a TINYINT to store 8 distinct boolean values. That works fine, but is there any way to optimize searching on a specific bit? I didn't see a way for MySQL to create an index on a specific bit of the TINYINT. Am I better off

Require greater than 255 in varchar?

I have a large chunk of text I've attempted to put into a varchar field, and it chopped off a chunk of it. If I need to enter text that is greater than the default 255, what choice should I use instead? Thanks, Eve -- MySQL General Mailing List For list archives:

Re: Memory Problems on G5/OSX/MySql4.0.17

I have managed to get what looks like 2G for the process, but, it does not want to do a key_buffer of that size I gave it a Key_buffer of 768M and a query cache of 1024M, and it seems happier.. though, not noticeably faster. [mysqld] key_buffer = 768M max_allowed_packet = 8M

Error log message on MySQL startup

On a new installation of mysql on a Mac OS X machine 10.3.x I am getting the following in the .err log: 040127 17:23:29 mysqld started /Library/MySQL/libexec/mysqld: ERROR: unknown variable 'innodb_buffer_pool_size = 70M' 040127 17:23:32 mysqld ended 040127 18:43:58 mysqld started

PHP connection to MySQL fails (newbie)

Trying to get make my first PHP connection to a DB. The mysql_connect appears to be the point of failure. The line number in the error output correlates to the call. Am able to use the same user, password, etc, to connect to the accounting database as either user llama and user root using the

Re: Reducing MySQL memory consumption?

On Sat, Jan 24, 2004 at 01:56:53PM -0600, Dan Nelson wrote: You didn't say what OS you're using, but the below top output looks like Linux's procps top, which doesn't tell you your paging rate. Run vmstat 1 and watch the si and so columns. Just because swap is being used doesn't mean you're

RE: Require greater than 255 in varchar?

Eve, You can look at http://www.mysql.com/doc/en/Column_types.html Or: [NATIONAL] CHAR(M) [BINARY | ASCII | UNICODE] A fixed-length string that is always right-padded with spaces to the specified length when stored. The range of M is 0 to 255 characters (1 to 255 prior to MySQL Version 3.23).

Re: Require greater than 255 in varchar?

Either a BLOB or TEXT field should be your solution. See http://www.mysql.com/doc/en/BLOB.html for the description. Bernard On Tuesday 27 January 2004 22:29, Eve Atley wrote: I have a large chunk of text I've attempted to put into a varchar field, and it chopped off a chunk of it. If I need

Re: create threads rate

Hello, Do you have add in your my.cnf skip-name-resolve ? If not maybe the problem come from here. Also upgrade to 4.0.17 will fix some bug on FreeBSD if i remenber right (check maybe changelog) At 11:42 26/01/2004, Varshavchick Alexander wrote: Hi, I have a 4.0.7 mysql server which services

Re: PHP connection to MySQL fails (newbie)

Is your host name rh01? That is supposted to be the host name (www.rh01.com) or IP address(127.0.0.1). also try adding this: $db_connection = mysql_connect (rh01, llama, camel) OR die (font color = \red\ size = \+2\Could not connect to database. Please try again later/font. mysql_error()); At

Query help

Hi I have a table called sections with the following structure: +---++--+-+-++ | Field | Type | Null | Key | Default | Extra | +---++--+-+-++ | secid | int(11)|

Re: PHP connection to MySQL fails (newbie)

Thanks, Ligaya. Yes, the system name is rh01, according to localhosts and /etc/net and /etc/sysconfig/network. Your question caused me to question my networking configuration, so I tried connecting to localhost. That seems to work. Was able to add a row to the table. Cheers, Drubl

questions about bind_param and mysql

I have a snippet of code below. I'm trying to use teh bind_param option to select multiple rows using a foreach loop. after doign some reading I realized this is supprted through DBD are there any special measures that I need to take to make bind_param work. ## select rows in table based

re: Query help

No. With the method you're using (storing the parent id with each record) you have to use a recursive series of queries to show the subtree levels. Take a look at this article--especially the second and third pages about the modified preorder tree traversal and nested sets. There are many

Re: Reducing MySQL memory consumption?

In the last episode (Jan 27), Philip Mak said: No, mysql is taking up 23MB. Linux creates separate processes for each thread, which is why you see lots of mysqlds in top. They all share the same address space, though. Are you sure you don't maybe have a couple dozen apache processes

Re: Memory Problems on G5/OSX/MySql4.0.17

I have had linux on soft-raid5 (6x18G, 8x9G, 4x18G) systems, and the load was even higher... The explanation for this could be that at high IO rates the data is not 100% synced across the spindles, and therefore smaller files (ie files smaller than the chunk size on each physical disk) must

MYSQL Security

Hi All, I'm newbie in MYSQL. Would please tell me about Mysql Security ? I used Windows2000 for mysql server. thank you - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

Select older than minutes

I have done this so many times.. SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) 7 I have scoured (more like glanced :-)) at the docs on http://www.mysql.com/doc/en/Date_and_time_functions.html and can not seem to find how to get all records where a timestamp(14) is older than

RE: Select older than minutes

SELECT * FROM `support_start` WHERE (NOW() - (60*7)) TO_DAYS(date) Not the most optimized way of doing it, but it would work. 60 seconds in a minute and 7 minutes is the example. Donny -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004