Re: join from two different databases
-Ursprüngliche Nachricht- Von: c.smart <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Datum: 18 March, 2001 01:11 Betreff: Re: join from two different databases >Sorry, No Green Beer, No can do that ;-) > >Richard Reina wrote: > >> I am try to do a join with tables that are in two different databases. >> >> I thing I've got the actual SQL syntax down: >> >> my $q = "SELECT i.inv_no, i.inv_date, >> c.cust_name >> FROM receivables.invoice i, sales.customer c, >> WHERE i.paid_date IS NULL"; >> >> but I am confused on how to prepare and execute it, since my database >> handle ($dbh) specifies only 1 database. >> >> Any help would get me out of the office on St. Pats day and in fron tof >> a bar maid serving green beer. Please help make my day. >> I've done this so far in perl, but with no execution plan. Basically it joins only two tables from different hosts, according to a key you must explicitly specify. Also I programmed a complete "order by" and limit (which wasn't very difficult). I cannot release this peace of sh..., but it works for my environment :-) Probably such functionality will be built in mysql in the future. At least Informix and Oracle support "remote-joins" I think... something like this: select * from user:pass@host:db.table1, table2, user:pass@host:db-table3 where ... --Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Benchmarking innobase tables
Hello Heikki, Monday, March 19, 2001, 4:40:30 PM, you wrote: >>Also the problem with innobase_flush_log_at_trx_commit=0 should be >>there is no guarantie the last transaction commited will be on it's >>place if the power would be lost. Also I don't know is it possible in >>this case for database to be corrupted as some transactions may modify >>database but are not in a logfile (Let's ask Heikki about this). HT> The database does not get corrupted even if you use HT> innobase_flush_logs_at_trx_commit=0 and it crashes: Innobase always writes HT> the appropriate log segment to disk before writing a modified database HT> page to disk. In this sense the log on disk is always 'ahead' of the disk HT> image of the database. But, of course, you may lose the updates of the HT> latest transactions in a crash, if the database has not yet written the HT> relevant log segment to disk. OK. The only question is is in this case only last transactions may be lost, and what the transaction can be only be lost completely ? I'm speaking about the situation - if I have connection there I have 1,2,3,4 transactions as a sequince - may it happen what changes made by transaction 4 take place while while by transaction 3 not ? -- Best regards, Petermailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alteon + forks
-Ursprüngliche Nachricht- Von: Pedro <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Datum: 19 March, 2001 17:29 Betreff: Alteon + forks >Hi, > > I have 2 servers and 1 alteon in HA. But the problem is that the alteon , >when trying, to see if the servers are up or down , makes mysql to fork , >till it dies.. >The connection port we are using is 3306 . >Does anyone have any idea? >Thanks in advance Hmm, I don't have an alteon here, but I'm using BigIP from F5, which is similar to alteon products (only better, but that's my opinion :-) My loadbalancer checks also my mysql-dbms's. In particular he will do an tcp-connect to port 3306 and if he succeed, he will close the connection immediately. Probably your alteon isn't closing the connection properly or checks the machines too frequently. So I don't think that your problem is related to mysql. --Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ARCHIVING UNDER HEAVY LOAD
On Mon, Mar 19, 2001 at 04:06:29PM +0300, Anatoly Chubais wrote: > Hello! > > There's a need to design a system (something like online forum) that > will be storing huge amount of small messages in database. There > must be fast access only to messages for the last 3 days (guess this > means that main table with indexes on it must be kept small?), while > other messages can be stored in rarely accessed archive (different > table?). What's the best practice for implementing archiving in > MySQL? In Oracle there's an ability to "switch off" part of the > table and then move it to archive in background mode. What about > MySQL? > See my message to Nathan with: Message-ID: <[EMAIL PROTECTED]> and the related thread for the discussion of a similar topic. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Renaming and/or copying a database
copying tables between databases:
create table db2.table2 select * from db1.table1;
however, you'll loose meta data (indexes) on this table, so you'd have to
create them again.
second method:
use the explorer or a dos shell to rename any table or db as shown in the
\mysql\bin directory. From within the sql client the name of a db cannot be
changed afaik, but table names can. Read he docs on this issue ('alter
table' syntax).
regards,
rene
- Original Message -
From: "Marko Milutinovič" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 8:05 AM
Subject: Renaming and/or copying a database
> Hi!
>
> I'm running MySQL on Win NT 4. I'm trying to rename a database from my
> program, but I haven't found any inforamtion about this on the MySQL site.
> Can anybody help me?
>
> Can a database named 2001 be created? Can a database be copied to another
> one via SQL statements?
>
>
> regards,
> m@rko
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Join optimization problem
Hi, Given this table: create table occurrance ( word int unsigned not null, document_id int unsigned not null, offset mediumint unsigned not null, key index_word (word), key index_document_id (document_id), key index_offset (offset) ) TYPE=MyISAM ..the following query takes way too long time (~10 minutes with about 1 million rows): SELECT t0.document_id FROM occurance t0, occurance t1 WHERE t0.word=3649701880 and t1.word=1821517919 and t0.document_id=t1.document_id; There's 2185 rows with the word value 3649701880, and 645 rows with the word value 1821517919. It seems to me that the mysql server does the very expensive t0.document_id=t1.document_id join first, and only after that does the more restrictive constant value joins. EXPLAIN on the select query above: +---+--+--+---+ | table | type | possible_keys| key | +---+--+--+---+ | t1| ref | index_word,index_document_id | index_word| | t0| ref | index_word,index_document_id | index_document_id | +---+--+--+---+ (continued) -++--++ key_len | ref| rows | Extra | -++--++ 4 | const | 619 | where used | 4 | t1.document_id | 12 | where used | -++--++ I'm not sure I'm reading this correctly, but it seems to me that it uses the correct indices. Any clues to why this query is so slow? Is there some way I can force the join optimizer to do the both constant joins first, and *then* the t0.document_id=t1.document_id clause? (MySQL 3.23.32 on RH6.2) // Johan -- Johan Schönhttp://johan.schon.org Roxen Internet Software http://roxen.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Renaming and/or copying a database
Hi! I'm running MySQL on Win NT 4. I'm trying to rename a database from my program, but I haven't found any inforamtion about this on the MySQL site. Can anybody help me? Can a database named 2001 be created? Can a database be copied to another one via SQL statements? regards, m@rko - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Renaming a database
Hi! I'm running MySQL on Win NT 4. I'm trying to rename a database from my (Delphi) program, but I haven't found any inforamtion about this on the MySQL site. Can anybody help me? P.S.: Can a database named 2001 be created? regards, m@rko - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with Mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 19 May 2002, Luis wrote:
> #mysqladmin -u root -p password 'newpassword'
>
> or
>
> #mysqladmin -u root password 'newpassword'
>
> i got a error. but when i tried the 2 one it work. But in the manual it says to do
>the top one
>
> I'm a little bit lost. So if anyone could help me out,
If it works what your problem :) The other way is if you can get into
mysql, then login and use UPDATE user SET Password=password('xyz') where
User='root';
That should change the password or add one
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE6twEO/f1mUNueu/oRAqkNAJ4ljokMZ/mEG+Hpwb2pSGbLLtrS4gCgwQfj
7T8peKHNZXQIWhU+d8v3ta4=
=ZQIM
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: to MySQL serwer
Hello Fantik, Monday, March 19, 2001, 9:43:20 PM, you wrote: F> I have connet to server MySQL from delphi 5 F> please send mi driver(s) for delphi, or please tell mi how connect. Try our mySQLDAC: http://www.microolap.com/mysqldac.htm -- Best regards, Edward Smirnov microOLAP Technologies LLC mailto:[EMAIL PROTECTED] http://www.microolap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on redhat 7.0
dear sanjeev run on cmmd promt /etc/rc.d/init.d/mysqld restart you can now run mysql luck naveed - Original Message - From: Sanjeev Adhyapak <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 17, 2001 11:20 PM Subject: mysql on redhat 7.0 > Dear Sir, > > We have installed redhat 7.0 server on one machine and want to run mysql > server on that. The installation is default. After that only the root is > allowed to connect to the server and if login as different user i am > getting the error as error 111 connection refused. > > If anybody has started it then plese let me know. > > Waiting for the reply. > > Thank you, > sanjeev > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Alteon + forks
On Mon, Mar 19, 2001 at 04:13:25PM -, Pedro wrote: > > I have 2 servers and 1 alteon in HA. But the problem is that the > alteon , when trying, to see if the servers are up or down , makes > mysql to fork , till it dies.. I'm not sure I understand... Probably because I don't know what an aleton is. Can you provide a bit more detail? Thanks, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Traffic accounting
On Mon, Mar 19, 2001 at 05:06:28PM +0100, Gernot Hueber wrote: > > I want provide access to my MySQL Server to several customers. How > can I count IO traffic per user, and any user accesses (I don't want > a full log, only log ins)? There's not built in facility for doing that today. Are all the customers accessing the same data, or separate data? If separate, you could run a server for each (assuming there are few customers) and run them each on different TCP ports. Then you just need to measure traffic to/from those ports. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] SQL syntax qestion
On Mon, 19 Mar 2001, Curtis Maurand wrote: > Hi, > Just a quick quesiton, I have a table that contains difined as > > create table picks( >handle char(30) primary key, ><...> > total int unsigned); > > there is a user table that has a list of handles and other user info. handle is the >primary key. > > If I issue the command "select handle, sum(total) group by handle;" I get the >information that I'm looking for, however I'd like to sort it by the sum that I get. >Is there a way of accomplishing this? select handle, sum(total) as myorder from tb_foo group by handle order by myorder asc > > > Curtis > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [OT] SQL syntax qestion
Hi, Yes, in MySQL you can go select handle, sum(total) as t group by handle order by t; in ANSI (?) you can go select handle, sum(total) group by handle order by 2; 2 being the column number of the result. Regards Quentin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March 2001 4:28 p.m. To: MySQL List Subject: [OT] SQL syntax qestion Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, <...> total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle, sum(total) group by handle;" I get the information that I'm looking for, however I'd like to sort it by the sum that I get. Is there a way of accomplishing this? Curtis The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[OT] SQL syntax qestion
Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, <...> total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle, sum(total) group by handle;" I get the information that I'm looking for, however I'd like to sort it by the sum that I get. Is there a way of accomplishing this? Curtis
Invalid authorization specification
hello all. I'm new to mysql and to this list. Here's my problem. I am using mysql and jsp. From a jsp page I try to connect to the mysql server I get error " Invalid authorization specification: Access denied for user : javaworks@localhost (using password: NO) at org.git.mm.mysql.MysqlIO.init (MysqlIO.java : 278) at org.git.mm.mysql.Connection. (Connection.java :230) at org.git.mm.mysql.Mysql.Driver.connect (Driver.java : 126) at java.sql.DriverManager.getConnection (unknown source) I am using Mysql version 3.23.31 for windows , Tomcat and JDK 1.3.1 Why am I getting this error and what can I do to resolve the problem. Rohit. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.237 / Virus Database: 115 - Release Date: 07/03/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Serious LEFT JOIN bug in 3.23
> hist.id will never be NULL and 5 at the same time. Your clauses conflict > with each other. > You need to re-write your query. This is ture, except the query suceeds if there is records in 'hist' Even if it is not a bug it is at least inconsistent behaviour of MySQL > > "Michael Griffith" <[EMAIL PROTECTED]> wrote: > > EXPLAIN LEFT JOIN fails when joining on an empty table with constant in > WHERE clause > > CREATE TABLE idx ( > id mediumint, > KEY id (id), > ) TYPE=MyISAM > > CREATE TABLE hist ( > id mediumint, > link mediumint, > KEY id (id,link) > ) TYPE=MyISAM > > Table idx is populated with thousands or records. Consider the following > query: > > 1. SELECT idx.id FROM idx > 2. LEFT JOIN hist ON hist.link=idx.id AND hist.id=5 > 3. WHERE > 4. hist.id=5 AND > 5. hist.id IS NULL AND > 6. idx.id=2 > > The query works perfectly, buy ONLY if table 'hist' is populated. If table > 'hist' is empty then the query returns no results. This is easy to fix by > commenting out line #4. However by commenting out line 4 the optimizer > decides to use a temporary table which would slow it down. > > Here is the EXPLAIN output as shown above with empty 'hist' table: > "Impossible WHERE noticed after reading const tables" > > Here is the EXPLAIN output from above query when 'hist' has 1 record: > > | table | type | possible_keys | key | key_len | ref| rows | > Extra > +---+--+---+--+-++--+--- > > --+ > | idx | ref | id| id | 3 | const|3 | > where used ; Using index (using temp without ln #4) > | hist | ref | id| id | 6 | const,idx.id |2 | > where used; Using index; Not exists > +---+--+---+--+-++--+--- > > --+ > > It seems the optimizer is checking the constant in hist before it even > considers this is a LEFT JOIN. This is a problem on my Windows MySQL > 3.23.33. Based on the EXPLAIN output of a simpler query I do not believe > 3.22 does the same thing. > > > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Resolved {Was Re: Fire Your Magician}
Van wrote: > > Van wrote: > > > > This one's great: > > /usr/local/libexec/mysqld: ready for connections > > 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication > > started in log 'FIRST' at position 4 > > 010319 1:51:41 Error reading packet from server: Binlog has bad magic number, > > fire your magician (read_errno 0,server_errno=65535) > > 010319 1:51:41 Slave: Failed reading log event, reconnecting to retry, log > > 'FIRST' position 4 > > 010319 1:51:41 Slave: reconnected to master 'pima@scottsdale:3306',replication > > resumed in log 'FIRST' at position 4 > > 010319 1:51:41 Error reading packet from server: Binlog has bad magic number, > > fire your magician (read_errno 0,server_errno=65535) > > > > Any thoughts would, obviously, be quite useful? > > > > BTW: The magician is me. So, how do I pink-slip myself? >:) > > > > Best Regards, > > Van > Again: > 010319 1:31:38 Aborted connection 13 to db: 'btime' user: 'vanboers' host: > `localhost' (Got an error reading communication packets) > 010319 1:59:44 Aborted connection 9 to db: 'adams' user: 'jobseek' host: > `localhost' (Got an error reading communication packets) > 010319 2:00:26 Aborted connection 87 to db: 'btime' user: 'vanboers' host: > `localhost' (Got an error reading communication packets) > 010319 2:01:27 Aborted connection 5 to db: 'btime' user: 'vanboers' host: > `localhost' (Got an error reading communication packets) > 010319 2:29:09 Aborted connection 71 to db: 'btime' user: 'vanboers' host: > `localhost' (Got an error reading communication packets) > 010319 2:29:36 Aborted connection 61 to db: 'adams' user: 'jobseek' host: > `localhost' (Got an error reading communication packets) > 010319 2:29:39 Aborted connection 120 to db: 'adams' user: 'jobseek' host: > `localhost' (Got an error reading communication packets) > 010319 2:36:23 Aborted connection 54 to db: 'btime' user: 'vanboers' host: > `localhost' (Got an error reading communication packets) > > The worst part? All data updates are going through. What the samhell's goin' > on? > > Van > The compiler that made this db was egcs-2.91. Upgraded to 2.95.2, and did the following: Master: mysqladmin shutdown rm /mysql/*-bin.log /mysql/-bin.index tar czvf /backup/mysql.tgz /mysql/ Slave: cd /mysql rm -Rf /mysql/* ncftp master cd /backup get mysql.tgz by cd / tar xzvf /mysql/mysql.tgz && rm /mysql/mysql.tgz rm /mysql/*.tgz /mysql/master*.* /mysql/master.index Master: /etc/rc.d/rc.mysql Slave: /etc/rc.d/rc.mysql *Note: In the above master refers to the master hostname except for the reference to master.index. They're replicating, now. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets
Steven Glogger wrote: > > after upgrading to 3.23.35 (from 3.22.32) i've got several times: > 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' > host: `localhost' (Got an error reading communication packets) > > it's running on a productive server, but it's not working correctly. > > some infos: apache 1.3.19, > Linux 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown, > PHP 4.0.5 RC1 > > any idea what it is? > > greetings > > steven > Steven: Check your compiler. I was getting this when compiling with egcs-2.91. Upgraded to 2.95.2 and all is happy, now. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: substring
I believe there is a function called Right(). Sample is as follows (pardon the VB): DIM sString, sLast4Characters sString = "Hello There" sLast4Characters = Right(sString, 4) So, sLast4Characters now equals "here". Hope this helps! --- Hammad Nasim <[EMAIL PROTECTED]> wrote: > Hi > I need some help with substring. How can I extract > last four digit of a > field say card_no (this field has in some instance > 10 digits and for some > value has 20 digits). > > Thanks > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
substring
Hi I need some help with substring. How can I extract last four digit of a field say card_no (this field has in some instance 10 digits and for some value has 20 digits). Thanks
Re: Split results
On Mon, 19 Mar 2001, Andres M.V. Paglayan wrote: > Hi you all, > I´m trying to resolve how to manage a large resultset (about 500), > showing only 20 rows per page and then to have the option to show more results from >several buttons, > like when you search something with a lot of pages in the yahoo, > Best wishes for you all. > Thanks in advance. select * from foo limit 20 -- wil show the first 20 rows select * from foo limit 20, 5 --will show the row 21 - 25; > > > > > > -- > Andrés Mariano Vazken Paglayan > [EMAIL PROTECTED] > -- > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Split results
You can use the 'limit' construct on the end of the select statement. So for first query do select blah from blah where blah limit 20; each succeeding query will be select blah from blah where blah limit 20,20; check the doco for explanation. You can do a count to start with to determine how many 'buttons' you require to get all results. hope this helps. len. -Original Message- From: Andres M.V. Paglayan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March 2001 12:47 To: MySQL Subject: Split results Hi you all, I´m trying to resolve how to manage a large resultset (about 500), showing only 20 rows per page and then to have the option to show more results from several buttons, like when you search something with a lot of pages in the yahoo, Best wishes for you all. Thanks in advance. -- Andrés Mariano Vazken Paglayan [EMAIL PROTECTED] --
Re: Split results
I think that this is highly dependant on the language you are using to display your results; you would probably get more help if you included that. Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] P: 703-566-3196 http://www.beridney.com - Original Message - From: "Andres M.V. Paglayan" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 8:46 PM Subject: Split results Hi you all, I´m trying to resolve how to manage a large resultset (about 500), showing only 20 rows per page and then to have the option to show more results from several buttons, like when you search something with a lot of pages in the yahoo, Best wishes for you all. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Split results
Hi you all, I´m trying to resolve how to manage a large resultset (about 500), showing only 20 rows per page and then to have the option to show more results from several buttons, like when you search something with a lot of pages in the yahoo, Best wishes for you all. Thanks in advance. -- Andrés Mariano Vazken Paglayan [EMAIL PROTECTED] --
members list categories & inserting db into webpage
I've got mysql and php installed on my server and i was wondering if anyone could give me some feedback/pointers on setting up a membership list for a local chamber of commerce. I've been able to set up the initial table (calling chamber.txt for the info, converted from a word.doc) but i need to break out business categories into linkable lists (hotels, restaurants, retail, etc.) and sort them alphabetically. I've been reading all kinds of reference material but not being a programmer it's alittle over my head... is there a simple way to call the chamber.db so it displays information in a web page? I already have categories broken out into a dropdown list (javascript i can figure out) that is presently calling static html pages, but i'm getting tired of having to add 2-3 businesses a week since i'm not getting paid for the site and i can give the director access to the chamber.txt file via ftp so she can do it. Any help would be really appreciated!!! Let me know if i need to provide more info... Thanks, Terry
Re: Serious LEFT JOIN bug in 3.23
hist.id will never be NULL and 5 at the same time. Your clauses conflict with each other. You need to re-write your query. "Michael Griffith" <[EMAIL PROTECTED]> wrote: EXPLAIN LEFT JOIN fails when joining on an empty table with constant in WHERE clause CREATE TABLE idx ( id mediumint, KEY id (id), ) TYPE=MyISAM CREATE TABLE hist ( id mediumint, link mediumint, KEY id (id,link) ) TYPE=MyISAM Table idx is populated with thousands or records. Consider the following query: 1. SELECT idx.id FROM idx 2. LEFT JOIN hist ON hist.link=idx.id AND hist.id=5 3. WHERE 4. hist.id=5 AND 5. hist.id IS NULL AND 6. idx.id=2 The query works perfectly, buy ONLY if table 'hist' is populated. If table 'hist' is empty then the query returns no results. This is easy to fix by commenting out line #4. However by commenting out line 4 the optimizer decides to use a temporary table which would slow it down. Here is the EXPLAIN output as shown above with empty 'hist' table: "Impossible WHERE noticed after reading const tables" Here is the EXPLAIN output from above query when 'hist' has 1 record: | table | type | possible_keys | key | key_len | ref| rows | Extra +---+--+---+--+-++--+--- --+ | idx | ref | id| id | 3 | const|3 | where used ; Using index (using temp without ln #4) | hist | ref | id| id | 6 | const,idx.id |2 | where used; Using index; Not exists +---+--+---+--+-++--+--- --+ It seems the optimizer is checking the constant in hist before it even considers this is a LEFT JOIN. This is a problem on my Windows MySQL 3.23.33. Based on the EXPLAIN output of a simpler query I do not believe 3.22 does the same thing. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Serious LEFT JOIN bug in 3.23
EXPLAIN LEFT JOIN fails when joining on an empty table with constant in WHERE clause CREATE TABLE idx ( id mediumint, KEY id (id), ) TYPE=MyISAM CREATE TABLE hist ( id mediumint, link mediumint, KEY id (id,link) ) TYPE=MyISAM Table idx is populated with thousands or records. Consider the following query: 1. SELECT idx.id FROM idx 2. LEFT JOIN hist ON hist.link=idx.id AND hist.id=5 3. WHERE 4. hist.id=5 AND 5. hist.id IS NULL AND 6. idx.id=2 The query works perfectly, buy ONLY if table 'hist' is populated. If table 'hist' is empty then the query returns no results. This is easy to fix by commenting out line #4. However by commenting out line 4 the optimizer decides to use a temporary table which would slow it down. Here is the EXPLAIN output as shown above with empty 'hist' table: "Impossible WHERE noticed after reading const tables" Here is the EXPLAIN output from above query when 'hist' has 1 record: | table | type | possible_keys | key | key_len | ref| rows | Extra +---+--+---+--+-++--+--- --+ | idx | ref | id| id | 3 | const|3 | where used ; Using index (using temp without ln #4) | hist | ref | id| id | 6 | const,idx.id |2 | where used; Using index; Not exists +---+--+---+--+-++--+--- --+ It seems the optimizer is checking the constant in hist before it even considers this is a LEFT JOIN. This is a problem on my Windows MySQL 3.23.33. Based on the EXPLAIN output of a simpler query I do not believe 3.22 does the same thing. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Re: problems with linking]
Dear MySQL Sirs (or Andrew Schmidt) Please see attachament for error messages. Thaks in advance for any help. Alonso Guarisma Original Message Subject: Re: problems with linking Date: Mon, 19 Mar 2001 19:02:47 -0500 From: Alonso Guarisma <[EMAIL PROTECTED]> To: Andrew Schmidt <[EMAIL PROTECTED]> CC: Keith Rambo <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <00cd01c0b0c5$151f69c0$[EMAIL PROTECTED]> Dear Andrew Schmidt, thanks for your quick response. Unfortunatelly, I still get the same error and your instructions seem not to work at all. Please tell me if I am doing something else wrong and refer to the attachment where I show what i did, regards Alonso Guarisma Andrew Schmidt wrote: > make sure you have -L/usr/local/mysql/lib/mysql/ in your compile > > and make sure that /usr/local/mysql/lib/mysql/ is in your shared object > cache. > > ldconfig -r will list your current cache entries. > if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add > the path: > > /sbin/ldconfig -m /usr/local/mysql/lib/mysql/ to add the directory to the > cache. > > regards, > > -- Andrew > > - Original Message - > From: "Alonso Guarisma" > To: > Cc: "Keith Rambo" > Sent: Monday, March 19, 2001 5:26 PM > Subject: problems with linking > > >> Dear MySQL Sirs, >> I have been trying to run a simple client program using the C API and >> unfortunatelly I am still getting the same error over and over again: >> ./client1: error in loading shared libraries: libmysqlclient.so.10: >> cannot open shared object file: No such file or directory >> >> Attached is the output of the libraries directory when I execute ls -l >> I cannot understand why the program does not find the library, I would >> really appreciate any help from you regarding this matter, because I >> already tried the options you provide in the MySQL manual (Section 20.3 >> Problems when linking the MySQL client library). >> >> I also think the problems related to this library is causing me failures >> when I try to install the GUI for MySQL. >> >> I hope to hear from you as soon as possible, sincerely >> >> Alonso Guarisma >> > > > > > > >> alonso@linux:~ > ls -l /usr/local/mysql/lib/mysql/ >> total 972 >> -rw-r--r-- 1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a >> -rw-r--r-- 1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a >> -rw-r--r-- 1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a >> -rw-r--r-- 1 mysqladm mysqlgrp 230180 Feb 11 16:02 libmyisam.a >> -rw-r--r-- 1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a >> -rw-r--r-- 1 mysqladm mysqlgrp 182284 Feb 11 16:02 libmysqlclient.a >> -rwxr-xr-x 1 mysqladm mysqlgrp 721 Feb 11 16:02 libmysqlclient.la >> lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 > > libmysqlclient.so -> libmysqlclient.so.10.0.0 > >> lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 > > libmysqlclient.so.10 -> libmysqlclient.so.10.0.0 > >> -rwxr-xr-x 1 mysqladm mysqlgrp 134367 Feb 11 16:02 > > libmysqlclient.so.10.0.0 > >> -rw-r--r-- 1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a >> -rw-r--r-- 1 mysqladm mysqlgrp 190742 Feb 11 16:02 libmysys.a >> -rw-r--r-- 1 mysqladm mysqlgrp 102344 Feb 11 16:02 libnisam.a >> > > > > > > >> - >> Before posting, please check: >>http://www.mysql.com/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail >> To unsubscribe, e-mail > > > >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Dear MySQL Sirs or Andrew: Here I pasted the output of what I did, I still get the same error... alonso@linux:~ > gcc -c -I/usr/local/mysql/include/mysql client1.c alonso@linux:~ > gcc -o client1 client1.o -L/usr/local/mysql/lib/mysql -lmysqlclient ls -l client1 -rwxr-xr-x 1 alonso users 12118 Mar 19 18:36 client1 alonso@linux:~ > client1 client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory alonso@linux:~ > ldconfig -r ldconfig: option requires an argument -- r alonso@linux:~ > ldconfig -m /usr/local/mysql/lib/mysql/ ldconfig: invalid option -- m Try `ldconfig --help' or `ldconfig --usage' for more information. alonso@linux:~ > ldconfig -l /usr/local/mysql/lib/mysql/ ldconfig: Ignored file /usr/local/mysql/lib/mysql/ since it is not a regular file. Although the executable is created, I cannot run it because I obtain the same error (regarding the libmysqlclient.so.10) Thanks in advance for any other help regarding this matter. Alonso - Before posting, please check: http://www.
Re: Problem with Mysql
Hello all. I was wondering if someone could help me out with simple question i have . I just download MySQL-3.23.33-1.i386.rpm and installed it. now would this be the right way of setting up the msyql root password #mysqladmin -u root -p password 'newpassword' or #mysqladmin -u root password 'newpassword' I'm asking because when i installed the rpm , i did the top one it did not work i got a error. but when i tried the 2 one it work. But in the manual it says to do the top one I'm a little bit lost. So if anyone could help me out, Thank you Luis .-. /v\ // \\ /( )\ ^^-^^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking only for uniqueness
"Alexey V. Litvinov" wrote: > > Hello JCampell, > > Friday, December 22, 2000, 11:25:51 AM, you wrote: > > RTFM about SELECT and about DISTINCT option > > J> I want to know if it is possible to build a MySQL query which will only > J> return the unique values of a specific column. Ie if I had this table: > > J> id | name |date___ > J> 1 | Jon | 2001-01-03 > J> 2 | Bob | 2001-01-04 > J> 3 | Jon | 2001-01-05 > > J> Is there any SQL query that will only return 1 row for each value in the > J> name column, or would I have to do that in PHP? You will have to do that in PHP or use group by. Distinct will only return rows that are unique for all columns not just one as you wish.. If you want one day per unique user you will have to tell the database which row you want for Jon. RTFM on GROUP BY :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking only for uniqueness
Hello JCampell, Friday, December 22, 2000, 11:25:51 AM, you wrote: RTFM about SELECT and about DISTINCT option J> I want to know if it is possible to build a MySQL query which will only J> return the unique values of a specific column. Ie if I had this table: J> id | name |date___ J> 1 | Jon | 2001-01-03 J> 2 | Bob | 2001-01-04 J> 3 | Jon | 2001-01-05 J> Is there any SQL query that will only return 1 row for each value in the J> name column, or would I have to do that in PHP? -- Best regards, Alexeymailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems with linking
make sure you have -L/usr/local/mysql/lib/mysql/ in your compile and make sure that /usr/local/mysql/lib/mysql/ is in your shared object cache. ldconfig -r will list your current cache entries. if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add the path: /sbin/ldconfig -m /usr/local/mysql/lib/mysql/ to add the directory to the cache. regards, -- Andrew - Original Message - From: "Alonso Guarisma" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Keith Rambo" <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 5:26 PM Subject: problems with linking > Dear MySQL Sirs, > I have been trying to run a simple client program using the C API and > unfortunatelly I am still getting the same error over and over again: > ./client1: error in loading shared libraries: libmysqlclient.so.10: > cannot open shared object file: No such file or directory > > Attached is the output of the libraries directory when I execute ls -l > I cannot understand why the program does not find the library, I would > really appreciate any help from you regarding this matter, because I > already tried the options you provide in the MySQL manual (Section 20.3 > Problems when linking the MySQL client library). > > I also think the problems related to this library is causing me failures > when I try to install the GUI for MySQL. > > I hope to hear from you as soon as possible, sincerely > > Alonso Guarisma > > alonso@linux:~ > ls -l /usr/local/mysql/lib/mysql/ > total 972 > -rw-r--r-- 1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a > -rw-r--r-- 1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a > -rw-r--r-- 1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a > -rw-r--r-- 1 mysqladm mysqlgrp 230180 Feb 11 16:02 libmyisam.a > -rw-r--r-- 1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a > -rw-r--r-- 1 mysqladm mysqlgrp 182284 Feb 11 16:02 libmysqlclient.a > -rwxr-xr-x 1 mysqladm mysqlgrp 721 Feb 11 16:02 libmysqlclient.la > lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so -> libmysqlclient.so.10.0.0 > lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0 > -rwxr-xr-x 1 mysqladm mysqlgrp 134367 Feb 11 16:02 libmysqlclient.so.10.0.0 > -rw-r--r-- 1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a > -rw-r--r-- 1 mysqladm mysqlgrp 190742 Feb 11 16:02 libmysys.a > -rw-r--r-- 1 mysqladm mysqlgrp 102344 Feb 11 16:02 libnisam.a > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build Search Query - STUMPED!!
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people submit local business they've used and
submit them. Then other people that visit the website can do a search for these
business.
The search criteria is either they enter a 1)city or 2)state or 3)zipcode and
must select a category. Only 1 of the 3 can be used along with the category, not
all 3
Lets say I am going to do a search. I have select a State(CA) and selected a
category: COI (Computer>Internet) and enter the keywords: "Web Hosting"
Now it will search for all states(CA) matching the COI(Computer>Internet)
category and ALL CO base categories(CO is the base category of all the CO.. sub
categories) with match against the keywords "Web Hosting". So if my business is
listed under the COP(Computer>Programming) category, my company would be
included in the search results(if we have the correct keywords in the bus_search
table) as we are in the base category CO
Now If I do a search and select a state(CA) and category COI (Computer>Internet)
with NO keywords, it will search all states that are in the COI category only,
no problem there. The problem I'm having is building the search query, when
keywords are present. The test query below doesn't produce the results we're
looking for. I was hoping, some one would take a moment or two, review the
attached table/insert data and can suggest a query that will produce the results
needed with keywords.
Test Query:
SELECT bi.bus_name,CONCAT(bi.contact_fname," ",bi.contact_lname) AS Name
FROM bus_info bi,bus_search bs
WHERE (MATCH bs.keywords AGAINST ("Web Hosting")
OR bs.cat_prefix = 'CO')
AND bl.state = 'CA'
AND bs.bus_id = bi.info_id
AND bl.loc_id = bi.info_id
GROUP by bi.bus_name ASC
I truly appreciate any assistance anyone maybe to offer! I need to get this done
before the end of the week! :)
TIA.
Mike(mickalo)Blezien
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with linking
Dear MySQL Sirs, I have been trying to run a simple client program using the C API and unfortunatelly I am still getting the same error over and over again: ./client1: error in loading shared libraries: libmysqlclient.so.10: cannot open shared object file: No such file or directory Attached is the output of the libraries directory when I execute ls -l I cannot understand why the program does not find the library, I would really appreciate any help from you regarding this matter, because I already tried the options you provide in the MySQL manual (Section 20.3 Problems when linking the MySQL client library). I also think the problems related to this library is causing me failures when I try to install the GUI for MySQL. I hope to hear from you as soon as possible, sincerely Alonso Guarisma alonso@linux:~ > ls -l /usr/local/mysql/lib/mysql/ total 972 -rw-r--r-- 1 mysqladm mysqlgrp11822 Feb 11 16:02 libdbug.a -rw-r--r-- 1 mysqladm mysqlgrp34846 Feb 11 16:02 libheap.a -rw-r--r-- 1 mysqladm mysqlgrp15246 Feb 11 16:02 libmerge.a -rw-r--r-- 1 mysqladm mysqlgrp 230180 Feb 11 16:02 libmyisam.a -rw-r--r-- 1 mysqladm mysqlgrp23312 Feb 11 16:02 libmyisammrg.a -rw-r--r-- 1 mysqladm mysqlgrp 182284 Feb 11 16:02 libmysqlclient.a -rwxr-xr-x 1 mysqladm mysqlgrp 721 Feb 11 16:02 libmysqlclient.la lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so -> libmysqlclient.so.10.0.0 lrwxrwxrwx 1 mysqladm root 24 Feb 11 16:02 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0 -rwxr-xr-x 1 mysqladm mysqlgrp 134367 Feb 11 16:02 libmysqlclient.so.10.0.0 -rw-r--r-- 1 mysqladm mysqlgrp31540 Feb 11 16:02 libmystrings.a -rw-r--r-- 1 mysqladm mysqlgrp 190742 Feb 11 16:02 libmysys.a -rw-r--r-- 1 mysqladm mysqlgrp 102344 Feb 11 16:02 libnisam.a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build Search Query - STUMPED!! - REFERRAL.SQL (0/1)
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people submit local business they've used and
submit them. Then other people that visit the website can do a search for these
business.
The search criteria is either they enter a 1)city or 2)state or 3)zipcode and
must select a category. Only 1 of the 3 can be used along with the category, not
all 3
Lets say I am going to do a search. I have select a State(CA) and selected a
category: COI (Computer>Internet) and enter the keywords: "Web Hosting"
Now it will search for all states(CA) matching the COI(Computer>Internet)
category and ALL CO base categories(CO is the base category of all the CO.. sub
categories) with match against the keywords "Web Hosting". So if my business is
listed under the COP(Computer>Programming) category, my company would be
included in the search results(if we have the correct keywords in the bus_search
table) as we are in the base category CO
Now If I do a search and select a state(CA) and category COI (Computer>Internet)
with NO keywords, it will search all states that are in the COI category only,
no problem there. The problem I'm having is building the search query, when
keywords are present. The test query below doesn't produce the results we're
looking for. I was hoping, some one would take a moment or two, review the
attached table/insert data and can suggest a query that will produce the results
needed with keywords.
Test Query:
SELECT bi.bus_name,CONCAT(bi.contact_fname," ",bi.contact_lname) AS Name
FROM bus_info bi,bus_search bs
WHERE (MATCH bs.keywords AGAINST ("Web Hosting")
OR bs.cat_prefix = 'CO')
AND bl.state = 'CA'
AND bs.bus_id = bi.info_id
AND bl.loc_id = bi.info_id
GROUP by bi.bus_name ASC
I truly appreciate any assistance anyone maybe to offer! I need to get this done
before the end of the week! :)
TIA.
Mike(mickalo)Blezien
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build Search Query - STUMPED!! - REFERRAL.SQL (1/1)
#
# Table structure for table 'bus_info'
#
CREATE TABLE bus_info (
info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment,
bus_name varchar(100) DEFAULT '' NOT NULL ,
contact_fname varchar(20) DEFAULT '' NOT NULL ,
contact_lname varchar(20) DEFAULT '' NOT NULL ,
refer_by int(8)) zerofill DEFAULT '' NOT NULL ,
searchwords varchar(100) DEFAULT '' NOT NULL ,
comments varchar(100) DEFAULT '' NOT NULL ,
hrs_open varchar(7) DEFAULT '85MF' NOT NULL ,
address varchar(40) DEFAULT '' NOT NULL ,
unique_url varchar(100),
phone varchar(20) DEFAULT '' NOT NULL ,
submit_date date DEFAULT '-00-00' NOT NULL ,
category varchar(6) DEFAULT '' NOT NULL ,
PRIMARY KEY (info_id),
KEY buidx_cat (category),
KEY buidx_ph (phone)
);
#
# Dumping data for table 'bus_info'
#
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('1','Thunder Rain Internet Publishing','Mike','Blezien','0001','Custom
Programming,Web Hosting,Database and Ecommerce','Thunder Rain provides custom \r\nCGI
programming. Specializing \r\nin Database and Ecommerce \r\nprogrammi','96SAT','34326
W.N. Sibley
Rd','http://www.referralsources.com/CO/mickalo.html','12256862002','2001-03-15','COI');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('2','Just Your Type','Pam','Gram','0002','Website Hosting,Domain Name
Registration,Website Design','This company delivers \r\nservices in a timely manner
\r\nand at reasonable prices.','85MF','9800 Topanga Canyon Blvd., Suite
D329','http://www.referralsources.com/CO/jyt.html','18183419155','2001-03-15','COI');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('3','RKC Inc.','Kris','Christoffel','0001','','RKC is an independant Mud
\r\nEngineering Consulting company \r\n. Profession Mud engineers \r\nthat can
h','Call','34326 W.N. Sibley Rd',NULL,'12256861946','2001-03-15','PRC');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('4','Dealersecrets, Inc.','Mitchell','Salloum','0002','Car Buying
Tips,Negotiating Car Prices,Secrets to the Best Car Deals','Dealersecrets offers a
great \r\nbook that literally saved me \r\nover a $1,000 when I bought \r\nmy new
c','96MF','4045 So. Buffalo Drive, Ste.
A101-140','http://www.referralsources.com/VE/dealersecrets.html','18887195888','2001-03-15','VEACO');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('5','Chatsworth Tire','','','0002','','','85SAT','7624 Winnetka
Avenue',NULL,'18189997280','2001-03-19','VEAT');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('6','Enterprise Import Service','Jerry','','0002','','They perform work on
Toyotas \r\nonly. Great service and \r\nprices!','85MF','21444 Ingomar
Street',NULL,'18189924788','2001-03-19','VEAREP');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('7','California Muffler','John','','0002','','','85MF','7624 Winnetka
Avenue',NULL,'18189997280','2001-03-19','VEAREP');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('8','Ace Blind Cleaning','Pete','Weaver','0002','','','85SAT','8341 DeSoto
Avenue',NULL,'18183413323','2001-03-19','HODOC');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('9','Emeril\'s Fish House','Emeril','Lagasse','0002','','This is a great
restaurant.','102','122234 Las Vegas Blvd.',NULL,'18005551212','2001-03-19','FORSE');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('10','Tudor Cottage','Diane','','0002','','Great gifts and WONDERFUL
\r\nservice!','105SAT','7424 Lionel',NULL,'18187907424','2001-03-19','SHGI');
INSERT INTO bus_info
(info_id,bus_name,contact_fname,contact_lname,refer_by,searchwords,comments,hrs_open,address,unique_url,phone,submit_date,category)
VALUES('11','Racing Fantasies Gifts and Collectibles','Pete','','0002','','Great
Nascar and NHRA \r\ncollectibles.','86SAT','8341 DeSoto
Avenue',NULL,'18187750337','2001-03-19','SHA');
INSERT INTO bus_info
(in
Re: Will MySQL_Linux_Apache handle Yahoo level traffic & data?
On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote: > I'm a newbie to the Linux-Apache+MySQL world. > > 1 - Will MySQL handle a data base as large as a Yahoo or Google or > E-Bay ? Done properly, yes. > 2 - Will MySQL running on a Linux/Apache system handle traffic that > approaches that of a Yahoo, Google or E-Bay? Same answer. > 3 - Does MySQL have an equilivant to "stored > proceedures? Not today, no. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: suggestions for implementing heavily used log tables with nightly delete
Unfortunately, the deletion criteria are based both on the host it's coming from, and the date of the records. If I start to break it up along too many lines, the management starts to outweight the benefits of it being in the database. Sounds like looking at innobase is definately a good way to go as well... I might give that a shot. -- Nathan > -Original Message- > From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 19, 2001 4:01 PM > To: Neulinger, Nathan R. > Cc: '[EMAIL PROTECTED]' > Subject: Re: suggestions for implementing heavily used log tables with > nightly delete > > > On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote: > > > > Got any suggestions on how these could be implemented? particular > > table types/setups/etc? > > > > I basically have a situation where 300,000+ rows are being inserted > > into a log table daily, and also needing to be cleared out based on > > a tstamp. What I've found is that the inserts work fantastic, but > > when I got to do the delete, even if it doesn't do anything, it sits > > there and blocks everything on the server for 20-30 minutes. > > > > Is this because of the lack of row-level locking on MyISAM tables? > > Yes. > > > Should I switch to a different table handler? > > Maybe. > > > Right now, I'm using multiple merge tables, split up to divvy up the > > space used. Certain log entries are getting kept longer than others > > due to the decreased volume those hosts generate. > > I was just about to suggest MERGE tables. If you create a table for > each interval (day, week, hour, whatever your requirements are) it may > improve things quite a bit. > > If splitting the tables based on time constraints isn't easily doable, > you might look at testing BDB or maybe Innobase tables (just added to > MySQL). > > The BDB tables have page-level locking, so you'll probably get some > relief there. And Innobase has row-level locking with a non-locking > consistent read, so it could be even better. But it's fairly new to > MySQL. The impression I have is that a lot of people are looking at > Innobase tables now and pushing them to see what they're capable > of. If you've got a bit of time to hack on it, that may help. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 328-7878Fax: (408) 530-5454 > Cell: (408) 439-9951 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: suggestions for implementing heavily used log tables with nightly delete
Ok. The second one below sounds semi reasonable - it does mean that the table will be somewhat useless for queries during the delete, but that's not tragic. Is there any way to drop all the indexes on a table with a single statement? Third one sounds good as well, but unfortunately, there is a steady stream of data being added to the table. I suppose if I were to dynamically be creating new tables all the table for the data, then it might be reasonable to do that, but that's probably more trouble than it's worth for this application. The percentage to be deleted will be anywhere from 3-5%. Jeremy also mentioned trying out innobase tables... I might give them a shot as well. -- Nathan > -Original Message- > From: Jens Vonderheide [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 19, 2001 3:49 PM > To: Neulinger, Nathan R.; [EMAIL PROTECTED] > Subject: AW: suggestions for implementing heavily used log tables with > nightly delete > > > > I basically have a situation where 300,000+ rows are being > inserted into a > > log table daily, and also needing to be cleared out based on a > > tstamp. What > > I've found is that the inserts work fantastic, but when I > got to do the > > delete, even if it doesn't do anything, it sits there and blocks > > everything > > on the server for 20-30 minutes. > > There was quite an interesting article on that subject in the > current issue > of a German computer magazine called "iX". > > The biggest problem with deletes seems to be updating the > indexes. This has > to be done (using the basic DELETE comamnd) for each deleted set. > > Basically, there are 3 ways to delete: > > 1) Simply "DELETE WHERE ...": Used with small operations > > 2) DELETE without indexes: This is done by first deleting the indexes, > giving the DELETE command and then recreating the indexes. It > is recommended > to use this way with tables holding more than 1 data > sets, when there > are more than 3% of all sets to be deleted. > > 3) MOVE-RENAME: First, all data sets that are not to be > deleted are copied > to a temporary table, then the original table is DROPped, and > finally the > temporary table is renamed to the original one's name. This method is > recommended under the following circumstances: > > Number of data sets | Percentage of sets to be deleted > >= 20 | >=80% > >= 40 | >=70% > >= 70 | >=60% > >= 100| >=50% > > HTH, Jens > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: suggestions for implementing heavily used log tables with nightly delete
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote: > > Got any suggestions on how these could be implemented? particular > table types/setups/etc? > > I basically have a situation where 300,000+ rows are being inserted > into a log table daily, and also needing to be cleared out based on > a tstamp. What I've found is that the inserts work fantastic, but > when I got to do the delete, even if it doesn't do anything, it sits > there and blocks everything on the server for 20-30 minutes. > > Is this because of the lack of row-level locking on MyISAM tables? Yes. > Should I switch to a different table handler? Maybe. > Right now, I'm using multiple merge tables, split up to divvy up the > space used. Certain log entries are getting kept longer than others > due to the decreased volume those hosts generate. I was just about to suggest MERGE tables. If you create a table for each interval (day, week, hour, whatever your requirements are) it may improve things quite a bit. If splitting the tables based on time constraints isn't easily doable, you might look at testing BDB or maybe Innobase tables (just added to MySQL). The BDB tables have page-level locking, so you'll probably get some relief there. And Innobase has row-level locking with a non-locking consistent read, so it could be even better. But it's fairly new to MySQL. The impression I have is that a lot of people are looking at Innobase tables now and pushing them to see what they're capable of. If you've got a bit of time to hack on it, that may help. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: suggestions for implementing heavily used log tables with nightly delete
> I basically have a situation where 300,000+ rows are being inserted into a > log table daily, and also needing to be cleared out based on a > tstamp. What > I've found is that the inserts work fantastic, but when I got to do the > delete, even if it doesn't do anything, it sits there and blocks > everything > on the server for 20-30 minutes. There was quite an interesting article on that subject in the current issue of a German computer magazine called "iX". The biggest problem with deletes seems to be updating the indexes. This has to be done (using the basic DELETE comamnd) for each deleted set. Basically, there are 3 ways to delete: 1) Simply "DELETE WHERE ...": Used with small operations 2) DELETE without indexes: This is done by first deleting the indexes, giving the DELETE command and then recreating the indexes. It is recommended to use this way with tables holding more than 1 data sets, when there are more than 3% of all sets to be deleted. 3) MOVE-RENAME: First, all data sets that are not to be deleted are copied to a temporary table, then the original table is DROPped, and finally the temporary table is renamed to the original one's name. This method is recommended under the following circumstances: Number of data sets | Percentage of sets to be deleted >= 20 | >=80% >= 40 | >=70% >= 70 | >=60% >= 100| >=50% HTH, Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HASH tables...
Am 22:21 19.03.2001 schrieb Dave Juntgen: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Hello, > I would like to ask those of you who have used temporary hash tables in >MySQL version 2.23.x if you have encountered any problems, concurs or known >issues. I have been testing it myself and everything sees to working just >fine. Please list your thoughts and comments on temporary hash tables. > >Thanks for your time, > --Dave J. >--- > Dave W. Juntgen [EMAIL PROTECTED] > Medical Informatics Engineering, Inc. http://www.mieweb.com/ > 4101 W. Jefferson Blvd. Phone: 219-459-6270 > Fort Wayne, IN 46804 Fax: 219-459-6271 > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php maybe OT: but i am using it for session storage for www application since 2 month, not temp tables. no problem so far. works quite stable and really fast. Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Order by using alias?
Yes, you are right, periods are not allowed, but I am still not getting a successfully ORDER BY on the field. I tried remove the DATE_FORMAT() function and everything worked fine. Am'I not allowed to alias function returns? - Original Message - From: "Gerald L. Clark" <[EMAIL PROTECTED]> To: "Dave Juntgen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 1:41 PM Subject: Re: Order by using alias? > Periods are not allowed in field names. > > Dave Juntgen wrote: > > > > Hello everyone, It seems as though I am unable to perform an order by with a > > DATETIME field when the column is named as an alias. For example... > > > > SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents > > ORDER by 'Serv. Date' DESC LIMIT 0,10; > > > > Can anyone give me an explanation? > > > > Thanks, > > --Dave J. > > --- > > Dave W. Juntgen [EMAIL PROTECTED] > > Medical Informatics Engineering, Inc. http://www.mieweb.com/ > > 4101 W. Jefferson Blvd. Phone: 219-459-6270 > > Fort Wayne, IN 46804 Fax: 219-459-6271 > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Versions
Can you put any warning that you plan to release new version few days before release ? I have downloaded 3.23.34, and when i visited mySQL.com on the next day, 3.23.35 was released. -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HASH tables...
Hello, I would like to ask those of you who have used temporary hash tables in MySQL version 2.23.x if you have encountered any problems, concurs or known issues. I have been testing it myself and everything sees to working just fine. Please list your thoughts and comments on temporary hash tables. Thanks for your time, --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Selecting random rows with MySQL 3.22?
You're selecting your index column [ID] for every record and generating a column containing a random number [ID*0+RAND()], ordering by the random column [ORDER BY rand], and then just grabbing the first record [LIMIT 1]. the RAND() function generates random numbers. In my version of mysql (most recent) this simpler query does the same thing: select ID, rand() as rand from partner order by rand limit 1 which is probably easier to understand, but YMMV. -ravi. -Original Message- From: Chris Boot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 3:53 PM To: MySQL Mailing List; Ravi Raman Subject: Re: Selecting random rows with MySQL 3.22? Hi, > for mysql < 3.23 you can do something like this. > > select ID, ID*0+rand() as rand from partner order by rand limit 1 Thanks a million for the speedy response! It works like a charm! I don't quite understand how it works though... Could anyone explain? I really don't like knowing something without knowing how it works. Best wishes, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
moving database between servers
I've created the databases on the new server, but when I do: mysqldump --quick --add-drop-table --add-locks --extended-insert --lock-tables TestDatabase | mysql -h newserver TestDatabase I get the error message: ERROR 1063 at line 30: Incorrect column specifier for column 'ID' The originating server is running MySQL 3.22.32 and the new one is running 3.23.32. Is that the problem? If so, how can I import the database to the new machine? Thanks in advance, Ethan Baldridge - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql error
I have suse linux 7.1, I installed mysql and php, I tyr to connect to the database and I get a socket error why? is there any kind of special confg? I type mysql on a terminal window and get the error msg, cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Selecting random rows with MySQL 3.22?
Hi, > for mysql < 3.23 you can do something like this. > > select ID, ID*0+rand() as rand from partner order by rand limit 1 Thanks a million for the speedy response! It works like a charm! I don't quite understand how it works though... Could anyone explain? I really don't like knowing something without knowing how it works. Best wishes, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Selecting random rows with MySQL 3.22?
It has been. Check the archives for 2-3 weeks ago. Cal http://www.calevans.com -Original Message- From: Chris Boot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:16 PM To: MySQL Mailing List Subject: Selecting random rows with MySQL 3.22? Hi, I'm sure this has been covered before, so I'm sorry for repeating the question. A search of the list archives yielded nothing. What I need to do is grab one random row from a table. What I would do in MySQL 3.23 is: SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1 How can I do this 3.22? Upgrading to 3.23 is not an option at the moment. Thanks in advance, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
suggestions for implementing heavily used log tables with nightly delete
Got any suggestions on how these could be implemented? particular table types/setups/etc? I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out based on a tstamp. What I've found is that the inserts work fantastic, but when I got to do the delete, even if it doesn't do anything, it sits there and blocks everything on the server for 20-30 minutes. Is this because of the lack of row-level locking on MyISAM tables? Should I switch to a different table handler? Right now, I'm using multiple merge tables, split up to divvy up the space used. Certain log entries are getting kept longer than others due to the decreased volume those hosts generate. -- Nathan Nathan Neulinger EMail: [EMAIL PROTECTED] University of Missouri - Rolla Phone: (573) 341-4841 Computing Services Fax: (573) 341-4216 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Selecting random rows with MySQL 3.22?
Hi. for mysql < 3.23 you can do something like this. select ID, ID*0+rand() as rand from partner order by rand limit 1 have fun. -ravi. -Original Message- From: Chris Boot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 3:16 PM To: MySQL Mailing List Subject: Selecting random rows with MySQL 3.22? Hi, I'm sure this has been covered before, so I'm sorry for repeating the question. A search of the list archives yielded nothing. What I need to do is grab one random row from a table. What I would do in MySQL 3.23 is: SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1 How can I do this 3.22? Upgrading to 3.23 is not an option at the moment. Thanks in advance, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: column types
Hi. If you want to store the binary images in the database, the column type will most likely be a BLOB assuming the images are not bigger that 60k. If you want to store just url or file paths (http://www.myhost.com/pict.jpg or /home/bob/image.gif) use a VARCHAR(XX) where XX is a reasonable length of what you think the longest link will be. 30? 50? Have fun. -ravi. -Original Message- From: Mike Baerwolf [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 4:02 PM To: [EMAIL PROTECTED] Subject: column types Hello, Just starting out with MySQL. I like to put images or links to images in a database, Is this possible? If so what would be the column type be? Thanks for the help Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting random rows with MySQL 3.22?
Hi, I'm sure this has been covered before, so I'm sorry for repeating the question. A search of the list archives yielded nothing. What I need to do is grab one random row from a table. What I would do in MySQL 3.23 is: SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1 How can I do this 3.22? Upgrading to 3.23 is not an option at the moment. Thanks in advance, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
column types
Hello, Just starting out with MySQL. I like to put images or links to images in a database, Is this possible? If so what would be the column type be? Thanks for the help Mike
Got an error reading communication packets
after upgrading to 3.23.35 (from 3.22.32) i've got several times: 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin' host: `localhost' (Got an error reading communication packets) it's running on a productive server, but it's not working correctly. some infos: apache 1.3.19, Linux 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown, PHP 4.0.5 RC1 any idea what it is? greetings steven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Do outer joins not work in MySQL?
Hi all, I'm new to MySQL and am puzzled by a curious problem. This join syntax has always worked fine for me on SQLServer but it seems to work like an inner join on MySQL: SELECT d.doccat_ID, d.doccatname FROM doccats d LEFT OUTER JOIN doccat_group dg ON d.doccat_ID = dg.doccat_ID WHERE dg.group_ID = (SomeValue) ORDER BY doccatname I've checked the documentation and cannot seem to find anything wrong with my syntax. Any thoughts? Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple charsets per server?
I need to do some tests for a client involving japanese text. I've recompiled the server with extra charsets = complex to have multi-byte support. I see how I can select the default charset upon startup. How can I tell mysql that a particular set of tables (or the whole DB) should use the japanese charset while leaving the other tables and DBs alone (using default Latin1)? Is this possible withour running multiple instances of mysqld? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Order by using alias?
Periods are not allowed in field names. Dave Juntgen wrote: > > Hello everyone, It seems as though I am unable to perform an order by with a > DATETIME field when the column is named as an alias. For example... > > SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents > ORDER by 'Serv. Date' DESC LIMIT 0,10; > > Can anyone give me an explanation? > > Thanks, > --Dave J. > --- > Dave W. Juntgen [EMAIL PROTECTED] > Medical Informatics Engineering, Inc. http://www.mieweb.com/ > 4101 W. Jefferson Blvd. Phone: 219-459-6270 > Fort Wayne, IN 46804 Fax: 219-459-6271 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
to MySQL serwer
Hello, Sorry, Im don't very good speak english. :( I have connet to server MySQL from delphi 5 please send mi driver(s) for delphi, or please tell mi how connect. Fantik [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query optimization
Hello On Sat, 17 Mar 2001, Bård Farstad wrote: > I have a query in my program which is taking to long when I get data > in the database. I'm currently testing with ~40.000 articles in the > system. [...] Is it possible to optimize this query further? Have you played with EXPLAIN SELECT and friends? See also some optimization tips in the chapter 12 of the manual. cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Order by using alias?
Hello everyone, It seems as though I am unable to perform an order by with a DATETIME field when the column is named as an alias. For example... SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents ORDER by 'Serv. Date' DESC LIMIT 0,10; Can anyone give me an explanation? Thanks, --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication or log-update
FYI Just noticed that statements like "LOAD DATA LOCAL INFILE 'testload.data' INTO TABLE testload ;" won't work via replication(3.23.33) or log-update(3.22.32) unless the data files are copied to remote slave servers in advance. Better implementation? Workarounds? Regards, Jerry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.35 failed to upgrade
Hi, I am trying to upgrade my MySQL server to 3.23.35 from 3.23.33. The following command is used. I got the following error messages. Any Ideas !! rpm -Fvh MySQL-client-3.23.35-1.i386.rpm MySQL-devel-3.23.35-1.i386.rpm MySQL-client-3.23.35-1.i386.rpm MySQL-client ## MySQL-devel ## MySQL-client ## package MySQL-client not listed in name index package Applications/Databases not listed in group index package msql2mysql not listed in file index package mysql not listed in file index package mysql_find_rows not listed in file index package mysqlaccess not listed in file index package mysqladmin not listed in file index package mysqlbinlog not listed in file index package mysqldump not listed in file index package mysqlimport not listed in file index package mysqlshow not listed in file index package isamchk.1.gz not listed in file index package isamlog.1.gz not listed in file index package mysql.1.gz not listed in file index package mysql_zap.1.gz not listed in file index package mysqlaccess.1.gz not listed in file index package mysqladmin.1.gz not listed in file index package mysqld.1.gz not listed in file index package mysqld_multi.1.gz not listed in file index package mysqldump.1.gz not listed in file index package mysqlshow.1.gz not listed in file index package perror.1.gz not listed in file index package replace.1.gz not listed in file index package safe_mysqld.1.gz not listed in file index Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: log-update bug
Actually I have 2.23.20-gamma and I get 'create dabase blabla' in my update log. cheers, thalis On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote: > Hi, > > Can you guys confirm that "create database" statements are not logged in > the log-update log? The version I am using is 3.22.32. > > > Regards, > > Jerry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: [BQ75]
ACABEI DE RECEBER. NÃO TEMOS NADA A PEDER. Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta para vocês porque recebi informação por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maiores empresas da Internet, para garantir ao Internet Explorer a posição de programa de navegação mais usado, estão testando uma versão beta do programa. Ao enviar esta carta aos seus amigos, ela será conferida pela MICROSOFT (é preciso que os seus amigos usem o Microsoft Windows) ao longo de duas semanas. A MICROSOFT pagará U$ 245 para cada pessoa a qual vocês enviarem esta carta. A MICROSOFT pagará à vocês U$ 243 para cada carta forwardada e pagará U$ 241 para cada terceira pessoa a qual vocês enviarem esta comunicação. Daqui a duas semanas a MICROSOFT entrará em contato com vocês via e-mail e lhes despachará o cheque. No início eu duvidei... até que depois de duas semanas recebi via e-mail a comunicação e, poucos dias a seguir, o cheque de U$ 24.800. Vocês devem enviar esta comunicação imediatamente, antes que termine o prazo do teste da versão beta da Internet Explorer. Quem banca tudo isso é o senhor Bill Gates. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
log-update bug
Hi, Can you guys confirm that "create database" statements are not logged in the log-update log? The version I am using is 3.22.32. Regards, Jerry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ROWNUM???
I have no problem doing this with server variables ... here is an example that I tried on the acc (account) table in our db ... SET @a:=0; SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc; This gives me the result that you are looking for ... Eric Peter Holm wrote: > Hi, > how do I get something like ROWNUM with mysql? > > This means, before every row in a result there would be the Number of > the row. I want a result that looks like this: > > No | xyz | abc | > --- > 1| xyz | abc | > 2| xyz | abc | > 3| xyz | abc | > . > . > . > 10| xyz | abc | > > I tried to use variables (@a++) for this, but this does not work. > Is there a way to do this (without a procedural language... I know it is > easy to do with perl or php, but I am using mysql commandline utility a > lot for formatting of results...) > > THANKS for answers! > > > > Have a nice thread, > Peter > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alteon + forks
Hi, I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes mysql to fork , till it dies.. The connection port we are using is 3306 . Does anyone have any idea? Thanks in advance Best Regards Pedro Jazztel Portugal - Servicos IP Edificio Diogo Cao - Doca de Alcantara 1350-352 Lisboa PORTUGAL Tel: +351 2 1030 1406 Fax: +351 2 1030 1300 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Traffic accounting
Hi! I want provide access to my MySQL Server to several customers. How can I count IO traffic per user, and any user accesses (I don't want a full log, only log ins)? Thanks -- Dipl.-Ing. Gernot Hueber Institut für Integrierte Schaltungen Freistädter Strasse 315/2 A-4040 Linz Tel: +43 732 2468-7122, Fax: -7126 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question/problem with MySQL 3.23 on Win98 and using MySQL-Maker
Hello, I am using MySQL for the first time and have it installed on a Windows98 machine. I also am running MySQL Maker by presult and a couple of other GUIs. Unfortunatley, it seems like any time I make a table that has fields which aren't varchar or integer, I can not insert any information in them. Datetime fields get no love and I have a project that I am prototyping. Does anyone know what the error could possibly be? Please email me back at this address. Thank you for your time and help in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reserved word in CREATE TABLE? source varchar(255),
Source is now a reserved word used to 'source' a text file full of SQL
commands
in the mysql client.
Johan Andersson wrote:
>
> Hi,
>
> I got the following error from mysql (client):
> ERROR at line 1: Failed to open file 'varchar(255),', error: 2
>
> The .sql file I were sending to stdin of mysql has the following content:
> CREATE TABLE IDENTITY (
> id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
> company_id bigint(20) unsigned DEFAULT '0' NOT NULL,
> contact_fname varchar(100),
> contact_lname varchar(100),
> contact_gender enum('M','Mme','Mlle'),
> contact_function varchar(100),
> contact_delivery_address text,
> contact_invoice text,
> reg_date timestamp(8),
> confirmed_date date,
> changed timestamp(14),
> changed_by varchar(20),
> source varchar(255),
> PRIMARY KEY (id),
> KEY IDENTITY_company_id (company_id)
> );
>
> .. and the only line that contains varchar(255) is:
> source varchar(255),
>
> And when I removed it from the file, everything did go ok..
> So is the word 'source' a reserved field name in myISAM tables or what?
>
> Just want to know what's going on.
>
> The server that was complaining about the line is of version 3.32.21-beta.
> The server that produced the .sql file (with mysqldump) is of version 3.22.32
>
> Regards,
> Johan
>
> - please send replies directly to me
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL/MyODBC/Access
I have a database that I am manipulating with Access through an MyODBC reference. All is well except for tables that contain any date/time fields. When I click the (standard) delete record button on forms that use these tables, I get prompted asking if I want to delete the form from my Access app rather than a simple deletion of the current record. Is this a known issue and is there a work around? Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: very strange but reproducable error in 3.23.35
This does not answer your problem, but 'timestamp' is a reserved word. Jan Legenhausen wrote: > > Hi, > > i just upgraded from 3.23.33 to 3.23.35 and found that a little script of > mine which simply modifys a table went mad completly. > I figured out a testcase which shows at least one of the strange things > which happen: > > Table definition and data: > > CREATE TABLE t_webmaster ( > lfdnr int(10) unsigned NOT NULL default '0', > ticket int(10) unsigned NOT NULL default '0', > client varchar(255) NOT NULL default '', > replyto varchar(255) NOT NULL default '', > subject varchar(100) NOT NULL default '', > timestamp int(10) unsigned NOT NULL default '0', > tstamp timestamp(14) NOT NULL, > status int(3) NOT NULL default '0', > type varchar(15) NOT NULL default '', > assignment int(10) unsigned NOT NULL default '0', > fupcount int(4) unsigned NOT NULL default '0', > parent int(10) unsigned NOT NULL default '0', > activity int(10) unsigned NOT NULL default '0', > priority tinyint(1) unsigned NOT NULL default '1', > cc varchar(255) NOT NULL default '', > bcc varchar(255) NOT NULL default '', > body text NOT NULL, > comment text, > header text, > PRIMARY KEY (lfdnr), > KEY k1 (timestamp), > KEY k2 (type), > KEY k3 (parent), > KEY k4 (assignment), > KEY ticket (ticket) > ) TYPE=MyISAM; > > INSERT INTO t_webmaster VALUES > (773,773,'','','',980257344,20010318180652,0,'Open',10,0,0,0,1,'','','','',' > '); > > Actions: > - modify "lfdnr": > mysql> alter table t_webmaster change lfdnr lfdnr int(10) unsigned default 0 > not null auto_increment; > Query OK, 1 row affected (0.01 sec) > > - modify data: > mysql> update t_webmaster set status=1 where type='Open'; > Query OK, 0 rows affected (0.01 sec) > (Wrong result!) > > - modify data 2nd time: > mysql> update t_webmaster set status=1 where type='Open'; > Query OK, 1 row affected (0.00 sec) > (Now it's done...) > > Looks like i've to downgrade... :-/ > > regards, Jan Legenhausen > > (some system info below) > > >Release: mysql-3.23.35 (Source distribution) > >Server: /usr/local/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for > pc-linux-gnu on i586 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 3.23.35 > Protocol version10 > Connection Localhost via UNIX socket > UNIX socket /tmp/mysql.sock > Uptime: 4 hours 15 min 18 sec > > Threads: 1 Questions: 9265 Slow queries: 0 Opens: 267 Flush tables: 1 > Open tables: 8 Queries per second avg: 0.605 > >Environment: > > System: Linux balin 2.2.18 #1 Fri Jan 19 22:10:35 GMT 2001 i586 unknown > Architecture: i586 > > Configure command: > ./configure --with-innobase --without-debug --without-docs > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql restarts at 100% CPU
You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: > > hi, >thanks for the interest. The error log just prints > an incomplete backtrace that is exactly the same after > every crash. I ran the incomplete backtrace through > resolve, and it showed me functions such as thread > start... etc... This is the backtrace that i've been > getting for all the crashes - > --- > Cannot determine thread, ebp=0xb24c, backtrace may > not be correct > stack range sanity check, ok, backtrace follows > 0x40077552 > 0x40076f0f > 0x80bdb6a > 0x80bdfdf > 0x80bd75d > 0x400f99cb > 0x80884b1 > New value of ebp failed sanity check terminating > backtrace > >We have been doing testing of our software and in > all the runs, with all the mysql servers, this problem > has been experienced. As soon as the server reaches > 100% CPU, the mysql server restarts. Without a single > exception till now. >The servers are RedHat Linux 6.2 with kernel 2.4.2, > PHP 4.0.4pl1, apache 1.3.14 and mysql 3.23.32. The > my.cnf file i'm using is this - > > [mysqld] > port= 3306 > socket = /tmp/mysql.sock > skip-locking > set-variable= key_buffer=640M > set-variable= max_allowed_packet=10M > set-variable= table_cache=640 > set-variable= sort_buffer=6M > set-variable= record_buffer=6M > set-variable= thread_cache=16 > set-variable= thread_concurrency=16 > set-variable= myisam_sort_buffer_size=64M > log-bin > server-id = 1 > set-variable= max_connections=2000 > set-variable= max_connect_errors=1 > set-variable= back_log=2900 > set-variable= connect_timeout=15 > set-variable= wait_timeout=57600 > set-variable= interactive_timeout=57600 > > Tx. > Vinod. > > --- "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote: > > On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p > > wrote: > > > > > > my mysql server restarts automatically when > > the > > > machine touches 100% CPU usage. any ideas why? > > > > What does the error log say? Anything? > > -- > > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > > Technical Yahoo - Yahoo Finance > > Desk: (408) 328-7878Fax: (408) 530-5454 > > Cell: (408) 439-9951 > > > Do You Yahoo!? > Get your free @yahoo.co.in address at http://mail.yahoo.co.in > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limit number input to certain values
I want to be able to add a number field to a table and limit the values that the user can enter. For example if it is an integer filed I may want the user to only enter the value from 1 to 10. Can I do this within the definition of the field/table or do I have to do this level of validity checking in whatever method I use to allow input (most likely PHP/HTML). Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reserved word in CREATE TABLE? source varchar(255),
Hi,
I got the following error from mysql (client):
ERROR at line 1: Failed to open file 'varchar(255),', error: 2
The .sql file I were sending to stdin of mysql has the following content:
CREATE TABLE IDENTITY (
id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
company_id bigint(20) unsigned DEFAULT '0' NOT NULL,
contact_fname varchar(100),
contact_lname varchar(100),
contact_gender enum('M','Mme','Mlle'),
contact_function varchar(100),
contact_delivery_address text,
contact_invoice text,
reg_date timestamp(8),
confirmed_date date,
changed timestamp(14),
changed_by varchar(20),
source varchar(255),
PRIMARY KEY (id),
KEY IDENTITY_company_id (company_id)
);
.. and the only line that contains varchar(255) is:
source varchar(255),
And when I removed it from the file, everything did go ok..
So is the word 'source' a reserved field name in myISAM tables or what?
Just want to know what's going on.
The server that was complaining about the line is of version 3.32.21-beta.
The server that produced the .sql file (with mysqldump) is of version 3.22.32
Regards,
Johan
- please send replies directly to me
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1109: Unknown table
Updates may reference only one table in MySQL. Phil Tardif wrote: > > here is what happens with my update command: > > update GGProfiles set GGProfiles.city = USzipcodes.city where > GGProfiles.zipcode = USzipcodes.zipcode; > ERROR 1109: Unknown table 'USzipcodes' in field list > > the USzipcodes table does exist and the name even filled in from a tab > after the U. it has the same owner and group as all of the other tables > in the database. > > i'm using mysql version 3.23 on a cobalt raq3i. > > anybody know what gives? > > thanxamundo > > phil > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: for configure
Install your curses from your installation CD.
Ali Muhhanmad wrote:
>
> Dear Mysql:
>
> when i execute the configure , it always display:
>
> checking for tgetent in -lncurses... no
> checking for tgetent in -lcurses... no
> checking for tgetent in -ltermcap... no
> checking for termcap functions library... configure:
> error: No curses/termcap library found
>
> and the last line in config.log is:
>
> We use char because int might match the return type
> of a gcc2
> builtin and then its argument prototype would
> still apply. */
> char tgetent();
>
> int main() {
> tgetent()
> ; return 0; }
> configure:8085: checking for tgetent in -ltermcap
> configure:8104: gcc -o conftest -O6 -DDBUG_OFF
> -rdynamic conftest.c -ltermca
> p -ldl -lcrypt -lnsl -lm -lpthread 1>&5
> ld: cannot open -ltermcap: No such file or directory
> configure: failed program was:
> #line 8093 "configure"
> #include "confdefs.h"
> /* Override any gcc2 internal prototype to avoid an
> error. */
> /* We use char because int might match the return type
> of a gcc2
> builtin and then its argument prototype would
> still apply. */
> char tgetent();
>
> int main() {
> tgetent()
> ; return 0; }
> configure:8132: checking for termcap functions library
> "config.log" line 676 of 676 --100%-- col 1
>
>please help me !!
>
> Ali. Mar 19,2001
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: strange ws_concat,concat result
"Nyström, Rasmus" writes:
> I tried it now.
>
> Not on the 2000 Server, but on my NT4 SP6
>
> The problem still occures, let's me describe the tests.
>
> The table looks like this:
> id| int(10) unsigned | | PRI | NULL| auto_increment
> title | varchar(255) | YES | | NULL|
> prio | int(10) unsigned | YES | | NULL|
> category | int(10) unsigned | YES | | NULL|
> program | int(10) unsigned | YES | | NULL|
> bugdesc | text | YES | | NULL|
> created | datetime | YES | | NULL|
> modified | timestamp(14)| YES | | NULL|
> bugstatus | int(10) unsigned | YES | | NULL|
> submitter | int(10) unsigned | YES | | NULL|
>
> nothing special about that I assume.
>
> There are a few strange things here.
>
> while the query as described
> SELECT
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
> ied,bugstatus,submitter), '"') FROM tbl_bug
>
> returns
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "5";"5";""
> "6";"6";""
> "3";"3";""
> "5";"5";""
> "5";"5";""
> "5";"5";""
> "5";"5";""
> "5";"5";""
>
> SELECT CONCAT('"',CONCAT_WS('";"',title,bugdesc), '"') FROM tbl_bug
>
> returns the correct values.
> to long to be presented here, but I think you understand what I want.
>
> so I does not fall on the TEXT field.
>
> next I try.
>
> SELECT
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter),
> '"') FROM tbl_bug
>
> and this annoyes the hell out of me. It returns
>
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "4";"4";""
> "Utloggen";"2";"1";"1";"0";"4"
> "Avbryt order";"2";"1";"1";"0";"4"
> "Tips";"1";"2";"1";"0";"4"
> "Bakgrundsfõrg";"1";"2";"1";"0";"5"
> "Fel pÕ PDF prislista";"3";"1";"1";"0";"6"
> "Bekrõfta orderrad";"2";"1";"1";"0";"3"
> "Tillbaka knapp";"1";"2";"1";"0";"5"
> "Tillbeh÷r";"1";"2";"1";"0";"5"
> "Ikoner";"1";"2";"1";"0";"5"
> "Leveransbesked";"1";"2";"1";"0";"5"
> "Kontantkort";"1";"2";"1";"0";"5"
>
> That is half right half way out there.
>
> I do not have any NULL values or anything
>
> The server is a NT4 Server SP6 On a pentium 133 running 2.23.35 (reporting
> '3.23.34a debug' =) )
>
> The first server I tried this on was a Win2k Server SP1 running 2.23.33
> which returned the same using the first query. haven't tried the other once
> there, but from what I gather I should return the same, shouldn't it.
>
> both server where tested using Win2k Professional running the queries
> through the mysql-client.
>
> PS.
> just tried the last query on the original server.
>
> It returns the same. Except for the last row returning almost the same as
> the first four.
>
>
> /Rasmus Nyström
>
Hi!
We need a reproducible test case.
Can you pack into gzipped tarball (or ZIP) your MyISAM table with the
above queries to :
ftp://support.mysql.com:/pub/mysql/Incoming
and let me know a filename.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API problem
You clibs are too old. You are probably running a very old
version of Linux.
john1 wrote:
>
> Dear Sir :
>
> MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
> a simple C API program which catched from MySQL tutorial, it
> chokes at the end of compile process . The program is as follows:
>
> #include
> #include
>
> #define def_host_name NULL
> #define def_user_name NULL
> #define def_password NULL
> #define def_db_name NULL
>
> MYSQL *conn;
> int main(int argc,char *argv[])
> {
> conn=mysql_init(NULL);
> mysql_real_connect(
> conn,
> def_host_name,
> def_user_name,
> def_password,
> def_db_name,
> 0, /*port defaut*/
> NULL, /*socket default*/
> 0);/*flag*/
> mysql_close(conn);
> exit(0);
> }
>
> I compile as follows:
>
> gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
>-L/home/MySQL/MySQL/lib \
> -lmysqlclient
>
> Then I get :
>
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x14):undefined reference to 'open64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> mf_format.o(.text+0x201):undefined reference to '__lxstat64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x21):undefined reference to 'fopen64'
>
> Nothing left to do with the situation, I beg your help. Anyway I'm a
> newcomer. Thank you very much.
>
> Please send message to [EMAIL PROTECTED]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Again: module shr.o
Hallo MySQLers I have posted this problem already, but i have still problems installing MySQL Version 3.23.33 on RS/6000 AIX4.3.3 >Description: exec(): 0509-036 Cannot load program ../bin/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive The problem is not to get zlib.xxx and install it as library libz.a. I have done it from several sources (included ftp.gnu.org), but the result is in all cases the same. Module shr.o in this library is missing (see above). The library libz.a itself is available. Where can i find a zlib library with this module? I have tried to install the source distribution with --disable-shared. tis fails, because i have no C++ compiler inatalled. best regards Schwaiger [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with MySQL & ASP
Hi Craig,
You can give the following a try which does give you direct access to MySQL
from ASP skipping the slower ODBC and is almost code compatible with your
code:
http://www.scibit.com/MySQLX
or
MyVBQL on the mysql API/contrib pages
Regards
Jacques
http://www.scibit.com
http://www.scibit.com/MySQL
http://www.scibit.com/Mascon
> -Original Message-
> From: Craig Atkins [mailto:[EMAIL PROTECTED]]
> Sent: 19 March 2001 15:39
> To: '[EMAIL PROTECTED]'
> Subject: Problem with MySQL & ASP
>
>
> Hi I am running the latest versions of MySQL and MyODBC on my windows
> 200 webserver.
>
> I am trying to connect to my database and pull out some simple data with
> asp.
>
> The code i am using is:
>
> <%
> dim db
> dim strConn
> dim rs
> dim QueryStr
>
> QueryStr = "SELECT * FROM imagedata"
> strConn = "mediaSafe"
>
>
>
> Set db = Server.CreateObject("ADODB.Connection")
> db.open strConn, "web", "media1"
> Set rs = Server.CreateObject("ADODB.Recordset")
>
> set rs=db.execute(QueryStr)
>
> if rs.eof then
> response.write "RS EOF!"
> else
> response.write "NOT RS EOF!"
> end if
> %>
>
> which works on my Access database, but it returns an empty recordset on
> MySQL.
>
> I have tried many different things, but cannot get the data out, yet if
> I use an ODBC query tool, i can!
>
> I really want to get this working!
>
> Thanks in advance,
>
> Craig
>
>
> *
> This e-mail and its contents are confidential and are for the
> use of the intended recipient only. If you are not the
> intended recipient, please notify the sender immediately.
> The opinions, statements and thoughts expressed in this
> email are only those of the individual sender.
> *
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Add password to a existing database/table
Read chapter 6 of the MySQL manual. It is explained there. Nyon wrote: > > Hi, > > I am a newbie in Mysql and is confused about setting login/passwords. Just > want a simple security measure as I am the only user. > > Here's the scenario: > I managed to connect using PHP to mysql via the mysql_connect without using > any > hostname/password. What do I change to impose this security measure. > The hostname and password will be keep in a *.inc file outside the web root > directory. > > Thanks > Nyon > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote connection protocol
You don't. You can use telnet to connect and run mysql on that machine, displaying on yours. You can use mysql on your machine to connect to mysqld on the remote machine using the -h option to mysql. This requires that the grant command has been run on the server to allow you to connect, and that port 3306 ( or whatever the server is running on ) is not blocked by a firewall. Robert Feldbauer wrote: > > I'm trying to use a remote telnet connection to access a mysql > server. Anyone know where I could find protocols to connect to > a mysql server, with telnet? Thanks. > > Bob Feldbauer > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Will MySQL_Linux_Apache handle Yahoo level traffic & data?
Welcome! 1: You'll have to be more specific than that. How many tables/records per table are you looking to store? Are you wanting to optimize it for querying or is it going to be an active database with heavy inserting/updating? 2: That depends on the hardware you run it on. Technically, yes, it can be done. Is it easy/cheap? No, but neither is anything else related to sites that size. 3: No. Cal http://www.calevans.com -Original Message- From: tmb [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 8:06 AM To: [EMAIL PROTECTED] Subject: Will MySQL_Linux_Apache handle Yahoo level traffic & data? I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? 3 - Does MySQL have an equilivant to "stored proceedures? Thanks - tmb __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: strange ws_concat,concat result
> "Nyström, Rasmus" writes:
> > How come the query
> >
> > SELECT
> >
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc
> ,created,modif
> > ied,bugstatus,submitter), '"') FROM tbl_bug;
> >
> > returns something like
> > "4","4","4"
> > "10","10","10"
> >
> > while only
> >
> > SELECT
> >
> CONCAT_WS(';',title,prio,category,program,bugdesc,created,modi
> fied,bugstatus
> > ,submitter) FROM tbl_bug;
> >
> > returns the intended result except that the values are not
> confined withing
> > '"'.
> > that is
> >
> > Tough Bug,1,3,4,A very long description
> >
> > I do understand why the second query returns what it
> returns, but the first
> > one should not return what it returns, right?
> >
> > Am I clear enough?
> >
> > I'm using 2.23.33 on Windows 2000 Server.
> >
> > / Rasmus Nyström
> >
>
>
> Hi!
>
> Please try our 3.23.35 for Windows and see if problem reccurs.
>
>
> Regards,
>
> Sinisa
I tried it now.
Not on the 2000 Server, but on my NT4 SP6
The problem still occures, let's me describe the tests.
The table looks like this:
id| int(10) unsigned | | PRI | NULL| auto_increment
title | varchar(255) | YES | | NULL|
prio | int(10) unsigned | YES | | NULL|
category | int(10) unsigned | YES | | NULL|
program | int(10) unsigned | YES | | NULL|
bugdesc | text | YES | | NULL|
created | datetime | YES | | NULL|
modified | timestamp(14)| YES | | NULL|
bugstatus | int(10) unsigned | YES | | NULL|
submitter | int(10) unsigned | YES | | NULL|
nothing special about that I assume.
There are a few strange things here.
while the query as described
SELECT
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
ied,bugstatus,submitter), '"') FROM tbl_bug
returns
"4";"4";""
"4";"4";""
"4";"4";""
"4";"4";""
"4";"4";""
"4";"4";""
"4";"4";""
"5";"5";""
"6";"6";""
"3";"3";""
"5";"5";""
"5";"5";""
"5";"5";""
"5";"5";""
"5";"5";""
SELECT CONCAT('"',CONCAT_WS('";"',title,bugdesc), '"') FROM tbl_bug
returns the correct values.
to long to be presented here, but I think you understand what I want.
so I does not fall on the TEXT field.
next I try.
SELECT
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter),
'"') FROM tbl_bug
and this annoyes the hell out of me. It returns
"4";"4";""
"4";"4";""
"4";"4";""
"4";"4";""
"Utloggen";"2";"1";"1";"0";"4"
"Avbryt order";"2";"1";"1";"0";"4"
"Tips";"1";"2";"1";"0";"4"
"Bakgrundsfõrg";"1";"2";"1";"0";"5"
"Fel pÕ PDF prislista";"3";"1";"1";"0";"6"
"Bekrõfta orderrad";"2";"1";"1";"0";"3"
"Tillbaka knapp";"1";"2";"1";"0";"5"
"Tillbeh÷r";"1";"2";"1";"0";"5"
"Ikoner";"1";"2";"1";"0";"5"
"Leveransbesked";"1";"2";"1";"0";"5"
"Kontantkort";"1";"2";"1";"0";"5"
That is half right half way out there.
I do not have any NULL values or anything
The server is a NT4 Server SP6 On a pentium 133 running 2.23.35 (reporting
'3.23.34a debug' =) )
The first server I tried this on was a Win2k Server SP1 running 2.23.33
which returned the same using the first query. haven't tried the other once
there, but from what I gather I should return the same, shouldn't it.
both server where tested using Win2k Professional running the queries
through the mysql-client.
PS.
just tried the last query on the original server.
It returns the same. Except for the last row returning almost the same as
the first four.
/Rasmus Nyström
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Will MySQL_Linux_Apache handle Yahoo level traffic & data?
I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? 3 - Does MySQL have an equilivant to "stored proceedures? Thanks - tmb __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error with mysql configuration.
Make sure all directories in the path to your mysql.sock file are world readable and searchable. Abid Ghufran wrote: > > Dear All, > > I am trying to setup a web based email setup on RedHat Linux 7 platform. I > am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms > required for the MySql setup: (I am running the entire setup on my single > host for test purposes) > > 1) mysqlclient9-3.23.22-3 > 2) php-mysql-4.0.3pl1-1 > 3) mysql-server-3.23.22-6 > 4) horde-mysql-1.2.4-1rh7 > 5) mysql-3.23.22-6 > > Although the required version was 3.23.24 for mysql and mysql-server, these > are not available at all the three ftp sites within my reach and mentioned > in the "horde-latest.README": (ftp.horde.org, ftp.sunsite.org.net and > ftp.sourceforge.net) > > Now the problem is as follows: > > 1) When i try to check the test.php3 i get the following status of the > installed modules (alongwith other information): > IMAP Support: Yes. > LDAP Support: No. > MySql Support: Yes. > PostgreSQL Support: No. > > (I have not yet configured LDAP and PostgreSQL.) > > But when i access "Click here to test PHPLIB for Horde" link i get this > warning: > > Warning: Cant connect to local MySql server through socket > '/var/lib/mysql/mysql.sock' (111) in /var/www/horde-phplib/db_mysql.inc on > line 73 > > I checked this code (at line 73) and found mysql_pconnect() thus i assume > (on the basis of my limited knowledge) that the problem might be with the > database server connection. > > The MySql server is running. File mysql.sock exists. The database for the > horde-phplib and imp is created. The command "mysql < mysql_create.sql" > runs. I have the entire setup on a single machine for test purposes (i.e. > MySql server, Apache Server and etc.). I have yet to run the cinfiguration > file "setup.php3" on the horde directory of my web site. > > When i run "mysqladmin version" in the output i get that the localhost is > connected via Unix sock, and when i run "mysqladmin -h `hostname` version > variables" i get that the localhost is connected via TCP/IP port. I think > that either the socket or the TCP/PI port should have been used, as given > with the mysql configuration. > > I have given all the details intentionally to give you an idea of the the > entire setup. > > All kind of thoughts are appreciated and anticipated. > > Thank you very much. > > Abid Ghufran. > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL & ASP
Hi I am running the latest versions of MySQL and MyODBC on my windows
200 webserver.
I am trying to connect to my database and pull out some simple data with
asp.
The code i am using is:
<%
dim db
dim strConn
dim rs
dim QueryStr
QueryStr = "SELECT * FROM imagedata"
strConn = "mediaSafe"
Set db = Server.CreateObject("ADODB.Connection")
db.open strConn, "web", "media1"
Set rs = Server.CreateObject("ADODB.Recordset")
set rs=db.execute(QueryStr)
if rs.eof then
response.write "RS EOF!"
else
response.write "NOT RS EOF!"
end if
%>
which works on my Access database, but it returns an empty recordset on
MySQL.
I have tried many different things, but cannot get the data out, yet if
I use an ODBC query tool, i can!
I really want to get this working!
Thanks in advance,
Craig
*
This e-mail and its contents are confidential and are for the
use of the intended recipient only. If you are not the
intended recipient, please notify the sender immediately.
The opinions, statements and thoughts expressed in this
email are only those of the individual sender.
*
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Benchmarking innobase tables
Hi Peter and Christian! >>If you are going to be committing on every record, you'll want your >>tablespace and logfile directories on separate disks to avoid >>thrashing. If you only have one disk and don't care if you lose the >>last few transactions if your system crashes, try setting >>innobase_flush_log_at_trx_commit=0 in my.cnf. CJ> Wow, thanks. With innobase_flush_log_at_trx_commit=0, the benchmark now shows: CJ> autocommit=0, rollback after each insert: 1587 inserts+rollbacks/sec CJ> autocommit=1: 2764 inserts/sec. CJ> That's even faster than myisam (2487 inserts/sec today)!!! >In this case you should compare it to myisam created with >delay_key_write=1, also the size of key_buffer matter. >Also the problem with innobase_flush_log_at_trx_commit=0 should be >there is no guarantie the last transaction commited will be on it's >place if the power would be lost. Also I don't know is it possible in >this case for database to be corrupted as some transactions may modify >database but are not in a logfile (Let's ask Heikki about this). The database does not get corrupted even if you use innobase_flush_logs_at_trx_commit=0 and it crashes: Innobase always writes the appropriate log segment to disk before writing a modified database page to disk. In this sense the log on disk is always 'ahead' of the disk image of the database. But, of course, you may lose the updates of the latest transactions in a crash, if the database has not yet written the relevant log segment to disk. Regards, Heikki >-- >Best regards, > Petermailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alteon + forks
Hi, I have 2 servers and 1 alteon in HA. But the problem is that the alteon , when trying, to see if the servers are up or down , makes mysql to fork , till it dies.. The connection port we are using is 3306 . Does anyone have any idea? Thanks in advance Best Regards Pedro Jazztel Portugal - Servicos IP Edificio Diogo Cao - Doca de Alcantara 1350-352 Lisboa PORTUGAL Tel: +351 2 1030 1406 Fax: +351 2 1030 1300 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-3.23.35 installation under solaris 7
Pascal THIVENT writes:
> hi,
>
> i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7
> Here are the steps I follow :
>
> # cd mysql-3.23.35
> # CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa"
> # CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti
> -mcpu=v8 -Wa,-xarch=v8plusa"
> # ./configure --prefix=/usr/local/mysql-3.23.35 --with-low-memory
> --enable-assembler --with-client-ldflags=-all-static
> --with-mysqld-ldflags=-all-static --with-innobase
> ...
>
> The configure workes fine.
> But the make genrates this error :
>
> # make
> ...
> Undefined first referenced
> symbol in file
> dlclose /usr/lib/libnsl.a(netdir.o)
> dlsym /usr/lib/libnsl.a(netdir.o)
> dlopen /usr/lib/libnsl.a(netdir.o)
> dlerror /usr/lib/libnsl.a(netdir.o)
> ld: fatal: Symbol referencing errors. No output written to mysql
> collect2: ld returned 1 exit status
> make[2]: *** [mysql] Error 1
> make[2]: Leaving directory `/usr/share/src/mysql-3.23.35/client'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/share/src/mysql-3.23.35'
> make: *** [all-recursive-am] Error 2
>
>
>
> Does this speak to someone ?
> Thanks
>
> --
> Pascal Thivent
>
Hi!
Unfortunately you can not build static programs on Solaris, as Sun has
not provided static versions for many of it's libraries.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpmyadmin + mysql + "Unknown database 'test'"
Hi!
I have installed many of mysql servers and phpMyAdmin clients.
And every time it worked together fine.
Now i have problem on RH70 with mysql and phpMyAdmin:
Database pokus
Error
SQL-query:
Content-Type: application/octet-stream
MySQL said: Unknown database ' pokus'
Back
--
this error is writed when i manualy write sql command to create a new table
in standard database 'test'.
My sql command:
create table aaa (bbb text);
I am logged to phpMyAdmin as a 'root' user with all privileges trough
'advanced' authentification:
begin cut config.inc.php
$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
$cfgServers[1]['port'] = '';// MySQL port - leave blank
for default port
$cfgServers[1]['adv_auth'] = true; // Use advanced
authentication?
$cfgServers[1]['stduser'] = 'root'; // MySQL standard user (only
needed with advanced auth)
$cfgServers[1]['stdpass'] = ''; // MySQL standard password
(only needed with advanced auth)
$cfgServers[1]['user'] = 'root';// MySQL user (only needed
with basic auth)
$cfgServers[1]['password'] = '';// MySQL password (only
needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only
this db is accessible
$cfgServers[1]['verbose'] = ''; // Verbose name for this
host - leave blank to show the hostname
end cut config.inc.php -
other info:
[root@ns /root]# rpm -qa | grep mysql
mysql-3.23.32-1.7
mysqlclient9-3.23.22-3
mysql-server-3.23.32-1.7
php-mysql-4.0.4pl1-3
[root@ns /root]#
[root@ns /root]# uname -a
Linux ns.euronet.sk 2.2.17-14 #1 Mon Feb 5 16:02:20 EST 2001 i686 unknown
[root@ns /root]#
--- begin cut /var/log/mysqld.log: -
010319 12:33:37 1 Connectroot@localhost on
1 Init DBmysql
1 Query SELECT User, Password, Select_priv FROM
user where User = 'root' AND Password = PASSWORD('')
1 Query SELECT VERSION() AS version
1 Quit
--- end cut /var/log/mysqld.log -
Any idea?
Thank You for help!
S pozdravem,
Michal Kolesar
+420 608 225025
[EMAIL PROTECTED]
http://www.egarden.cz
server of free unix services
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ARCHIVING UNDER HEAVY LOAD
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages can be stored in rarely accessed archive (different table?). What's the best practice for implementing archiving in MySQL? In Oracle there's an ability to "switch off" part of the table and then move it to archive in background mode. What about MySQL? Thanks in advance, Alex P.S. This is the second time I post this question, sorry, problems with mail account prevented me from reading the replies. The only one I got was abount using MERGE tables which are still beta. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Maybe its an Odbc error
It won't work in FoxPro because it's a MySQL command, not a FoxPro command. The FoxPro command line will only accept FoxPro commands, it's not a replacement for the mysql client. Being an old Fox-Jockey, I use VFP 6 to move data in and out of MySQL databases and have not had a problem. Try using the VFP import wizard. (Ok, so I hate wizards too but I don't feel like firing up VFP to figure out the command at the moment.) :) HTH, Cal http://www.calevans.com -Original Message- From: Boblee [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 6:33 AM To: [EMAIL PROTECTED] Subject: Maybe its an Odbc error However, its just strange, Using the Myslq-front , front end I can sucessfully execute a load data from infile this is actual command LOAD DATA LOCAL INFILE 'D:/cmremote/mysqldata/PROJ.csv' INTO TABLE cmremote.CURRENT FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES and it works fine. however, when I put that exact command in either my VFP (fox pro) command line, or program using VFP I dont get the data imported into mysql,? I am thinking since I know the command itself is fine and I can get just about anthing else working, with VFP - It might have somehting to do with the setup of MyOdbc Has anyone had experience working with VFP6.0 and MySql as a back end that should shed some light on this. Thank you Bob Lee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql command - copy of one row
super! it work fine. Thank You! S pozdravem, Michal Kolesar +420 608 225025 [EMAIL PROTECTED] http://www.egarden.cz server of free unix services - Original Message - From: "Peter Pentchev" <[EMAIL PROTECTED]> To: "- = k o l i s k o = -" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 12:56 PM Subject: Re: sql command - copy of one row > On Mon, Mar 19, 2001 at 12:51:27PM +0100, - = k o l i s k o = - wrote: > > Hi! > > > > i try one little question. > > > > when the table2 have one more row then table1.. is possible try something > > like this: > > > > insert into table2 ($date, select * from table1 where username = '$uname') > > One more 'column' you mean, not 'row'. Yes, this is possible, though > a bit more difficult - you cannot use '*' in the select statement, rather > something like this.. > > If table1 has 3 columns - name, birthdate, salary - then you can do: > > INSERT INTO table2 SELECT '$date', name, birthdate, salary FROM table1 > WHERE username='$uname'; > > You can actually place any constant value in a SELECT statement - that's > the idea behind the above insert-from-select. > > G'luck, > Peter > > -- > If this sentence were in Chinese, it would say something else. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-3.23.35 installation under solaris 7
hi, i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7 Here are the steps I follow : # cd mysql-3.23.35 # CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa" # CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti -mcpu=v8 -Wa,-xarch=v8plusa" # ./configure --prefix=/usr/local/mysql-3.23.35 --with-low-memory --enable-assembler --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-innobase ... The configure workes fine. But the make genrates this error : # make ... Undefined first referenced symbol in file dlclose /usr/lib/libnsl.a(netdir.o) dlsym /usr/lib/libnsl.a(netdir.o) dlopen /usr/lib/libnsl.a(netdir.o) dlerror /usr/lib/libnsl.a(netdir.o) ld: fatal: Symbol referencing errors. No output written to mysql collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/usr/share/src/mysql-3.23.35/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/share/src/mysql-3.23.35' make: *** [all-recursive-am] Error 2 Does this speak to someone ? Thanks -- Pascal Thivent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
