Re: Installing mysql 4.0.3 with linux threads on freebsd
On Thu, 29 Aug 2002, Dan Nelson wrote: > > Please don't hijack threads; you replied to a message titled > "performance tunning 4.x". sorry, my fault... > > In the last episode (Aug 29), Varshavchick Alexander said: > > I have a FreeBSD server where I installed mysql 3.23 with linux > > threads from a port collection, the procedure was simple enough > > (WITH_LINUXTHREADS=yes make). All my attempts then to build it from > > sources were unsuccessfull, however it was not important consdering > > that it could be installed from ports. But now I wish to upgrade it > > to 4.0.3 (keeping the linuxthreads option), so can anybody advice on > > the procedure of building it from scratch? > > Try the attached port; it builds and runs fine on my -current system, > and it should work on 4.*. Extract it, uncomment the > WITH_LINUXTHREADS=yes line, and make. > thanks a bit, this is just what was needed! > -- > Dan Nelson > [EMAIL PROTECTED] > Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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 4.0 and LIKE "%string%"
That optimization is for fields without an index AFAIK. Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - 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
Security problem
*This message was transferred with a trial version of CommuniGate(tm) Pro* I installed Mac OS X 10.2 this last weekend and since then I've been having some problems with the security on the MySQL files. I thought that I had everything fixed, but now when my web users try and update or insert a record in one of my files, it doesn't actually update anything. I've checked the mysql.log and mysql.err and there isn't any kind of error listed. Selects work just fine. Any ideas would be appreciated. Thanks, Daniel Wilson Austin Shakespeare Festival - 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 4.0 and LIKE "%string%"
Quote from the "How MySQL Uses Indexes" document: MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE "%string%" and string is longer than 3 characters, MySQL will use the Turbo Boyer-Moore algorithm to initialise the pattern for the string and then use this pattern to perform the search quicker. Does this optimisation depend on the existence of an index on that column, or is it used even without an index? Either way, how big is the speed improvement? -- Florin Andrei "Cryptophiles had been so enraptured by the possibilities of uncrackable ciphers that they forgot they were living in a world in which people can't program VCRs." - Bruce Schneier - 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
Aborted connection(Got an error reading communication packets)
Hi , We are getting following message multiple times in mysqldb.err file:-- 020829 13:46:39 Aborted connection 9556 to db: 'storageprofiler' user: 'root' host: `localhost' (Got an error reading communication packets) -- conect_timeout and all other configuration parameters are set to default. Our queries are running extremely slow on Solaris server while it is really fast on Windows. (I had posted this message yesterday which can be found at the end of this e-mail). Has anybody encountered such problem before? Thanks, Supriya - Original Message - From: "Supriya Shiyekar" <[EMAIL PROTECTED]> To: "Mark Matthews" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 5:18 PM Subject: Re: MySql performance problem > Hi Mark, > >Thanks for the reply. I have got more information. > > 1. We set only the port, basedir and datadir parameters for mysql on both > Windows and Solaris machines. All other configuration parameters are > default. > > 2. Setup for Windows Machine :- > > OS - Windows 2000 professional SP2 > RAM - 196 MB > CPU - Pentium III 600MHz > Disk Drive - C:\- 14 GB > No SCSI > > Setup for Solaris Server :- > >System Configuration: Sun Microsystems sun4u 8-slot Sun > > >Enterprise E4500/E5500 > > >System clock frequency: 84 MHz > > >Memory size: 2048Mb > > > > > >= CPUs = > > > > > > Run Ecache CPUCPU > > >Brd CPU Module MHz MBImpl. Mask > > >--- --- --- - -- -- > > > 0 0 0 336 4.0 US-II2.0 > > > 0 1 1 336 4.0 US-II2.0 > > > 2 4 0 336 4.0 US-II2.0 > > > 2 5 1 336 4.0 US-II2.0 > > > > > > > > >= Memory > > > Intrlv. > > > Intrlv. > > >Brd Bank MBStatus Condition Speed Factor > > > With > > >--- - --- -- - --- > > > --- > > > 0 01024 Active OK 60ns2-way > > >A > > > 2 01024 Active OK 60ns2-way > > >A > > > > > >= IO Cards > > >= > > > > > > Bus Freq > > >Brd Type MHz Slot Name > > > Model > > >--- > > > -- > > > 1 SBus 25 0 fcaw/sd (block) > > > FCW > > > 1 SBus 25 1 fcaw/sd (block) > > > FCW > > > 1 SBus 25 2 SUNW,qfe > > > SUNW,sbus-qfe > > > 1 SBus 25 2 SUNW,qfe > > > SUNW,sbus-qfe > > > 1 SBus 25 2 SUNW,qfe > > > SUNW,sbus-qfe > > > 1 SBus 25 2 SUNW,qfe > > > SUNW,sbus-qfe > > > 1 SBus 25 3 SUNW,hme > > > > > > 1 SBus 25 3 SUNW,fas/sd (block) > > > > > > 1 SBus 2513 SUNW,socal/sf (scsi-3) > > > 501-3060 > > > > > >No failures found in System > > >=== > > > > > >No System Faults found > > >== > > > > > Thanks for the help, > Supriya. > > > - Original Message - > > From: "Mark Matthews" <[EMAIL PROTECTED]> > > To: "Supriya Shiyekar" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Wednesday, August 28, 2002 7:02 AM > > Subject: Re: MySql performance problem > > > > > > > - Original Message - > > > From: "Supriya Shiyekar" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, August 27, 2002 10:59 PM > > > Subject: MySql performance problem > > > > > > > > > > > > > > Hi, > > > > > > > > We are having strange performance problem with mysql on > > Solaris.Our > > > > application makes JDBC calls to mysql database which resides locally > on > > > the > > > > machine. > > > > It takes 3 minutes to execute a piece of code(which involves > > select, > > > > insert and update queries) on a Windows machine but an hour on > Solaris. > > > Both > > > > databases(on windows and solaris) have exactly same database structure > > > > including indexes and table sizes. > > > > We are using mysql 3.23.44. > > > > Is this something to do with the memory allocated to mysql on > > > Solaris > > > > machine ? Do we need to check any server parameters for mysql ? > > > > > > What is the setup of the two machines? (CPU/RAM/Disk/SCSI/IDE, etc), and > > > what configuration parameters are you using now? Without this, you're > > asking > > > us to guess, more information from you would get a better answer. > > > > > > -Mark > > > > > > > > > > > > --
Re: MySQL and Service Pack 3
Do you have any copyright / DRM-enable-able content on your machine? I thought the understanding within the nt administrator community was to boycott sp3 until M$ revised their EULA to revert ownership back to the organization / person who paid the money for the hardware it runs on... Sorry; it has to be said. -sql, query, table, join, union, drop database mysql Van -- = Linux rocks!!! http://www.dedserius.com/ = Marc Hus wrote: > > Yeah, I tried that too. About 5 times with each and every version you > have. It worked so wonderful before and I just don't understand why it > wants to act up now :( > > Going to be a real pain to have to reformat that server to get it to > work > > --Marc Hus > - 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 Tables...
I have a problem with MySQL. I am trying to insert data using INFILE, and it works, except that it ALWAYS stop at 255 (autoindex) and will not go any further, either by manual insert or textfile insert. I am running MySQL 3.23.38-max-nt on a Windows 2000 Server. Is this a known issue? something I can fix? configure problem? Any help is greatly appreciated. +--+ | ___ ___ | | //_/_/_/_/_/ //_/_/_/ | |//_/ //_/ _/ | | //_/ //_/ _/| | //_/ //_/_/_/ | +--+ | Tony Devlin - [EMAIL PROTECTED] | | Airewaves Broadband, Systems Admin | | Website - www.airewaves.com | | Atlanta, Ga - 678.522.3923 | | Beaufort, SC - 843.379.AIRE(2473)| +--+ - 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
limiting the user
Hi everyone, I am running a FreeBSD server with MySQL 3.23 I want to let my virtual users create/drop tables and limit the size of each table, and also the number of tables they can create. Can someone please tell me how I can do this? Is it possible wit applications such as webmin, or phpMyAdmin? Thanks so much - 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
OPTIMIZE TABLE, is it safe?
I have several large MyISAM tables that are frequently updated by certain events in the application. I find that the queries get considerably slower over time, and I run OPTIMIZE TABLE to defragment the datafiles. The user comments on http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html seem to indicate that OPTIMIZE TABLE has been known to crash the datafiles (which versions?) though I have never experienced that myself. I'm now considering running OPTIMIZE TABLE on a few key tables immediately after the application does something that fragments the datafile. Locking of the table is not an issue. However, backing up (dump) those tables every time before running OPTIMIZE TABLE would be difficult to implement. The application would have to create backups, detect weather OPTIMIZE TABLE crashed the tables, then try to restore from backups if it did. My question is whether you have experienced crashes due to OPTIMIZE TABLE? Have there been any recent bug fixes pertaining to OPTIMIZE TABLE? Any other suggestions? I currently run Ver 3.23.47-max-debug on Windows 2000. Alek - 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: Connecting to another machine with myCC
Sorry everyone, I must've forgotten to set the password with an 'identified by' clause, or I needed to grant to *.*: grant all on *.* to "fred"@"192.168.0.230" identified by 'fred'; it works now. thanks! Fred > -Original Message- > From: Alexander Burbello [mailto:[EMAIL PROTECTED]] > Sent: 29 August 2002 13:17 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Connecting to another machine with myCC > > > Hi, > > Try another tool named "My Database Manager". You can download the site > br.geocities.com/burbello. > > Greedings > > > Alexander > - 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 and Service Pack 3 - OT comment
This might explain how I lost my secondary IDE controller. I just unistalled SP3 to resolve my issue. On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote: > Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST) > From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= <[EMAIL PROTECTED]> > To: Marc Hus <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL and Service Pack 3 > > Hello, > > Reinstall your MySQL service using mysqld((-max)-nt) --install > SP3 somehow manages to remove the service registration in some cases. > > Regards, > Iikka > > On Thu, 29 Aug 2002, Marc Hus wrote: > > > Hello, > > > > I have a very strange problem with all of the Windows versions of MySQL. > > I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will > > not work period. Has anyone ran into this problem and or know of a fix? > > > > > > > > Marc > > > > > > > > > > - > > 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 > > > > ** > * Iikka Meriläinen * > * E-mail: [EMAIL PROTECTED] * > * Vaala, Finland * > ** > > > - > 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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: What's data/*-bin.*?
At 16:03 -0400 8/29/02, Philip Mak wrote: >What are all these rei-bin.* files in this MySQL data directory? Are >they needed? They're taking up a lot of disk space. They seem to be >some sort of log. > >horderei.aaanime.net.pid rei-bin.008 rei-bin.016 >linkwars rei-bin.001 rei-bin.009 rei-bin.017 >my.cnf rei-bin.002 rei-bin.010 rei-bin.018 >mysqlrei-bin.003 rei-bin.011 rei-bin.019 >plesk.rackshack.net.err rei-bin.004 rei-bin.012 rei-bin.020 >plesk.rackshack.net.pid rei-bin.005 rei-bin.013 rei-bin.021 >psa rei-bin.006 rei-bin.014 rei-bin.022 >rei.aaanime.net.err rei-bin.007 rei-bin.015 rei-bin.index The binary update logs. They serve as a record of updated, to be used for two primary purposes: - To be sent to slave replication servers - To be used for data recovery purposes after a crash The rei-bin.index file is an index of the binary log files. It records which binary logs the server is maintaining. - 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 and Service Pack 3
Yeah, I tried that too. About 5 times with each and every version you have. It worked so wonderful before and I just don't understand why it wants to act up now :( Going to be a real pain to have to reformat that server to get it to work --Marc Hus -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 3:29 PM To: Marc Hus; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL and Service Pack 3 At 14:29 29/08/02 -0500, Marc Hus wrote: Hi, >Hello, > >I have a very strange problem with all of the Windows versions of MySQL. >I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will >not work period. Has anyone ran into this problem and or know of a fix? Some users had reported before this issue, for someone the remove and re-install the MySQL service had resolved the issue. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil <___/ www.mysql.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 and Service Pack 3
Hello, No problem with my version of mysql. w2k server sp3 installed while running mysql 3.23.51-max-nt-log. John > -Original Message- > From: Marc Hus [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 12:29 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: MySQL and Service Pack 3 > > > Hello, > > I have a very strange problem with all of the Windows versions of MySQL. > I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will > not work period. Has anyone ran into this problem and or know of a fix? > > > > Marc > > > > > - > 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 and Service Pack 3
Well I just tried that and it keeps saying The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe I really don't understand it though, It ran great before the inevetible Service Pack Upgrade :( --Marc Hus -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Iikka Meriläinen Sent: Thursday, August 29, 2002 3:10 PM To: Marc Hus Cc: [EMAIL PROTECTED] Subject: Re: MySQL and Service Pack 3 Hello, Reinstall your MySQL service using mysqld((-max)-nt) --install SP3 somehow manages to remove the service registration in some cases. Regards, Iikka On Thu, 29 Aug 2002, Marc Hus wrote: > Hello, > > I have a very strange problem with all of the Windows versions of MySQL. > I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will > not work period. Has anyone ran into this problem and or know of a fix? > > > > Marc > > > > > - > 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 > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 and Service Pack 3
At 14:29 29/08/02 -0500, Marc Hus wrote: Hi, >Hello, > >I have a very strange problem with all of the Windows versions of MySQL. >I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will >not work period. Has anyone ran into this problem and or know of a fix? Some users had reported before this issue, for someone the remove and re-install the MySQL service had resolved the issue. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil <___/ www.mysql.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: user password self management -- how?
Hello.
On Thu 2002-08-29 at 11:38:17 -0700, [EMAIL PROTECTED] wrote:
[...]
> I'm sure I can do this "programmatically" by having my program connect to
> the database using the "root" user/password, but that means embedding the
> password in the program [i.e., viewable with "string..."] so once a user
> deciphers that, they are free to run "mysql -u root" from anywhere the
> "application" could run.
IIRC, mysqladmin allows you to change your password yourself, so this
should be possible for any application. I guess it uses SET:
SET PASSWORD FOR jeffrey@"%" = PASSWORD('biscuit');
The manual says about this "Set the password for the current user. Any
non-anonymous user can change his own password!"
(http://www.mysql.com/doc/en/SET_OPTION.html)
> maybe I'm thinking in a deranged way, but it seems that granting "update"
> access WITHOUT granting "select" access to the user table in mysql [and
> perhaps even limited to the password column] would enable a user to change
> their password without being able to read anyone else's (encrypted) password
> value;
You need SELECT privilege to use restrict your query via WHERE clause
(because the WHERE has to do an equivalent of an SELECT implicitly).
Even if you could have it that way (allowing WHERE on UPDATE without
select privelege), this would only provide a small threshold. This
came up some time ago (oops, July 1999 ;), and my answer was this:
http://marc.theaimsgroup.com/?l=mysql&m=93121950516543&w=2
The summary is that you could figure out the password with less than
100 queries, so, it would be quite useless.
> HOWEVER that would also allow them to CHANGE anyone ELSE'S password
> [even "root"] -- is it possible to limit access at the ROW level? (i.e.,
> user "x" can only select/update records with "user='x'")
>
> The reason I'm doing this is that I'm designing an application that logs on
> with a "fixed" username and uses it's own "user/password" table to validate
> end-users. The program notes if a password in the database is blank -- if
> so, it compares the user-supplied password with a (eventually well-known)
> "first-time" password and forces the user to set a new password, so
> obviously the "fixed" user ID needs the ability to udpate the application's
> password table, which has the same problems as the "system" level table, but
> limits the "damage" that can be caused to just the application and not "all
> of mysql"...
Oh. Okay, in this case SET PASSWORD is not appliable to your case. :-(
Thought you were talking about pure database users.
[...]
> Ultimately, I'd like to use mysql's user/password (grant) facillities
> directly, but since the application would be distributed to offices
> nationwide [all "phoning home" to the central database via the internet], I
> don't want to burden the one system manager/DBA with the responsibility of
> maintaining every single clerk and technician that can use the system -- I'm
[...]
Hm. If you change to GRANT, and create a database user for each real
user, I think SET PASSWORD could do what you want.
However, maybe I completely misunderstand your requirements.
Regards,
Benjamin.
--
[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: MySQL and Service Pack 3
Hello, Reinstall your MySQL service using mysqld((-max)-nt) --install SP3 somehow manages to remove the service registration in some cases. Regards, Iikka On Thu, 29 Aug 2002, Marc Hus wrote: > Hello, > > I have a very strange problem with all of the Windows versions of MySQL. > I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will > not work period. Has anyone ran into this problem and or know of a fix? > > > > Marc > > > > > - > 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 > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
What's data/*-bin.*?
What are all these rei-bin.* files in this MySQL data directory? Are they needed? They're taking up a lot of disk space. They seem to be some sort of log. horderei.aaanime.net.pid rei-bin.008 rei-bin.016 linkwars rei-bin.001 rei-bin.009 rei-bin.017 my.cnf rei-bin.002 rei-bin.010 rei-bin.018 mysqlrei-bin.003 rei-bin.011 rei-bin.019 plesk.rackshack.net.err rei-bin.004 rei-bin.012 rei-bin.020 plesk.rackshack.net.pid rei-bin.005 rei-bin.013 rei-bin.021 psa rei-bin.006 rei-bin.014 rei-bin.022 rei.aaanime.net.err rei-bin.007 rei-bin.015 rei-bin.index - 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 and Service Pack 3
Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Marc - 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: DATES and WHERE
Short answer YES you have to have them why because 2002-08-29 = 1965 -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 1:30 PM To: [EMAIL PROTECTED] Subject: DATES and WHERE I'm a bit confused here.. dates are not my strong point.. I have a table with a date column in it (DATE datatype) a few values: mysql> select dte from images\G *** 1. row *** dte: 2002-08-29 *** 2. row *** dte: 2001-08-29 *** 3. row *** dte: 2002-08-29 *** 4. row *** dte: 2002-06-29 *** 5. row *** dte: 2002-08-29 *** 6. row *** dte: 2002-10-29 *** 7. row *** dte: 1999-08-29 7 rows in set (0.00 sec) When I impose a where condition on the date column (without using single quotes around my target date, I still get all records): mysql> select dte from images where dte>2002-09-20\G *** 1. row *** dte: 2002-08-29 *** 2. row *** dte: 2001-08-29 *** 3. row *** dte: 2002-08-29 *** 4. row *** dte: 2002-06-29 *** 5. row *** dte: 2002-08-29 *** 6. row *** dte: 2002-10-29 *** 7. row *** dte: 1999-08-29 7 rows in set (0.00 sec) with quotes: mysql> select dte from images where dte>'2002-09-20'\G *** 1. row *** dte: 2002-10-29 1 row in set (0.00 sec) Is this correct? Should I have to use quotes around a date in a where clause? Or do I have something wrong here? mysql> select version()\G *** 1. row *** version(): 3.23.49-max-nt 1 row in set (0.00 sec) - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 - 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
weblogic integration problem
I am trying to create a mysql connection pool in Weblogic 6.1 using the JConnector driver and failing. All I get is "no suitable driver" which usually means that the URL and properties aren't right for the driver I'm using. I defined the pool as: name: MysqlPool URL: jdbc:mysql//192.168.1.100:3306/Objectworks?user=root;password=jude370 driver: com.mysql.jdbc.Driver properties: user=root;password=jude370 I put the jconnector jar file at the head of the weblogic classpath. Before that, it complained about not finding the driver class. THe properties seemed redundant but when I removed them, weblogic complained that there were no properties - apparently, properties are required. The URL fits the pattern defined in the JConnector Readme file. So, I'm just stumped. Can anyone tell me the correct incantation to get the jconnector driver to work in this context? thanks, ag - 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: Java and Mysql, problem with String encoding
John Deligiannis wrote: > Hello, > > I have an applet that uses mysql. I have added support for greek > and for data that are already in mysql, it works fine. When I add > other from my applet it prints "". > Another thing is that I construct a table from the resultSet using > two (String) vectors. The table headers come out unreadable. > Is there any procedure that I need to add in order to work? > > Thank you > > John The secret is in the README file (as usual) :) Add "useUnicode=true&characterEncoding=BLAH" where BLAH is whatever character encoding you are using (ISO8859-1, UTF-8, etc). -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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
user password self management -- how?
This is actually a bit of a general-database question, since I'm sure it has the same or similar repercussions regardless of which RDBMS you use, but I'm curious: is it possible to "safely" allow users to maintain their own passwords to a database? [and if so, how?] I'm sure I can do this "programmatically" by having my program connect to the database using the "root" user/password, but that means embedding the password in the program [i.e., viewable with "string..."] so once a user deciphers that, they are free to run "mysql -u root" from anywhere the "application" could run. maybe I'm thinking in a deranged way, but it seems that granting "update" access WITHOUT granting "select" access to the user table in mysql [and perhaps even limited to the password column] would enable a user to change their password without being able to read anyone else's (encrypted) password value; HOWEVER that would also allow them to CHANGE anyone ELSE'S password [even "root"] -- is it possible to limit access at the ROW level? (i.e., user "x" can only select/update records with "user='x'") The reason I'm doing this is that I'm designing an application that logs on with a "fixed" username and uses it's own "user/password" table to validate end-users. The program notes if a password in the database is blank -- if so, it compares the user-supplied password with a (eventually well-known) "first-time" password and forces the user to set a new password, so obviously the "fixed" user ID needs the ability to udpate the application's password table, which has the same problems as the "system" level table, but limits the "damage" that can be caused to just the application and not "all of mysql"... (i.e., crackers could determine the "fixed" user's password by scanning the executable, but that won't let them harm anything other than the application itself...) Ultimately, I'd like to use mysql's user/password (grant) facillities directly, but since the application would be distributed to offices nationwide [all "phoning home" to the central database via the internet], I don't want to burden the one system manager/DBA with the responsibility of maintaining every single clerk and technician that can use the system -- I'm willing to let the office manager at each location enter and maintain employees local to that office [which makes sense because that person also does the hiring/firing...] but for obvious reasons, the "managers" cannot manipulate values for other offices [though, I suppose, I have to trust SOME of them... ;) ] If I could guarantee that the "only" access to the database was via my program, then I'm certain I could create logic to maintain passwords safely; however this is not the case -- not only is "mysql" available as a simple client, but anyone with a smattering of knowledge of "Access" and the myodbc connector could create their own "manipulation" program and circumvent any safety protocols I establish. - 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
DATES and WHERE
I'm a bit confused here.. dates are not my strong point.. I have a table with a date column in it (DATE datatype) a few values: mysql> select dte from images\G *** 1. row *** dte: 2002-08-29 *** 2. row *** dte: 2001-08-29 *** 3. row *** dte: 2002-08-29 *** 4. row *** dte: 2002-06-29 *** 5. row *** dte: 2002-08-29 *** 6. row *** dte: 2002-10-29 *** 7. row *** dte: 1999-08-29 7 rows in set (0.00 sec) When I impose a where condition on the date column (without using single quotes around my target date, I still get all records): mysql> select dte from images where dte>2002-09-20\G *** 1. row *** dte: 2002-08-29 *** 2. row *** dte: 2001-08-29 *** 3. row *** dte: 2002-08-29 *** 4. row *** dte: 2002-06-29 *** 5. row *** dte: 2002-08-29 *** 6. row *** dte: 2002-10-29 *** 7. row *** dte: 1999-08-29 7 rows in set (0.00 sec) with quotes: mysql> select dte from images where dte>'2002-09-20'\G *** 1. row *** dte: 2002-10-29 1 row in set (0.00 sec) Is this correct? Should I have to use quotes around a date in a where clause? Or do I have something wrong here? mysql> select version()\G *** 1. row *** version(): 3.23.49-max-nt 1 row in set (0.00 sec) - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 - 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
Trouble configuring Tomcat 4.0.4 JNDI connection to MySQL
I'm having trouble connecting to MySQL using JNDI with Tomcat. I have
deleted my server.xml and started with a fresh copy. First, I made sure I
could connect to MySQL with a regular JDBC connection. Next, I added a
JDBC Realm using MySQL. That works fine. Finally, I added a JDBC resource
and tried to use it. That is when I get the error below.
The error I have, and have always had, even before the 4.1 detour, is the
following:
javax.naming.NamingException: Exception creating DataSource:
org.hsql.jdbcDriver
at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at foo.DBTest1.init(DBTest1.java:19)
at org.apache.jsp.DbTest1$jsp._jspService(DbTest1$jsp.java:60)
Why would Tomcat be looking for a Hypersonic SQL driver? I took a shot and
copied Hypersonic 1.61 hsqldb.jar to /common/lib, but when it had no effect
I removed it.
I'm currently running
Windows 2000
J2SE 1.4.0
J2SE 1.3.1
Tomcat 4.04
MySQL 4.0.2-Alpha
MySQL Connector 2.0.14. (I copied mysql-connector-java-2.0.14-bin.jar to
$TOMCAT_HOME/common/lib,)
I get the same error no matter what code I run. For example, Both code
blocks below result in the same error:
Context ctx = new InitialContext();
ctx.addToEnvironment(Context.INITIAL_CONTEXT_FACTORY,
"com.sun.jndi.fscontext.RefFSContextFactory");
Connection conn = ds.getConnection();
if(ctx == null )
throw new Exception("Boom - No Context");
DataSource ds = (DataSource)ctx.lookup(
"java:comp/env/jdbc/TestDB"); <-- Blows up here
--- AND ---
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
if(envCtx == null )
throw new Exception("Boom - No Context");
DataSource ds =
(DataSource)envCtx.lookup("jdbc/TestDB"); <--- Blows up here
I added the following to the web.xml file:
DB Connection
jdbc/TestDB
javax.sql.DataSource
Container
Here is my server.xml file:
factory
org.apache.commons.dbcp.BasicDataSourceFactory
maxActive
100
maxIdle
3
maxWait
100
username
javauser
password
javadude
driverClassName
org.gjt.mm.mysql.Driver
url
jdbc:mysql://localhost:3306/javatest
Any ideas?
Steve Mitchell
e-Business Architect/Developer
Integrated Corporate Solutions, Inc.
913-685-6506
[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: Mysql on a separate server from webserver
Something like this: $site::dbName= 'DBI:mysql:test:10.10.2.20'; for a database called test on 10.10.2.20 Then add the user for the web machine (assuming it's 10.10.2.10) to the authorized list: Grant select on test.* to [EMAIL PROTECTED] identified by 'password'; Flush privileges; Everything else is exactly the same (and I find it works much better and is obviously more secure). -Original Message- From: Nestor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 3:09 AM To: [EMAIL PROTECTED] Subject: Mysql on a separate server from webserver I have written previous websites where I used perl or PHP to access a Mysql DB wen bith the webserver and the Mysql db are on the same server. My questions is how different is it to access or connect to the Mysql database when the database is on a separate server(machine)? Thanks, Nestor A. Florez http://www.IneedWork.org <---My website --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/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
Java and Mysql, problem with String encoding
Thank you for your answer. I have to apologise for my bad post(I work 1
week on this problem and it was a desperite try).
I have done what you suggested, but it partly works.
Without "useUnicode=true" I didn't get anything right.
With "useUnicode=true" I did get the data that were already in my table
right, but not the table headers.
Also (With "useUnicode=true"), when I inserted data from my form they
did not appear correct.
I read previous posts about "new String("","ENCODING") " I , but
a. this does not solve the header problem
b. when I run my applet from a greek locale PC it shows the table headers.
Thanx and sorry for my 'lame' post,
John
MySql
-
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: Stored Procedureish Advise needed
Hi,
Some what it seems to be like store procedure for MySQL you can find on:
http://www.fastflow.it/mylua/
For trigger you don't have alternative.You must write a simple application
which monitoring your Internet Sessions and writing
in MySQL DataBase.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "John Gruber" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 7:08 PM
Subject: Stored Procedureish Advise needed
> Hello gang,
>
> I have an application (radius) that is logging network activity to MySQL.
> When a users completes a network session an accounting insert query is
made
> for that session showing the session length. The application has the
> functionality to SUM all session times for a user and determine if it
should
> let them connect the next time. The SUM query will eat us up as the
number
> of session in the table is very large. If I had stored procedures (and
> triggers would make this so nice!) I would simply add the seconds every
time
> I got an accounting update. This would reduce my overhead 1000 fold. I can
> alter the INSERT query for the application, but the application will only
> let me issue ONE query.
>
> What are my options with MySQL 3.x. I have looked at the User Defined
> Functions, but that requires me to write a n exit to C that just calls
> embedded SQL to populate another table. There must be an SQL solution to
> this.
>
> I.O.W turn the following into one query for me!
>
> INSERT INTO SOMETABLE (val1,val2,val3) VALUES ('val1','val2','val3')
>
> and (psuedo code.. which makes now sense!)
>
> UPDATE SOMEOTHERTABLE SET (SECONDS = SUM('val1' + SECONDS))
>
> This is trivial to do in a stored procedure for other databases. You would
> simply store the value of the current seconds in a variable, add the input
> argument to it, and then update the table.
>
> Tell me how to do this in MySQL. Have your application do it or, call a
> script doesn't help me much. This has to be a database thing. Am I stuck
> with UDF or native functions? The generic examples aren't much help.
Does
> anyone have the C/C++ code to define a UDF that can execute an input
command
> script (i.e. execv?) so I can write this in perl and be able to change it
on
> the fly?
>
> Thanks in advance...
>
> John Gruber
>
>
> -
> 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: like problem
muchas gracias!!
you are a genius.
it's all, I can to continue working
thanks
Sandra
- Original Message -
From: Jed Verity <[EMAIL PROTECTED]>
To: Jorge Martinez <[EMAIL PROTECTED]>; Mary Stickney
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 2:08 PM
Subject: Re: like problem
> How about
>
> select a.name from table1 a, table2 b where a.name like
> concat("%",b.name,"%");
>
> You might want to read chapter 6.3 in the mysql manual:
> http://www.mysql.com/doc/en/Functions.html
>
> HTH,
> Jed
>
> On the threshold of genius, Jorge Martinez wrote:
>
> > yes, but select a.name from table1 a, table2 b where a.name like
> > '%'b.name'%';
> >
> > is an error
> >
> >
> > - Original Message -
> > From: Mary Stickney <[EMAIL PROTECTED]>
> > To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Thursday, August 29, 2002 1:26 PM
> > Subject: RE: like problem
> >
> >
> >>
> >> that would be because b.name is inside the ' ' and it is taken as a
> >> constant.
> >>
> >>
> >> -Original Message-
> >> From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
> >> Sent: Thursday, August 29, 2002 11:10 AM
> >> To: [EMAIL PROTECTED]
> >> Subject: like problem
> >>
> >>
> >> i need this consult
> >>
> >> select a.name from table1 a, table2 b where a.name like '%b.name%';
> >>
> >> but i have a problem because Mysql not recognize the value of b.name
> >>
> >>
> >>
> >> -
> >> 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
> >>
> >
> >
> > -
> > 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: like problem
I'm doing this in the command line of mysql for linux. I tried your suggestion and the results was bads. it assume that I write " a.nombre like '%' " and shows all registers. any suggestion?? thanks - Original Message - From: Mary Stickney <[EMAIL PROTECTED]> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 1:52 PM Subject: RE: like problem > > > ok try this > select a.name from table1 a, table2 b where a.name like > '%'+ b.name + '%'; > > > -Original Message- > From: Jorge Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 11:48 AM > To: Mary Stickney; [EMAIL PROTECTED] > Subject: RE: like problem > > > yes, but select a.name from table1 a, table2 b where a.name like > '%'b.name'%'; > > is an error > > > - Original Message - > From: Mary Stickney <[EMAIL PROTECTED]> > To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, August 29, 2002 1:26 PM > Subject: RE: like problem > > > > > > that would be because b.name is inside the ' ' and it is taken as a > > constant. > > > > > > -Original Message- > > From: Jorge Martinez [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 29, 2002 11:10 AM > > To: [EMAIL PROTECTED] > > Subject: like problem > > > > > > i need this consult > > > > select a.name from table1 a, table2 b where a.name like '%b.name%'; > > > > but i have a problem because Mysql not recognize the value of b.name > > > > > > > > - > > 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 > > > - 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: like problem
How about
select a.name from table1 a, table2 b where a.name like
concat("%",b.name,"%");
You might want to read chapter 6.3 in the mysql manual:
http://www.mysql.com/doc/en/Functions.html
HTH,
Jed
On the threshold of genius, Jorge Martinez wrote:
> yes, but select a.name from table1 a, table2 b where a.name like
> '%'b.name'%';
>
> is an error
>
>
> - Original Message -
> From: Mary Stickney <[EMAIL PROTECTED]>
> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, August 29, 2002 1:26 PM
> Subject: RE: like problem
>
>
>>
>> that would be because b.name is inside the ' ' and it is taken as a
>> constant.
>>
>>
>> -Original Message-
>> From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, August 29, 2002 11:10 AM
>> To: [EMAIL PROTECTED]
>> Subject: like problem
>>
>>
>> i need this consult
>>
>> select a.name from table1 a, table2 b where a.name like '%b.name%';
>>
>> but i have a problem because Mysql not recognize the value of b.name
>>
>>
>>
>> -
>> 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
>>
>
>
> -
> 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: like problem
Hi,
Mary gives you a sugestion about how can you use field(b.name) in this case.
You can try this :
select a.name from table1 a, table2 b where a.name like
CONCAT('%',b.name,'%');
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Jorge Martinez" <[EMAIL PROTECTED]>
To: "Mary Stickney" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 7:48 PM
Subject: RE: like problem
> yes, but select a.name from table1 a, table2 b where a.name like
> '%'b.name'%';
>
> is an error
>
>
> - Original Message -
> From: Mary Stickney <[EMAIL PROTECTED]>
> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, August 29, 2002 1:26 PM
> Subject: RE: like problem
>
>
> >
> > that would be because b.name is inside the ' ' and it is taken as a
> > constant.
> >
> >
> > -Original Message-
> > From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 29, 2002 11:10 AM
> > To: [EMAIL PROTECTED]
> > Subject: like problem
> >
> >
> > i need this consult
> >
> > select a.name from table1 a, table2 b where a.name like '%b.name%';
> >
> > but i have a problem because Mysql not recognize the value of b.name
> >
> >
> >
> > -
> > 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
> >
>
>
> -
> 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: Installing mysql 4.0.3 with linux threads on freebsd
Please don't hijack threads; you replied to a message titled "performance tunning 4.x". In the last episode (Aug 29), Varshavchick Alexander said: > I have a FreeBSD server where I installed mysql 3.23 with linux > threads from a port collection, the procedure was simple enough > (WITH_LINUXTHREADS=yes make). All my attempts then to build it from > sources were unsuccessfull, however it was not important consdering > that it could be installed from ports. But now I wish to upgrade it > to 4.0.3 (keeping the linuxthreads option), so can anybody advice on > the procedure of building it from scratch? Try the attached port; it builds and runs fine on my -current system, and it should work on 4.*. Extract it, uncomment the WITH_LINUXTHREADS=yes line, and make. -- Dan Nelson [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: Stored Procedureish Advise needed
In the last episode (Aug 29), John Gruber said:
> I have an application (radius) that is logging network activity to
> MySQL. When a users completes a network session an accounting insert
> query is made for that session showing the session length. The
> application has the functionality to SUM all session times for a user
> and determine if it should let them connect the next time. The SUM
> query will eat us up as the number of session in the table is very
> large. If I had stored procedures (and triggers would make this so
> nice!) I would simply add the seconds every time I got an accounting
> update. This would reduce my overhead 1000 fold. I can alter the
> INSERT query for the application, but the application will only let
> me issue ONE query.
You'll have to change your application, then :)
> I.O.W turn the following into one query for me!
>
> INSERT INTO SOMETABLE (val1,val2,val3) VALUES ('val1','val2','val3')
>
> and (psuedo code.. which makes now sense!)
>
> UPDATE SOMEOTHERTABLE SET (SECONDS = SUM('val1' + SECONDS))
You can always run an hourly total script that walks through the
accounting records added in the last hour and updates the user records
in SOMEOTHERTABLE. Or even run it every minute.
--
Dan Nelson
[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: like problem
ok try this select a.name from table1 a, table2 b where a.name like '%'+ b.name + '%'; -Original Message- From: Jorge Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:48 AM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: like problem yes, but select a.name from table1 a, table2 b where a.name like '%'b.name'%'; is an error - Original Message - From: Mary Stickney <[EMAIL PROTECTED]> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 1:26 PM Subject: RE: like problem > > that would be because b.name is inside the ' ' and it is taken as a > constant. > > > -Original Message- > From: Jorge Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 11:10 AM > To: [EMAIL PROTECTED] > Subject: like problem > > > i need this consult > > select a.name from table1 a, table2 b where a.name like '%b.name%'; > > but i have a problem because Mysql not recognize the value of b.name > > > > - > 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 > - 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: like problem
yes, but select a.name from table1 a, table2 b where a.name like '%'b.name'%'; is an error - Original Message - From: Mary Stickney <[EMAIL PROTECTED]> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 1:26 PM Subject: RE: like problem > > that would be because b.name is inside the ' ' and it is taken as a > constant. > > > -Original Message- > From: Jorge Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 11:10 AM > To: [EMAIL PROTECTED] > Subject: like problem > > > i need this consult > > select a.name from table1 a, table2 b where a.name like '%b.name%'; > > but i have a problem because Mysql not recognize the value of b.name > > > > - > 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 > - 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
How to apply the mysql++ api patch
Hi I need to use the mysql c++ api in combination with gcc 3.0. I have downloaded the patch but I have trouble applying it. I've tried the patch tool but that did not seem to understand the patch file. Is there a solution or do I need to manually change every single file mentioned in the patch ? greetings Bone Machine - 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: like problem
that would be because b.name is inside the ' ' and it is taken as a constant. -Original Message- From: Jorge Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:10 AM To: [EMAIL PROTECTED] Subject: like problem i need this consult select a.name from table1 a, table2 b where a.name like '%b.name%'; but i have a problem because Mysql not recognize the value of b.name - 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
Java and Mysql, problem with String encoding
Hello, I have an applet that uses mysql. I have added support for greek and for data that are already in mysql, it works fine. When I add other from my applet it prints "". Another thing is that I construct a table from the resultSet using two (String) vectors. The table headers come out unreadable. Is there any procedure that I need to add in order to work? Thank you John -- -- Quoting smart things, written by others is like writing stupid things and putting a "smart" name under it. Albert Einstein -- - 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 4.0 stable release
On Tue, 27 Aug 2002, Dean Ellis wrote: > The annoying thing about it, for me, is that MySQL 4.0 has been perfectly > stable and perfectly usable for us until 4.0.3, which so far has yet to > produce a usable client library. I keep pulling from CVS and recompiling, > hoping that one day soon I'll be able to move beyond 4.0.2. ;) > > Clients in 4.0.3 simply lock up when they try to access a database (whether a > 4.0.2 or 4.0.3 or 3.23 database), for me. Linux 2.4.19, gcc 3.1.1 and 3.2. the source tree 4.0.3 works ok for me, but I compiled with gcc 2.95.3 Thomas - 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
Stored Procedureish Advise needed
Hello gang,
I have an application (radius) that is logging network activity to MySQL.
When a users completes a network session an accounting insert query is made
for that session showing the session length. The application has the
functionality to SUM all session times for a user and determine if it should
let them connect the next time. The SUM query will eat us up as the number
of session in the table is very large. If I had stored procedures (and
triggers would make this so nice!) I would simply add the seconds every time
I got an accounting update. This would reduce my overhead 1000 fold. I can
alter the INSERT query for the application, but the application will only
let me issue ONE query.
What are my options with MySQL 3.x. I have looked at the User Defined
Functions, but that requires me to write a n exit to C that just calls
embedded SQL to populate another table. There must be an SQL solution to
this.
I.O.W turn the following into one query for me!
INSERT INTO SOMETABLE (val1,val2,val3) VALUES ('val1','val2','val3')
and (psuedo code.. which makes now sense!)
UPDATE SOMEOTHERTABLE SET (SECONDS = SUM('val1' + SECONDS))
This is trivial to do in a stored procedure for other databases. You would
simply store the value of the current seconds in a variable, add the input
argument to it, and then update the table.
Tell me how to do this in MySQL. Have your application do it or, call a
script doesn't help me much. This has to be a database thing. Am I stuck
with UDF or native functions? The generic examples aren't much help. Does
anyone have the C/C++ code to define a UDF that can execute an input command
script (i.e. execv?) so I can write this in perl and be able to change it on
the fly?
Thanks in advance...
John Gruber
-
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
like problem
i need this consult select a.name from table1 a, table2 b where a.name like '%b.name%'; but i have a problem because Mysql not recognize the value of b.name - 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: mysqlhotcopy problem - Segmentation fault
Yes, both run 3.23.49a - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Mihail Manolov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 3:24 AM Subject: Re: mysqlhotcopy problem - Segmentation fault > On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: > > I have strange problem - I get Segmentation fault error when I am trying to > > execute mysqlhotcopy. > > > > When I remove the [mysqlhotcopy] section in my /etc/my.cnf > > configuration it works. Meanwhile, on another server it works just > > fine with the same configuration file. > > Do both servers have the same MySQL version installed? - 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: performance tunning 4.x
Hello,
A MySQL developer would be able to answer to these questions more
accurately, but I'll try to answer _logically_. So don't bet a million
dollars on the correctness of my answer.
> >>NOTE: The query cache does not return stale data. When data is modified,
> any relevant entries in the query cache are flushed. <<
>
> If I have a select statement like:
>
> select col1, col2 from table1 where col1='A'
>
> 1) will the cache be flushed if someone changes a non-referenced column for
> one of the retrieved rows:
>
> Update table1 set col3 = 'x' where col1='A'
>
> this update changes col3 that falls within the Where of the query but it
> affects a column that is not returned by the query.
I think this flushes the cache. Think about a situation where col1 is a
computed column that derives its values from the data in col3. When col3
is updated, the value of col1 in the query cache would become invalid.
> 2) or will the cache be flushed if someone changes a row that falls outside
> of the query's Where clause:
This shouldn't explicitly flush the cache, but I don't know the details of
the implementation. This insert shouldn't have any effect on the
aforementioned SELECT query, because col1 here is 'D'.
> insert into table1 (col1, col2, col3) values('D', 'x', 'y');
>
> This last query updates the same table as the select query, but the row
> that is added is outside the range of the query's where clause.
>
>
> So how smart is the cache?
> a) Is it smart enough to allow table updates and if the update doesn't
> affect the query, will it continue to use the cache? (This requires a lot
> of intelligence.)
> b) Or will any update to the rows that fall within the range of the query
> (regardless of whether the column is in the query) will flush the cache?
> c) Or will any update to the table automatically flush the cache?
>
> MONTY:
> I would like to see the Explain command to say if it is using the cache or
> not (CACHE:Yes/No). This would help developers make better use of the cache
> if they know how what affects it.
>
> Mike
>
>
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
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: request for support with mysql_store_result() and mysql_field_count() with vbscript
Hi,
If i understand well, you wish to use MySQL C API function in VBScript.It's
not possible in this way.
But why you don't wish to use ADO?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Angel Moon" <[EMAIL PROTECTED]>
To: "mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 4:29 PM
Subject: request for support with mysql_store_result() and
mysql_field_count() with vbscript
> general outline of situation; my office is moving away from microsoft
> (resistance is NOT futile!!! go slashdot!), and establishing web-based
> customer service systems.
>
> i'm currently establishing a customer table, that links to a contact
table.
> each customer will be listed once; to be the customer name and mailing
> address, with an auto_increment number serving as the customer number (key
> field, cnum).
>
> the contact table will contain specific contact names for each customer,
> with specific details such as email address, phone number, extension,
title,
> etc.
>
> i currently have these tables joined on the customer number (cnum), with a
> separate contact number (auto increment, key field, conum) for the contact
> table.
>
> what i'm TRYING to figure out is this:
>
> i do a search within the two tables to find contacts for a customer, who
has
> been selected from a drop-down box. this is matched on the cnum field in
> both tables.
>
> currently, if NO contacts exist for a client, the screen remains blank. i
> want to generate an option to input contact information in this case. the
> logic for this is roughly:
>
> if the search for cnum within contacts yields no result (empty set) then
> show "do you wish to input?" screen
> else
> list contact info
> end if
>
> i can't seem to get my head wrapped around the syntactual requirements for
> using mysql_store_result() within vbscript.
>
> following is a sample of what i have so far, if it helps. can someone
point
> me in the right direction?
>
> ' Retrieve The Records into Recordset
> cnumfind = "select cnum from cust_info where cname = ('" & custname &
"');"
> Set RS = Con.Execute(cnumfind)
> cnv=rs("cnum")
>
> cinfodisp= "select cont_info.cnum, clname, cfname, cname, caddr1, caddr2,
> ccity, cst, czip, ccountry, cphone, cext, cfax, cemail from cont_info
inner
> join cust_info on cust_info.cnum=cont_info.cnum where cust_info.cnum = '"
&
> cnv & "' and cont_info.cnum=cust_info.cnum;"
> set rs2 = con.execute(cinfodisp)%>
>
>
>
>
> Customer Search Results for
> <% response.write custname %>
>
> <%
> ' Loop through the Records to find all cust_info.cnum where
cust_info.cname
> is what was selected
>
> WHILE NOT RS.EOF
> WHILE NOT RS2.EOF%>
> <%=rs2("cfname")%><%
> response.write " "%> <%=rs2("clname")%>
> Address, Line 1: color=191970><%=rs2("caddr1")%>
> <% if rs2("caddr2") > "" then %>
> Address, Line 2: color=191970><%=rs2("caddr2")%>
> <% end if %>
> City: color=191970><%=rs2("ccity")%> ST: color=191970><%=rs2("cst")%> Zip: color=191970><%=rs2("czip")%>
> Phone: color=191970><%=rs2("cphone")%>
> <% if rs2("cext") > "" then %>
> Ext: <%=rs2("cext")%>
> <% end if %>
> <% if rs2("cfax") > "" then %>
> <%response.write " "%> Fax: color=191970><%=rs2("cfax")%>
> <% end if %>
> <% if rs2("cemail") > "" then %>
> Email: href=mailto:<%=rs2("cemail")%> > <%=rs2("cemail")%>
>
> <% end if %>
>
>
> <%
> rs2.MoveNext
> wend
> rs.movenext
> wend
>
> con.close
> Set Con = nothing
> %>
>
> ANY help would be GREATLY appreciated
>
> angel
> IT Services
> Trintex Corporation
> 770-258-5551
> [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
Installing mysql 4.0.3 with linux threads on freebsd
Hi people, I have a FreeBSD server where I installed mysql 3.23 with linux threads from a port collection, the procedure was simple enough (WITH_LINUXTHREADS=yes make). All my attempts then to build it from sources were unsuccessfull, however it was not important consdering that it could be installed from ports. But now I wish to upgrade it to 4.0.3 (keeping the linuxthreads option), so can anybody advice on the procedure of building it from scratch? If I look at the options which were in effect for the port version they are a bit complex, should I just try repeating them now and it'll solve it, or the procedure should be some different? Here are the options for reference: Compilation info: CC='cc' CFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads' CXX='cc' CXXFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' Configure command: ./configure '--with-comment=FreeBSD port: mysql-server-3.23.49' --with-extra-charsets=complex --enable-thread-safe-client --enable-assembler --with-named-z-libs=no --disable-shared --with-innodb '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r' --prefix=/usr/local/mysql-linux i386-portbld-freebsd4.5 Thank you for any hints on the subject. Regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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: How to compile embedded MySQL on Windows
Tobias Eriksson wrote: > Hi > I am trying to figure out how to compile embedded MySQL on Windows. > I read that one should configure using the --with-embedded-server flag, > but I should also use some script called mysql_config. But I couldn't > find that script, I have downloaded the source for version 4.0, so I > should have all the necessary things. > Please, if someone you lead me in the right directions I would really > appriciate it. > What I am trying to accomplish is to build the libmysql to also enable > the SOCKET PORT facility in an embedded server. Thus I want to run my > application with MySQL embedded and then also allow for connections to > the database from the outside. If you've done something similar please > let me know. > > Regards > Tobias The embedded server does not work with networking enabled. You can only access it via libmysql which talks to it directly. See http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.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: performance tunning 4.x
>
>Hi,
>
>Start by looking at the MySQL documentation:
>http://www.mysql.com/doc/en/Query_Cache.html
>Read the entire 6.9 section.
>
>It offers quite a bit of information on how the cache operates, how
>you should configure it and so on.
>
>
>Regards,
>Iikka
likka,
I read it too but I have a question about the cache, this sentence
in particular.
>>NOTE: The query cache does not return stale data. When data is modified,
any relevant entries in the query cache are flushed. <<
If I have a select statement like:
select col1, col2 from table1 where col1='A'
1) will the cache be flushed if someone changes a non-referenced column for
one of the retrieved rows:
Update table1 set col3 = 'x' where col1='A'
this update changes col3 that falls within the Where of the query but it
affects a column that is not returned by the query.
2) or will the cache be flushed if someone changes a row that falls outside
of the query's Where clause:
insert into table1 (col1, col2, col3) values('D', 'x', 'y');
This last query updates the same table as the select query, but the row
that is added is outside the range of the query's where clause.
So how smart is the cache?
a) Is it smart enough to allow table updates and if the update doesn't
affect the query, will it continue to use the cache? (This requires a lot
of intelligence.)
b) Or will any update to the rows that fall within the range of the query
(regardless of whether the column is in the query) will flush the cache?
c) Or will any update to the table automatically flush the cache?
MONTY:
I would like to see the Explain command to say if it is using the cache or
not (CACHE:Yes/No). This would help developers make better use of the cache
if they know how what affects it.
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
Re: MYSQL Signal 16
Hi, I don't know if this help you too much. Signal 16 is SIGUSR1.In Linux (and Unix) environment are signals which can be used like User Defined Signal. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Adam Sankey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Adam Sankey" <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 4:57 PM Subject: MYSQL Signal 16 > > > > Does anyone know what a signal 16 from a MYSQL thread means ? > > > > 020829 5:56:56 Warning: Got signal 16 from thread 1204584 > > > > thanks > > > > Adam > > - > 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
How to compile embedded MySQL on Windows
Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for version 4.0, so I should have all the necessary things. Please, if someone you lead me in the right directions I would really appriciate it. What I am trying to accomplish is to build the libmysql to also enable the SOCKET PORT facility in an embedded server. Thus I want to run my application with MySQL embedded and then also allow for connections to the database from the outside. If you've done something similar please let me know. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 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
MYSQL Signal 16
> Does anyone know what a signal 16 from a MYSQL thread means ? > > 020829 5:56:56 Warning: Got signal 16 from thread 1204584 > > thanks > > Adam - 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
request for support with mysql_store_result() and mysql_field_count() with vbscript
general outline of situation; my office is moving away from microsoft
(resistance is NOT futile!!! go slashdot!), and establishing web-based
customer service systems.
i'm currently establishing a customer table, that links to a contact table.
each customer will be listed once; to be the customer name and mailing
address, with an auto_increment number serving as the customer number (key
field, cnum).
the contact table will contain specific contact names for each customer,
with specific details such as email address, phone number, extension, title,
etc.
i currently have these tables joined on the customer number (cnum), with a
separate contact number (auto increment, key field, conum) for the contact
table.
what i'm TRYING to figure out is this:
i do a search within the two tables to find contacts for a customer, who has
been selected from a drop-down box. this is matched on the cnum field in
both tables.
currently, if NO contacts exist for a client, the screen remains blank. i
want to generate an option to input contact information in this case. the
logic for this is roughly:
if the search for cnum within contacts yields no result (empty set) then
show "do you wish to input?" screen
else
list contact info
end if
i can't seem to get my head wrapped around the syntactual requirements for
using mysql_store_result() within vbscript.
following is a sample of what i have so far, if it helps. can someone point
me in the right direction?
' Retrieve The Records into Recordset
cnumfind = "select cnum from cust_info where cname = ('" & custname & "');"
Set RS = Con.Execute(cnumfind)
cnv=rs("cnum")
cinfodisp= "select cont_info.cnum, clname, cfname, cname, caddr1, caddr2,
ccity, cst, czip, ccountry, cphone, cext, cfax, cemail from cont_info inner
join cust_info on cust_info.cnum=cont_info.cnum where cust_info.cnum = '" &
cnv & "' and cont_info.cnum=cust_info.cnum;"
set rs2 = con.execute(cinfodisp)%>
Customer Search Results for
<% response.write custname %>
<%
' Loop through the Records to find all cust_info.cnum where cust_info.cname
is what was selected
WHILE NOT RS.EOF
WHILE NOT RS2.EOF%>
<%=rs2("cfname")%><%
response.write " "%> <%=rs2("clname")%>
Address, Line 1: <%=rs2("caddr1")%>
<% if rs2("caddr2") > "" then %>
Address, Line 2: <%=rs2("caddr2")%>
<% end if %>
City: <%=rs2("ccity")%> ST: <%=rs2("cst")%> Zip: <%=rs2("czip")%>
Phone: <%=rs2("cphone")%>
<% if rs2("cext") > "" then %>
Ext: <%=rs2("cext")%>
<% end if %>
<% if rs2("cfax") > "" then %>
<%response.write " "%> Fax: <%=rs2("cfax")%>
<% end if %>
<% if rs2("cemail") > "" then %>
Email: > <%=rs2("cemail")%>
<% end if %>
<%
rs2.MoveNext
wend
rs.movenext
wend
con.close
Set Con = nothing
%>
ANY help would be GREATLY appreciated
angel
IT Services
Trintex Corporation
770-258-5551
[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: delete rules in mysql
Chugh, Thursday, August 29, 2002, 2:18:26 PM, you wrote: CS> Can we use delete rules such as delete on cascade in MySQL CS> or I will have ti handle this on the client side? Yes, you can use ON DELETE CASCADE and ON DELETE SET NULL with InnoDB tables: http://www.mysql.com/doc/en/InnoDB_overview.html ON DELETE CASCADE and ON DELETE SET NULL are supported since 3.23.50: http://www.mysql.com/doc/en/SEC447.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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: Errcode: 13
Liisa, Thursday, August 29, 2002, 3:46:09 PM, you wrote: LK> Description: LK>problem installing MySQL-3.23.52-1 LK> How-To-Repeat: LK> shell> rpm -Uvh MySQL-3.23.52-1.i386.rpm [skip] LK> ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) [skip] It's a permission problem. Check permissions on the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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: load data into table from file or how to set the local-infile=1
It shoul d be running as user mysql . Mertens Bram wrote: >On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: > >>As it says in the documentation, "If the LOCAL keyword is specified, >>the file is read from the client host. If LOCAL is not specified, the >>file must be located on the server." That means that with LOCAL the >>MySQL *client* must be able to access the file, but without LOCAL >>it's the MySQL *server* that needs access. The MySQL server probably >>doesn't (or at least shouldn't) have access to your home directory. >> > >Thx, I read that part but it didn't make much sense to me, but I think >I'm starting to see the light... > >As I read somewhere else in the documentation the mysql-daemon is run as >user nobody who has very little rights. So this user would indeed have >no rights for the specified file. I thought the root user was running >the mysql-daemon and that therefor both the server and client (which are >both running on my desktop computer) would have access to the file. >However according to ps -aux (I'm running mysql on a RH Linux box) the >only processes I see are owned by a user called mysql. > >Perhaps RH changed the username, they change quite a bit in certain >packages so this wouldn't surprise me. > >Anyway, it's working now, it's even making sense to me, so thanks a lot! > >Regards > - 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
Digest, please!
I've read the info file and the non-existant FAQ file so I've done my homework. Yet, I can't seem to get this listserv to accept a digest command; I keep getting bounced. Does mysql list support receiving by digest?? If so, how? Thanks! -Dave - 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: Help please - MySQL 3.23 stability / binary
From: "borracho 138" <[EMAIL PROTECTED]> > Many thanks for the reply - nice to know that I'm not the only one with this > issue(!) > Seems like my problem is related to 2 areas: > - I'm concerned about the lack of memory 'freeing' with the system, but a > kernel upgrade may fix that Don't have this problem i think or if i have it, don't have see for the moment ... > - The other is with the MySQL binary Yep. > Which RPM versions of the RH kernel, gcc and glibc are/were you using? > > Currently my system has: > kernel-2.4.18-3 > gcc-2.96-110 > glibc-2.2.5-36 > glibc-devel-2.2.5-36 > mine : kernel : 2.4.7-10smp gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) using mysql binary from tar.gz. > It looks like I'll try to install gcc-2.95.3 from source and then build > mysql-3.23.52 from that. > Were there are particular build options you used for gcc (and mysql )? > Read doc for build here : http://www.mysql.com/doc/en/Installing_source.html ( all 2.3.xx chapters ) http://www.mysql.com/doc/en/Linux.html You can try too amd athlon optimisation but i don't know if it's working well. NB : i can't downgrade gcc on my server so i'm only using binary distribution of mysql. Perhaps it's not the best solution, i don't know ... 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
Errcode: 13
>Description: problem installing MySQL-3.23.52-1 >How-To-Repeat: shell> rpm -Uvh MySQL-3.23.52-1.i386.rpm MySQL ## Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) 020829 14:44:40 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h eagle password 'new-password' See the manual for more instructions. Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting mysqld daemon with databases from /var/lib/mysql 020829 14:44:40 mysqld ended >Fix: >Submitter-Id: >Originator:admin Local Administrator >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.52 (Official MySQL RPM) >Environment: System: Linux eagle 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -\fno-rtti -mpentium' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1384168 Sep 20 2001 /lib/libc.so.6 -rw-r--r--1 root root 25215580 Sep 20 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 20 2001 /usr/lib/libc.so -rw-r--r--1 root root 856542 Sep 24 2001 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 Oct 29 2001 /usr/lib/libc-client.so -> libc-client.so.2000c -rwxr-xr-x1 root root 718160 Sep 24 2001 /usr/lib/libc-client.so.2000c Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-\db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex\ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/u\sr/share/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -\fno-exceptions -fno-rtti -mpentium' CXX=gcc -- Liisa Koski Bioinformatics Specialist, IT Unit CenixBioScience GmbH Dresden, Germany Tel. +49(351)210-2641 - 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
auto_increment fields
How many auto_increment fields can I have in a database? Thanks ilyas filter:mysql - 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: Connecting to another machine with myCC
Hi, Try another tool named "My Database Manager". You can download the site br.geocities.com/burbello. Greedings Alexander - Original Message - From: "Fred Tsang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 7:38 AM Subject: Connecting to another machine with myCC > Folks, > > I have a question about myCC. I can't connect to a local linux machine (ip > 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using > myCC. I've done the following: > > GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; > FLUSH PRIVILEGES; > > but, in my mysql.log I still get: > > 020816 14:11:18 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > My user table looks like: > mysql> select user,host from user; > ++---+ > | user | host | > ++---+ > | root | 192.168.0.230 | > | fred | 192.168.0.230 | > || lancelot | > | root | lancelot | > || localhost | > | fred | localhost | > | root | localhost | > ++---+ > > What have I done wrong? I know that mysql is up and running and listening > to port 3306. If anyone has an idea, please let me know. > > Cheers, > Fred > > > - > 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 ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.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
CygWin layer into win32 MySQL 4
Hi! I would like to ask you this for my curiosity: into mysql 4.02 win32 it exist a cygwin posix emulation layer, it's used for the client or for the server app? Cygwin emulation layer it's very slow into win32, can you translate cygwin calls into direct win32API's (without cygwin)? TNX Roberto. - 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
delete rules in mysql
Dear All! Can we use delete rules such as delete on cascade in MySQL or I will have ti handle this on the client side? Regards sql, mysql, query - 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: CREATE TABLE adds ZEROFILL
martin, Wednesday, August 28, 2002, 10:12:13 PM, you wrote: m> Description: m> I am porting MySQL to Linux/Alpha. On some occasions m> the CREATE TABLE statement adds ZEROFILL for int(11) m> fields. If you don't know this problem, let me know m> so I can try to fix it. If you know the problem please m> let me know what to do (I don't want to re-invent the m> wheel). m> How-To-Repeat: [skip] m> Fix: m> I did not examine the problem yet. Do you know it or m> do I have to investigate it myself? Hm.. Strange .. I tested your example on 3.23.52 and on 4.0.3 and it worked like a charm .. What options did you use for mysqldump? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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: Re: load data into table from file or how to set the local-infile=1
Mertens, Wednesday, August 28, 2002, 6:52:12 PM, you wrote: MB> On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: >> Put into my.cnf file : >> [mysql] >> local-infile=1 >> >> or start mysql client with --local-infile=1 option. MB> I tried the first option and it works when use the following command to MB> load the data-file: MB> mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE MB> pet; MB> Query OK, 3 rows affected (0.19 sec) MB> Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 MB> But when I use the above command without the LOCAL option it displays MB> the following error: MB> mysql> LOAD DATA INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; MB> ERROR 1045: Access denied for user: 'M8ram@localhost' (Using password: MB> NO) MB> Is this 'normal behaviour'? Yes, if you don't have FILE_priv. If you use LOAD DATA INFILE (without LOCAL), MySQL reads file from server host and user must have FILE_priv. Note: FILE_priv is a global privilege. MB> About the second suggestion: where should this file be located? What file? pet.txt or my.cnf? MB> Is it possible that it does not exist yet? Yes. MB> If so can I create a file named MB> "my.cnf" with a text-editor (like KWrite) and put it in my home MB> directory? Yes, you can create it by yourself. Depends on what options you want to specify in my.cnf you should put this file into /etc/my.cnf or MYSQL_DATADIR/my.cnf or into home_dir/ Read some more info here: http://www.mysql.com/doc/en/Option_files.html MB> Thanks for the help! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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: RE: MS Access and mySQL
Mary, Wednesday, August 28, 2002, 7:49:22 PM, you wrote: MS> see my message re--- index problem MS> ok when I do explain in this , it is not using an index for the MS> AdminCoverage_writingagents table... MS> SELECT admincoverage_writingagents.WritingAgentID, MS> admincoverage_writingagents.WritingAgentSlot, ProducerID, TaxID, MS> (ModalPremium * BillModeID * (PercentOfCase / 100)) AS TotalPaidPremium, MS> AdminCoverage.CoverageID, AdminCoverage.CoverageIDSbc, MS> admincoverage_writingagents.RegionCode, AdminProduct.LobId, MS> AdminCoverage.StatusID, AdminCoverage.StatusDate, MS> AdminCoverage.InitialPremiumDate, MS> AdminCoverage.PaidToDate, GROUPID FROM admincoverage_writingagents MS> INNER JOIN AdminCoverage ON MS> admincoverage_writingagents.CoverageID=AdminCoverage.CoverageID MS> AND admincoverage_writingagents.CoverageIDSbc=AdminCoverage.CoverageIDSbc MS> LEFT JOIN AdminProducer ON MS> AdminProducer.ProducerID=admincoverage_writingagents.WritingAgentID MS> LEFT JOIN AdminProduct ON AdminCoverage.ProductID=AdminProduct.ProductID MS> WHERE AdminCoverage.InitialPremiumDate >= '2101' AND MS> AdminCoverage.InitialPremiumDate <= '20020701' MS> AND TaxID='003349715' ORDER BY MS> admincoverage_writingagents.WritingAgentSlot,AdminCoverage.CoverageId, MS> AdminCoverage.CoverageIdSbc MS> ,ProducerID MS> table in question has 900,000 records MS> CREATE TABLE admincoverage_writingagents ( MS> Source char(1) NOT NULL , MS> CoverageId char(15) NOT NULL , MS> CoverageIdSbc char(10) NOT NULL , MS> WritingAgentSlot int(11) , MS> WritingAgentId char(15) NOT NULL , MS> PercentOfCase double , MS> RadDistributionCode char(5) , MS> RegionCode char(5) , MS> LobId char(15), MS> KEY coverageid (CoverageId), MS> KEY coverageidsbc (CoverageIdSbc), MS> KEY coverageidandsbc (CoverageId, CoverageIdSbc), MS> KEY writingagentid (WritingAgentId), MS> KEY writingagentslot (WritingAgentSlot) MS> ); Mary, could you provide output of EXPLAIN SELECT? What is the structure of other tables? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
Connecting to another machine with myCC
Folks, I have a question about myCC. I can't connect to a local linux machine (ip 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using myCC. I've done the following: GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; FLUSH PRIVILEGES; but, in my mysql.log I still get: 020816 14:11:18 6 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) My user table looks like: mysql> select user,host from user; ++---+ | user | host | ++---+ | root | 192.168.0.230 | | fred | 192.168.0.230 | || lancelot | | root | lancelot | || localhost | | fred | localhost | | root | localhost | ++---+ What have I done wrong? I know that mysql is up and running and listening to port 3306. If anyone has an idea, please let me know. Cheers, Fred - 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: Help please - MySQL 3.23 stability / binary
From: "borracho 138" <[EMAIL PROTECTED]> > I've searched for more information on these issues, without luck. > > The system randomly spirals out of control - load avg increases very > rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the > server is fine, handling the busiest loads. > It doen't appear to be using any swap space at all (0K) - the 'mysqld' > process size gradually has grown to the point where no free RAM was > available and 'spiralled' , but that isn't the general case. > Restarting MySQL cures the problem, although system memory isn't being > reclaimed (see below) > > I also have a memory related problem - the system doesn't free memory when > MySQL is stopped and started. (I suspect this may be a kernel related issue) > RH have released a kernel update 2.4.18-10, which apparently fixes a problem > with the filesystem cache - could this be related? (Again, I've been unable > to find more information on the subject) > > As a result I'm tempted to try a compiled version (all tests ran fine, as > did MySQL 3.22 in the past) > Is a stability/corruption free MySQL guaranteed using gcc 2.95.3? > Several users ( like me ) have reported load problem using 3.23.51 and 3.23.52 linux binary version of mysql. Something wrong with the glibc used by mysql AB i think ... The only cure that works for me is not to use 3.23.51 and 3.23.52 binary until that a new stable one will be released or building his own binary ... 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: granting grant option creates a (new) user ?!
Markus Reger wrote: >MySQL > >: it seems that a user who has grant privilege can grant access to a(his) database to >another user although this other user doen't exist - in this case the other user is >newly created! can cause a mess in your usertable when you have a site with some >databases to administer > Sounds evil indeed, how about giving grant rights and revoking insert rights for mysql.users mysql.db and mysql.table? Greetings Ralf > > -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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
Help please - MySQL 3.23 stability / binary
Hi, I'm using: Tyan m/b, 2x U160 scsi disks, dual Athlon MP CPUs, 2Gb RAM + 2GB swap RH 7.3, 2.4.18-5smp kernel MySQL 3.23.51 (MySQL Linux tar.gz) binary used based on the comments on the download page about gcc 2.96 compiled versions resulting table corruptions, etc. I have a couple of questions: Does anyone have any more information about gcc 2.96 on the x86 Linux platform? Has anyone been able to duplicate the problems themselves or understand their exact cause? Is the binary optimised for SMP systems? I've searched for more information on these issues, without luck. The system randomly spirals out of control - load avg increases very rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the server is fine, handling the busiest loads. It doen't appear to be using any swap space at all (0K) - the 'mysqld' process size gradually has grown to the point where no free RAM was available and 'spiralled' , but that isn't the general case. Restarting MySQL cures the problem, although system memory isn't being reclaimed (see below) I also have a memory related problem - the system doesn't free memory when MySQL is stopped and started. (I suspect this may be a kernel related issue) RH have released a kernel update 2.4.18-10, which apparently fixes a problem with the filesystem cache - could this be related? (Again, I've been unable to find more information on the subject) As a result I'm tempted to try a compiled version (all tests ran fine, as did MySQL 3.22 in the past) Is a stability/corruption free MySQL guaranteed using gcc 2.95.3? Thanks to everyone in advance bill - 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
granting grant option creates a (new) user ?!
MySQL : it seems that a user who has grant privilege can grant access to a(his) database to :another user although this other user doen't exist - in this case the other user is :newly created! can cause a mess in your usertable when you have a site with some :databases to administer - 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 4.0 on Debian
Hello On Thu, 1 Aug 2002, Quinten Steenhuis wrote: > Has anyone successfully gotten MySQL 4.02 running on Debian? I'm > running into problems if I use alien to convert the RPMs. Yep, we're using 4.0.2 on Debian. You may want to grab MySQL .tar.gz instead of .rpm and install it somewhere into /usr/local. Then you should get no conflicts with whatsoever, and the PHP stuff might Just Work(TM). If not, you can try to reconcile new locations of the MySQL socket file in php.ini or my.cnf files, etc. (As I'm compiling PHP myself, I'm not really exactly in your situation.) Tibor - 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
Compiling DLL on windows: undefined reference errors during linking?
I have addressed this problem in the thread "Re: developing clients in C with Dev-C++" on [EMAIL PROTECTED] Tor Erling Unander Trondheim, Norway == I am trying to compile a file on windows and build a DLL, this has worked before using MSVC5.0 but now I'm using cygwin/mingw environment. Does anyone know the problem/solution? I have also tried building with mysqlclient.lib but get different error messages. I have checked various newsgroups and search engines for answers, can't find a solution yet. $ gcc -Wall -DWINDOWS -Ic:/tcl/include -Ic:/mysql/include fbsql.c -shared -o fbsql.dll - Lc:/tcl/lib -ltcl83 -Lc:/mysql/lib/opt -lwsock32 -llibmysql -lz c:\windows\TEMP\ccxgTZfb.o(.text+0x3a):fbsql.c: undefined reference to `mysql_error@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x67):fbsql.c: undefined reference to `mysql_errno@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x1be):fbsql.c: undefined reference to `mysql_connect@16' c:\windows\TEMP\ccxgTZfb.o(.text+0x2af):fbsql.c: undefined reference to `mysql_close@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x447):fbsql.c: undefined reference to `mysql_select_db@8' c:\windows\TEMP\ccxgTZfb.o(.text+0x6f3):fbsql.c: undefined reference to `mysql_query@8' c:\windows\TEMP\ccxgTZfb.o(.text+0x743):fbsql.c: undefined reference to `mysql_use_result@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x772):fbsql.c: undefined reference to `mysql_field_count@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x7cf):fbsql.c: undefined reference to `mysql_affected_rows@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x828):fbsql.c: undefined reference to `mysql_fetch_row@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x920):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x953):fbsql.c: undefined reference to `mysql_free_result@4' c:\windows\TEMP\ccxgTZfb.o(.text+0xd8f):fbsql.c: undefined reference to `mysql_query@8' c:\windows\TEMP\ccxgTZfb.o(.text+0xde5):fbsql.c: undefined reference to `mysql_use_result@4' c:\windows\TEMP\ccxgTZfb.o(.text+0xe37):fbsql.c: undefined reference to `mysql_store_result@4' c:\windows\TEMP\ccxgTZfb.o(.text+0xe85):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccxgTZfb.o(.text+0xed3):fbsql.c: undefined reference to `mysql_field_count@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x10a9):fbsql.c: undefined reference to `mysql_fetch_row@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x11a1):fbsql.c: undefined reference to `mysql_fetch_field_direct@8' c:\windows\TEMP\ccxgTZfb.o(.text+0x1381):fbsql.c: undefined reference to `mysql_fetch_field_direct@8' c:\windows\TEMP\ccxgTZfb.o(.text+0x17ad):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccxgTZfb.o(.text+0x17fd):fbsql.c: undefined reference to `mysql_free_result@4' Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - 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 Installing mysql-3.23.52
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 28 August 2002 22:53, Carlos Oyarzún wrote: > I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m > using the following procedure: > > ./configure --prefix=/usr/local/mysql > make > make install > > The first two commands run fine, but "run install" gives me the following > error, > > make[2]: *** [install-benchSCRIPTS] Error 1 > make[2]: Leaving directory `/usr/local/mysql/sql-bench' > make[1]: *** [install-am] Error 2 > make[1]: Leaving directory `/usr/local/mysql/sql-bench' > make: *** [install-recursive] Error 1 > > Does anyone know what the problem is? Actually, the interesting error messages are a bit above the snippet you posted. These ones alone do not give any clues... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany <___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bd8sSVDhKrJykfIRApMJAJ9QsyJUD0CFp92kDzWcHhPPy0ydpACfeLuc XRb9jMRCZReHM5TUYR2GWUI= =KI/R -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
database migration
HI, I would like to know if there is a program/script that can migrate data from sybase ASE server to MySQL ??? Just tables - lots and lots of tables (about 12GB of data !!!) Many Thanks Tonino - 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 for handler_read value
On Tue, Aug 27, 2002 at 05:40:48PM -0400, Marc Prewitt wrote: > I'm trying to put together some statistics on our queries and am wondering > what percentage of our queries involve a full table scan. The variable > which kind of tracks this is Handler_read_rnd_next. However, since a > query may cause multiple Handler_read_rnd_next events to occur to get all > of it's data, I can't directly compare this to the Questions variable. > > However, if I knew how many total Handler_read requests are happening, I > could compare that to Handler_read_rnd_next to get the kind of information > I want. > > However, there is no Handler_read variable. > > Question: is Handler_read = Handler_read_first + Handler_read_key + > Handler_read_next + Handler_read_prev + Handler_read_rnd_next? There's also a _read_last counter. It's not yet exposed in SHOW STATUS, but it's there. Hmm. Wonder if that's a simple bug or not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 22 days, processed 469,822,571 queries (236/sec. avg) - 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: mysqlhotcopy problem - Segmentation fault
On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: > I have strange problem - I get Segmentation fault error when I am trying to > execute mysqlhotcopy. > > When I remove the [mysqlhotcopy] section in my /etc/my.cnf > configuration it works. Meanwhile, on another server it works just > fine with the same configuration file. Do both servers have the same MySQL version installed? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 22 days, processed 469,104,809 queries (236/sec. avg) - 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
