MySQL Client on a PIC

2004-07-23 Thread Stephen Finn
Hi All, I am hoping to implement a simple MySQL client on a PIC18 microcontroller. Basically the client will need to connect to a server upload some data and then disconnect. My current stumbling block is the handshaking involved in establishing a connection. I would like to find an RFC or simil

RE: Object pascal translation of mysql header

2004-07-23 Thread Leo
Im sorry if this classified as OOT One example of the confussion C Header File declaration of statement handler (taken from the 4.1.3) typedef struct st_mysql_stmt { MEM_ROOT mem_root; /* root allocations */ LIST list; /* list to keep track of all

Object pascal translation of mysql header

2004-07-23 Thread Leo
Dear All, Not long ago Jorge del Conde gave me his amazing translation of mysql C header file to object pascal unit Including the remade dll, It was able to solve my problem of migrating the apps from using mysql 3.x to 4.x But now I am facing a new difficulty of trying to implement mysql 4.1.3 pr

mysql /dbi issues

2004-07-23 Thread bruce
can anyone tell me why when i build/use perl/dbi it crashes because it's looking for libmysqlclient.so.10. i'm using perl 5.8.3 and mysql4.1.3. i've gotten the latest DBI (1.43). why does DBI look for libmysqlclient.so.10, instead of using libmysqlclient.so.14. is there anyway to force a change,

Re: Logging on through ODBC w/o UN & Password (Why is my query tool allowing this?)

2004-07-23 Thread Mir Islam
In all likelihood in your database you have not setup any access privilege yet. You need to look at GRANT command and assign password to atleast root account and any other accounts which will be connecting over network. On Fri, 23 Jul 2004 11:38:06 -0700 (PDT), john sayre <[EMAIL PROTECTED]> wrote

Best field type for status codes

2004-07-23 Thread Scott Haneda
I often find I am using a field called 'status' and almost always store boolean 1 or 0 in it, sometimes I may need a 2 or 3, but never greater than 9 for sure, Is tinyint(1) pretty much the most efficient storage means for this type? -- -

Re: Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Scott Haneda
on 7/23/04 3:00 PM, Paul Fine at [EMAIL PROTECTED] wrote: > SELECT * FROM tablename > > WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty' This is perfectly accurate -- - Scott Haneda

Re: Errcode: 27

2004-07-23 Thread J S
Thanks but that's not v helpful. Actually that was my thread! The problem there was that I didn't have a large-file enabled filesystem. The problem I have now is being able to create another index on a table but getting an errcode 27 despite no ulimits and a large enabled filesystem. This shoul

Re: how the redhat 9.0 adds the mysql user:

2004-07-23 Thread j.rabbit
> "j.rabbit" <[EMAIL PROTECTED]> wrote: > > > This is how the redhat 9.0 mysql.spec file adds the mysql user: > > > > ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u = > > 27 mysql ' > > > > Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' = > > lik

RE: Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Kevin Ward
Paul, You can do the following: SELECT * FROM tablename WHERE columname IN ('Bob','Mike','Betty'); Kevin > -Original Message- > From: Paul Fine [mailto:[EMAIL PROTECTED] > Sent: Friday, July 23, 2004 3:01 PM > To: [EMAIL PROTECTED] > Subject: Another newbie question - using OR in WHE

Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Paul Fine
Is there a simpler way to write something like: SELECT * FROM tablename WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty' Clearly this does not work: WHERE columname = 'Bob' OR 'Mike' OR 'Betty' Thanks!

Re: Last insert id problem/bug

2004-07-23 Thread Scott Haneda
on 7/23/04 5:30 AM, Harald Fuchs at [EMAIL PROTECTED] wrote: > The behavior is indeed strange, but it's not a bug, since it's documented: > > If you use `INSERT IGNORE' and the record is ignored, the > `AUTO_INCREMENT' counter still is incremented and > `LAST_INSERT_ID()' returns t

Re: Errcode: 27

2004-07-23 Thread Aman Raheja
This should be a useful thread for you http://lists.mysql.com/mysql/167953 Suggests using ALTER TABLE MAX_ROWS= On Fri, 23 Jul 2004 20:20:24 +, "J S" <[EMAIL PROTECTED]> wrote : > Hi, > > I'm trying to run the following SQL (on > mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc): > > CREA

Errcode: 27

2004-07-23 Thread J S
Hi, I'm trying to run the following SQL (on mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc): CREATE INDEX timeindex ON internet_usage (time); CREATE INDEX urlindex ON internet_usage (urlid); but keep running into the following error: Error writing file '/proxydb/mysql/tmp/STeR39Er' (Errcode: 27) $ perro

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
That's just perfect! Than you so much! -- Aeon McNulty On 23/7/04 8:50 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > Yep, just what I needed. > > SELECT > c.CompanyName > , MAX(IF(m.Member_Initials='ABS', s.Subscription_Expiry_Date, > NULL))as 'ABS' > , M

Re: IMPORTING

2004-07-23 Thread Robert J Taylor
On Friday 23 July 2004 03:02 pm, you wrote: > sqlog program What is "sqlog program"? Google shows me nothing familiar: http://www.google.com/search?q=sqlog+program You need to provide more information if you want help. How do you run this? What OS? What options are you selecting? How do you con

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread SGreen
Yep, just what I needed. SELECT c.CompanyName , MAX(IF(m.Member_Initials='ABS', s.Subscription_Expiry_Date, NULL))as 'ABS' , MAX(IF(m.Member_Initials='BV', s.Subscription_Expiry_Date, NULL))as 'BV' , MAX(IF(m.Member_Initials='CCS', s.Subscription_Expiry_Date, NU

RE: building mysql-5.0 clarification

2004-07-23 Thread bruce
oops... clarification, i'm using mysql-4.1.3. the reason i can't use the binaries/rpms is that i have a dependency conflict with openssl..., so i need to be able to rebuild to make everything work. unless anyone has a different solution... thanks -bruce -Original Message- From: bruce [

building mysql-5.0

2004-07-23 Thread bruce
hi... i'm building mysql-5.0 from src for rh8.0. my question has to do with how/where i find the libmysqlclient.so.10 lib. when i've built the mysql-5.0 i haven't found this file. it appears that this file has been included in the mysql-shared-compat* file, but i can't find this file either for t

precision differences between Windows & Linux?

2004-07-23 Thread Kevin Ward
I have come across a very strange occurrence while working on a client's system. I get different behavior between the two servers (one Windows, one Linux) when it comes to a column defined as double(5,4). The Windows system truncates new values (existing data in the table is not truncated) whereas

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
Hi Shawn I hope this gives you what you need: SELECT member.Member_Initials, company.Company_Name, subscription.Subscription_Expiry_Date FROM subscription INNER JOIN member ON member.Member_URN = subscription.Member_URN INNER JOIN company ON company.Company_URN = subscription.Company_URN >From

RE: Logging on through ODBC w/o UN & Password (Why is my query t ool allowing this?)

2004-07-23 Thread SGreen
Your default anonymous account is still active. The Fine Manual describes how to fix this: http://dev.mysql.com/doc/mysql/en/Default_privileges.html Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Victor Pendleton <[EMAIL PROTECTED]> wrote on 07/23/2004 03:01:56 PM:

Re: mysql grant privileges to many DB

2004-07-23 Thread SGreen
Have you tried: GRANT USAGE on mysql.* TO ... (fill in with your user's information). >From the docs (http://dev.mysql.com/doc/mysql/en/GRANT.html) USAGE = Synonym for ``no privileges'' Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Ginger Cheng <[EMAIL PROTECTED]>

RE: Logging on through ODBC w/o UN & Password (Why is my query t ool allowing this?)

2004-07-23 Thread Victor Pendleton
Is the ODBC account still enabled on the database server? -Original Message- From: john sayre To: [EMAIL PROTECTED] Sent: 7/23/04 1:38 PM Subject: Logging on through ODBC w/o UN & Password (Why is my query tool allowing this?) I am able to log onto a database through ODBC without using a

mysql grant privileges to many DB

2004-07-23 Thread Ginger Cheng
Hello, MySQL gurus, I am wondering how I can grant a user the privileges to all the db except for mysql DB. THere are many databases so I don't want to grant one by one. But 'revoke all on mysql.* from user' does not work. Thank you for help ginger -- MySQL General Mailing List For list archiv

Re: Consolidating Data

2004-07-23 Thread SGreen
You could consider another option: To have a robust script (daemon?) in each web server that periodically pushes metrics data into the master. I think this gives you better control over your data. If you lose connection or something goes wrong your web servers will be able to tell what DIDN'T m

Logging on through ODBC w/o UN & Password (Why is my query tool allowing this?)

2004-07-23 Thread john sayre
I am able to log onto a database through ODBC without using a user name or password. I don't want this to be possible for obvious security reasons. What do I need to do to prevent this? This seems pretty freaky!

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread SGreen
I will be more than happy to help you build a case-specific crosstab report. I have almost enough information. Could you post a 3 column-query that will actually produce from your data the information you would like to have reformatted? Column one needs to be your column names, column two nee

Consolidating Data

2004-07-23 Thread Marc Knoop
Greetings! I have several (~12) web servers which all record web metrics to their own local mysql database. I would like to consolidate data from each web server database to one master DB to within the hour. I wish to avoid running multiple instances of mysql on the "master" server, so repli

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
Hi Shawn Yes, that's pretty much it. I'm impressed that you managed to work that out from my previous email which was a bit thin on detail! > Good news: For a specific case (when you know the number of columns) the > query you seek to write follows a simple and predictable pattern and is > not h

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
Hi David Thanks your response. I'm using Lasso but that's largely unimportant because I still need to get the data returned in a way that I can use it. I should not have said "displaying" - I meant "returning". I need to return only one column from table A (there could be up to 14 records). I nee

Locking in MyISAM

2004-07-23 Thread Michael Sleman
Does MyISAM lock the whole table when doing SELECTs? How about if there are several processors? Is there locking?

Re:

2004-07-23 Thread SGreen
If I understand you correctly Basically you want to convert this query output: +---+---+---+ |A.value|B.value|C.value| +---+---+---+ | a1 | b1 | c1 | | a1 | b1 | c2 | | a2 | b1 | c3 | | a2 | b1 | c4 | | a1 | b2 | c5 | | a1 |

MySQL user passwords and ColdFusion MX6.1

2004-07-23 Thread Terry Riley
Helpful Hint: I had a major problem not being able to register a DSN (Data Source Name) with the CF Administrator, using username and password from a MySQL 4.1.3 beta user table. After much hair-pulling, I discovered that CF cannot apparently handle the new 41-character format of the passwords

Re: Sum two column selects and put results in a different column

2004-07-23 Thread Rob Best
Thanks! that worked great! I ended up using the first one, I just liked the look of it better. Because the customer might not have any deposit records or any purchases I changed the code to this: SELECT @purchases := SUM(amount_of_credit_used) FROM purchases WHERE customer_id="jdoe";

mysql@lists.mysql.com

2004-07-23 Thread Aeon McNulty
Hi, I hope someone on the list can help me. Is there an easy and straightforward way way of displaying the data from three tables in a spreadsheet like format using MySQL 4.0? Table A has the column headings Table B has the row headings Table C is a line items file than cross relates the two Man

Re: IMPORTING

2004-07-23 Thread gerald_clark
You don't say what version you are running. Did you forget to commit? [EMAIL PROTECTED] wrote: Dear friends, When I import records fron csv file.I window pops up, stating total number of records imported, however when I check table nothing has been imported.Any guidance, -- MySQL General Mai

Re: IMPORTING

2004-07-23 Thread Robert J Taylor
On Friday 23 July 2004 11:14 am, [EMAIL PROTECTED] wrote: > Dear friends, > When I import records fron csv file.I window pops up, stating total number > of records imported, however when I check table nothing has been > imported. You are using some kind of middle-man program to populate a databas

IMPORTING

2004-07-23 Thread Remember14a
Dear friends, When I import records fron csv file.I window pops up, stating total number of records imported, however when I check table nothing has been imported.Any guidance,

connect to an embedded database

2004-07-23 Thread Adrien Saladin
Hello, I made a small c++ program which uses the mysql embedded server. I would like to manually connect to the local database for faster debugging. Is it possible ? Thanks. Adrien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

MySQL 4.1 cluster, help with BUILD/compile-pentium-max

2004-07-23 Thread crandler
Hello, the following problem occurs when I want to configure MySQL 4.1: Building aclocal.m4 Running autoheader to build config.hin Running autoconf to build configure 645046 644916 Building RPC client/server files Building tags +++ cd innobase +++ aclocal +++ autoheader +++ aclocal +++ automake +

RE: spatial data in MySQL

2004-07-23 Thread Wilder Castelo
Hi all! Estaba trabajando con el ArcView by ESRI, con una extension "MySQL Connection" http://arcscripts.esri.com/details.asp?dbid=12896 l) permitiendo poder exportar un Shapefile (Archivo Vectorial) a MySQL generandome el siguiente Peru.sql(que con gusto enviaria al correo que me preste su ayu

Re: can not start mysql daemon

2004-07-23 Thread Aman Raheja
# perror 2 Error code 2: No such file or directory You sure that directory exists? On Tue, 2004-07-20 at 15:48, [EMAIL PROTECTED] wrote: > >Description: > I can not start the mysqld daemon. I had it running for a long time, but > then had to reboot. Then I could no longer connect.

Re: grants for non-root

2004-07-23 Thread Aman Raheja
I have MySQL 4.0.18-standard on RH 9 and it works fine + mysql> grant all on *.* to 'mysqladmin'@'localhost'; Query OK, 0 rows affected (0.06 sec) mysql> show grants for 'mysqladmin'@'localhost'; +-+ | Grants

RE: spatial data in MySQL

2004-07-23 Thread Wilder Castelo
Solo hablo espaƃol. (Que Problema) Estoy tratando de hacer lo mismo que tu. ya ingrese la parte grafica a MySQL. Ahora estoy tratando de Visualizarala por un browser. Sorry, I don't write English clearly. I speak Spanish (That is Problem) I am trying to do just like your. The map already enters to

grants for non-root

2004-07-23 Thread Wolfgang Riedel
I try to set *all* privileges to a user, which should not called 'root' but should have its privileges (I'm connected as root): mysql> grant all on *.* to 'mysqladmin'@'localhost'; Query OK, 0 rows affected (0.00 sec) But now I get mysql> show grants for 'mysqladmin'@'localhost'; ERROR 1141: Ther

Re: How do I import a .dmp file?

2004-07-23 Thread Martin Gainty
There is an easier path- you *could buy* a data migration tool such as ispirer http://www.ispirer.com/products HTH, Martin Gainty (cell) 617-852-7822 From: matt ryan <[EMAIL PROTECTED]> To: Martin Gainty <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: How do I import a

Re: Innodb assertion failure after binary backup-restore

2004-07-23 Thread Sp.Raja
In some cases mysql crashes while restore is trying to destroy persistent databases and mysql.err says 000121 21:02:23 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 867418 In

Re: Is there any Performance Improvement / Tuning Software for MySQL?

2004-07-23 Thread Brent Baisley
Your settings need to be based upon usage patterns. Some systems have lots of inserts, others are mostly selects, some have lots of joins, others don't. All these would have different settings. There are even cases where you would want a table to be InnoDB instead of ISAM or the other way aroun

spatial data in MySQL

2004-07-23 Thread Lawrence Strydom
Hi List, I have been looking for solutions to my problem for a while and this morning someone told me that MySQL 5.1 might be the answer. In short what I need is an interactive map displayed in a web browser. Users should be able to click on any point in the map and add text. The map and the

Innodb assertion failure after binary backup-restore

2004-07-23 Thread Sp.Raja
Hi List, We are using 4.0.15a MySQL. We need to backup database at times and we employ the following method FLUSH TABLES WITH READ LOCK tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1 UNLOCK TABLES and restore is reverse. We cannot overwrite all databases, some of them needs to be uncha

Re: Sum two column selects and put results in a different column

2004-07-23 Thread SGreen
I know there are more ways to solve this problem (I can think of at least 2 more) but I think the easiest approach is to break this into two stages. First stage, we compute the sums of the purchases and the credits: SELECT @purchases := SUM(amount_of_credit_used) FROM purchases WHERE customer_id

Re: Last insert id problem/bug

2004-07-23 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Scott Haneda <[EMAIL PROTECTED]> writes: > I am not sure this is just how it is, my issue, or a bug, I searched the > bugs database, but don't really know what to call this in order to properly > look up the info: > MySQL 4.0.18-standard > CREATE TABLE `addresses`

MySQL is not starting

2004-07-23 Thread Sandro Dadaczynski
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: MySQL is not starting >Description: my mysqlserver is

Re: About backup/restore solution

2004-07-23 Thread Egor Egorov
"Matsunobu, Yoshinori" <[EMAIL PROTECTED]> wrote: > I'd like to ask about backup/restore(roll forward recovery) solutions > using mysqldump and binary logs. > > ^[$B!&^[(JVersion : 4.0.20 > ^[$B!&^[(JUsing 1 database.(ex. sample1db) > ^[$B!&^[(JAll tables are InnoDB. > > > I'm considering the

Sum two column selects and put results in a different column

2004-07-23 Thread Rob Best
I hope this isn't a stupid question but this is my best place to ask... I have a database where I need to do a sum of a returned select... SELECT SUM(purchases.amount_of_credit_used) WHERE customer_id="jdoe"; and do a sum of another returned select... SELECT SUM(amount) from deposits WHERE customer

Re: RAM-usage and hardware upgrade >10gb RAM

2004-07-23 Thread Jan Kirchhoff
David Griffiths wrote: We just put a new dual-Opteron server into our production environment. We ordered a Megaraid SCSI card and five 10k drives, and a 3Ware Escalade SATA card with six 7200 RPM drives (Maxtor) to see which ones were best. Our network guy did a bunch of benchmarking on the dri

problems transferring database

2004-07-23 Thread james patrick
I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL 4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin and MySQL 4.0.17. I have a large database (200mb) and I'm trying to move it over. I made a dump using "mysqldump -u USER -pPASSWORD DATABASE > filename.sql", tra

Optimizing my scenario, suggestions needed

2004-07-23 Thread Scott Haneda
There are three tables: This stores just a cosmetic name and a user_id which is used to find all the account holders campaigns... CREATE TABLE `campaigns` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `campaign_name` varchar(24) NOT NULL default '', `updat

Is there any Performance Improvement / Tuning Software for MySQL?

2004-07-23 Thread Terence
Is there any kind of performance / tuning guide software for MySQL? I am looking for something which can look at the SHOW VARIABLES and SHOW STATUS commands, do some calculations and give some tips on how to improve the system? Any such product available? -- MySQL General Mailing List For list a

Re: Best Use of FULLTEXT and/or LIKE?

2004-07-23 Thread Raj Shekhar
MySQL wrote: I want searches for News to be on the author, headline and content fields. What is the best way to index and search this? I would suggest a Fulltext index on headline and content. And then do a search using MATCH() and AGAINST(). For searching on author's names you can use LIKE . Fr