Re: upgrade from mysql 3.23 to 4.1

2004-11-29 Thread Greg Macek
m mysql.com for going from 3.23 to 4.0 and 4.0 to 4.1. I was hoping not to have to re-create the databases as the original poster mentioned, but I don't have a slave DB setup either. Will this be an issue? Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

2004-11-04 Thread Greg Wiggill
mysqld_safe --d mysql 767 725 0 Oct29 ?00:10:44 /usr/sbin/mysqld --basedir=/ --d root 10902 10556 0 11:42 pts/000:00:00 grep mysql must be missing some basic steps? thanks Greg # This em

Re: Reg Backup

2004-10-04 Thread Greg Donald
copy being a Perl script and all. Feel free to try it and discover the definative answer for yourself. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Re: Reg Backup

2004-10-04 Thread Greg Donald
On Mon, 4 Oct 2004 21:55:58 +0530, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Is there any suitable command in MySQL 4.0 with out InnoDB for taking the > backup. Please suggest. Have you looked at mysqlhotcopy ? http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html -- Greg

Re: Problems with Left Join query

2004-09-17 Thread Greg Donald
might find this of use: http://pear.php.net/package/LiveUser -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to limit log space usage?

2004-09-17 Thread Alex Greg
Nico Sabbi wrote: [...] There are 3 GB of logs that no one needs anymore. Since the master knows that all the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't it automatically remove the logs up to that position? The problem here is that MySQL masters aren't necessarily aware of

Re: Global privileges - everyone has them!!!

2004-09-16 Thread Greg Donald
re is a Y under all for root). I have searched the > documentation and can't figure out where I have gone wrong here. > > In the db table, there is one entry for one user (not root). There are no > entries in the host table. > > I would appreciate any help you can give me!

Re: root-password important?

2004-09-15 Thread Greg Donald
a server? I don't believe there is any way to elevate permissions for a given MySQL login once logged in, no. -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: root-password important?

2004-09-15 Thread Greg Donald
ssions for each database. Unless it's a dev server behind a firewall or something like that I tend to be pretty restrictive. -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql and PHP

2004-09-15 Thread Greg Donald
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote: > Did you build both php and apache with MySQL support? I wasn't aware you could build Apache with MySQL support. How is that done? -- Greg Donald http://gdconsultants.com/ http://destiney.com/ --

Re: Mysql and PHP

2004-09-15 Thread Greg Donald
see > Mysql. Now I have done this installation 4 or 5 times but th elast time > was over a year ago. > > Any ideas? Perhaps this will help: http://www.wampserver.com/en/faq.php#q5 -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- MySQL General Mailin

Re: Query error need help please

2004-09-14 Thread Greg Donald
s? > Thanks so much. This is fixed in the latest version: http://sourceforge.net/projects/destiney/ If not, let me know and I'll look into it. I'm still maintaining the 0.3 series. -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://li

Re: problem installing without the server

2004-09-13 Thread Alex Greg
Juan Fernandez wrote: I see 3 packges: Mod_auto_mysql-20030510-3.i386.rpm Mysql-3.23.58-4.i386.rpm Php-mysql. Which one to pick Thanks !! Mysql-3.23.58-4.i386.rpm -- Alex -Original Message- From: Alex Greg [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 4:06 PM To: Juan

Re: problem installing without the server

2004-09-13 Thread Alex Greg
Juan Fernandez wrote: Hi !! I am trying to install mysql without the server on fedora: when I issue the command : [EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52 [EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server --prefix=/usr/local/mysql everything is fine but after I issue the com

"Duplicate entry" breaks replication

2004-09-02 Thread Alex Greg
Hi, We recently moved to new servers, and also upgraded from MySQL 3.23 to 4.0.20. We have one master database server and a second identical machine configured to replicate all databases from the master. Previously this has worked without a hitch, but we seem to be having some problems. The wa

Re: bad "too many connections" error (os x)

2004-09-01 Thread Alex Greg
Michael Winston wrote: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connec

RE: MySQL Secure Connection(e.g. SSL) Question

2004-08-26 Thread Greg . Cope
Ah I did not know that. Excellent. Still does not get round the issue that MySQL in most default binary distributions does not include SSL. Which I think is a shame, but then again is probably a lib issue. Thanks for that. Greg > -Original Message- > From: Eamon Daly [mailto:

RE: MySQL Secure Connection(e.g. SSL) Question

2004-08-24 Thread Greg . Cope
that DBD::mysql cannot use SSL'ed mysql client connections and your remote server would have to be complied to support it. Greg > > Thank You > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:

Can't connect to MySQL server - Operation now in progress

2004-08-19 Thread Alex Greg
Hi, I'm noticing this error in various script of ours that run on the cron: DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...) failed: Can't connect to MySQL server on '10.1.1.80' (115) at /usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214 This happens on a number of our

RE: time out factor ofMySQL

2004-08-09 Thread Greg . Cope
of MySQL. Search the manual for timeout - interactive_timeout seems to be the thing you need to change. Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

help with complex query please (corrected)

2004-07-27 Thread Greg Sloman
| ... TABLE images | id | artistname | featured | ... | 1 | Name1 | Y| ... | 2 | Name2 | Y| ... | 3 | Name3 | Y| ... | 4 | Name4 | Y| ... | 5 | Name5 | Y| ... Thanks in advance. Greg Sloman

help with complex query please

2004-07-27 Thread Greg Sloman
TABLE images | id | artistname | featured | ... | 1 | Name1 | Y| ... | 2 | Name2 | Y| ... | 3 | Name3 | Y| ... | 4 | Name4 | Y| ... | 5 | Name5 | Y| ... Thanks in advance. Greg Sloman

Drivers to use with VB6

2004-07-07 Thread Greg Zimmermack
experiences. Thanks Greg _ Get tips for maintaining your PC, notebook accessories and reviews in Technology 101. http://special.msn.com/tech/technology101.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL and VBquestion - problem with query that returns 100000+ records

2004-07-01 Thread Greg Zimmermack
r MS Access, it is definitely failing on the performance front and thats a shame. I am also going to try your modified query and will post the results of the EXPLAIN soon. Thanks a lot for all your help; Greg From: [EMAIL PROTECTED] To: "Greg Zimmermack" <[EMAIL PROTECTED]> Su

RE: MySQL and VBquestion - problem with query that returns 100000+ records

2004-06-30 Thread Greg Zimmermack
should be looking at? The error handler in in VB could not handle the error. Is there some ODBC setting I need to optimize? Any help will be appreciated. Thanks Greg From: Victor Pendleton <[EMAIL PROTECTED]> To: 'Greg Zimmermack ' <[EMAIL PROTECTED]>,"'[EMAIL PROT

MySQL and VBquestion - problem with query that returns 100000+ records

2004-06-30 Thread Greg Zimmermack
ecords from it. Any help will be greatly appreciated. Thanks Greg _ Get fast, reliable Internet access with MSN 9 Dial-up – now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/ -- MySQL General Mailing List For

Converting table types

2004-06-09 Thread Greg Macek
ocation changes with this. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: Comma Delimited Import Error

2004-06-07 Thread Greg Willits
239,,"Grenada" If the field that lines up with the field between ,, does not allow NULL, then an error will occur. Either redefine the field to allow NULL, or use regex on that file to convert ,, to ,"", or ,0, as appropriate. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

API Changes from 4.0 to 4.1?

2004-06-02 Thread Greg Willits
aybe this is a question better suited to the PlusPlus list? -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
On Jun 1, 2004, at 5:04 PM, Greg Willits wrote: So, - G4/OS X Server: 4.0.20 installs fine, but 4.2.1 does not on 10.3.4 - G3/OS X Standard: 4.2.1 installs fine on 10.3.2, but after 10.3.4 Standard was installed, 4.2.1 did not work, yet 4.0.20 continues to install fine The fact that 4.0.20 will

Short Passwords in 4.1.2

2004-06-01 Thread Greg Willits
ord columns as binary but 4.1.2 does not? - Can 4.1.2 be forced to used old passwords this way? Do I need to modify the startup script to include --old-passwords? -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
" that installation. The installer reset the user to system on variouis folders, and still wouldn't install all the table files in the mysql database. This was all done with the OS X Installer package. I guess I'll try the non-Installer version and see what happens. Should

New 4.1.2 Startup Trouble

2004-06-01 Thread Greg Willits
down Complete 040601 11:50:23 mysqld ended Can't figure out which permission is failing. I've looked at folder and file perms of the startup script and they match those on systems with 4.0 that are working. Same with the /data directory. Baffled. -- greg willits -- MySQL Gener

Re: Are Views Supported?

2004-05-27 Thread Greg Willits
On May 27, 2004, at 11:16 PM, Jake Johnson wrote: I was wondering when or will views be supported? http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Why is MySQL.com using MnoGoSearch for searching its site???

2004-05-27 Thread Greg Willits
contain many static components not contained in a MySQL database that the FullText search would never see. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: cannot get into mysql console

2004-05-25 Thread Greg Willits
mysql/en/Connecting-disconnecting.html http://dev.mysql.com/doc/mysql/en/Default_privileges.html http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing to Substitute Text for Refc Codes

2004-05-25 Thread Greg Willits
-- gw On May 24, 2004, at 5:12 PM, Greg Willits wrote: Struggling with a query structure new to me... Most of my apps are not very complex at all (simple joins, few functions), but I've worked through a few "tricky" queries. However, this one is stumping me on how to even begin. I ca

SELECTing to Substitute Text for Refc Codes

2004-05-24 Thread Greg Willits
ompatible with 3.23.54. (when 4.1 hits beta then I will likely switch to it for this particular app as I need sub-selects for another task). All clues welcomed. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing on OS X without installer

2004-05-23 Thread Greg Willits
t. There's been an installer one for a while now, and on is still listed here for OS X: http://dev.mysql.com/downloads/mysql/4.0.html -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mac Developer Question

2004-05-22 Thread Greg Willits
the embedded version of MySQL which is aimed exactly at these purposes. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: HTML in MySQL Tables

2004-05-21 Thread Greg Willits
ne's first CSS era, but try to get past that level quickly. I finally hit what I call my third era in CSS this past year, and man, does it make web design so much better. Anyway, quite off topic, so, if you have some questions, hit me up offline. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld sock conflicts

2004-05-21 Thread Greg Willits
Greg Willits wrote: On May 20, 2004, at 11:08 AM, Sasha Pachev wrote: Greg Willits wrote: I have two mysql apps running on the same machine (OS X 10.3.3). A mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a config file specifying the port and a unique socket name in /tmp. They

Large sample data sets for testing

2004-05-21 Thread Greg Willits
ocated a big (to me) data set to play with. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Encryption

2004-05-21 Thread Greg Willits
of SSL provided by the underlying OpenSSL implementation of your system http://dev.mysql.com/doc/mysql/en/Secure_connections.html I haven't used it myself, just read about it. Use the search field on that page to find other sections in the docs. -- greg willits -- MySQL General Mailing Li

Re: Encryption

2004-05-21 Thread Greg Willits
On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote: What level of Encryption does MySQL have? I cannot find much security information from mysql.com. http://dev.mysql.com/doc/mysql/en/Encryption_functions.html -- greg willits -- MySQL General Mailing List For list archives: http

Re: BLOB's - General Guidance

2004-05-20 Thread Greg Willits
at scale would affect the perceived and real limits and hassles of one method vs another, and flip-flop strengths & weaknesses. Thx. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld sock conflicts

2004-05-20 Thread Greg Willits
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote: Greg Willits wrote: I have two mysql apps running on the same machine (OS X 10.3.3). A mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a config file specifying the port and a unique socket name in /tmp. They have coexisted just

Re: BLOB's - General Guidance

2004-05-19 Thread Greg Willits
uot; height="75" /> If I then create a series of images in a folder named landscapes - or nature/landscapes - then I would use PHP to replace WHAT with nature/landspaces. Yep. That can be done in the db or in a univeral config file your middleware reads depending on what makes the most sense. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: BLOB's - General Guidance

2004-05-19 Thread Greg Willits
#x27;s legit uses for storing web resources in BLOBs, but so far I've never seen an advantage over use server config and the web app itself (not that I've made any monster apps mind you, all of mine have been simple enough for single or dual server setup). -- greg willits -- MySQL Gen

Re: BLOB's - General Guidance

2004-05-19 Thread Greg Willits
, store a filename &/or location in the db if necessary, and use your middleware to display the images. Its faster, easier to maintain, and easier to backup. IMO, storing images in the db just bloats the file and complicates all the backup issues. -- greg willits -- MySQL General Mailing Li

mysqld sock conflicts

2004-05-19 Thread Greg Willits
has something to do with this? I have no idea what could have changed "all of a sudden" and "on its own." Thanks for any clues. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld sock fights between two servers

2004-05-17 Thread Greg Willits
et related config file somewhere that has something to do with this? I have no idea what could have changed "all of a sudden" and "on its own." Thanks for any clues. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Is it possible to get a timestamp from the server ?

2004-04-23 Thread Greg Hosler
server. In the past, under Informix, we did the following sql: SELECT distinct current year to second FROM systables I've looked around, and I'm not seeing anything equivalent under MySQL. Have I hopefully missed something ? thx for any suggestions / hints / pointers. best rg

ANN:www.SQL-Scripts.Com

2004-04-19 Thread Greg
Sorry no subject on the last email Hello, Announcing the release of a new web site : www.SQL-Scripts.com At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many different database system. Using our search system you can find scripts that you need quickly and simply. If you have

Re: www.SQL-Scripts.com web site

2004-04-19 Thread Greg
Hello, Announcing the release of a new web site : www.SQL-Scripts.com At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many different database system. Using our search system you can find scripts that you need quickly and simply. If you have scripts that you use why not lodge

Re: Database recovery

2004-04-07 Thread Alex Greg
> Hi, > > I have recently had a system crash that required the > installation of a new hard drive. I have access to the > files on the old hard drive, on which is a database I > need to recover. > > I am running MySql 3.23.37 and all the tables in the > database to be recovered are MyISAM. > > How

Re: Maximum Database size

2004-03-12 Thread Alex Greg
> Stefan, > > it depends ... > > For MyISAM tables max size is limited by the maximum filesize of your > OS/Filesystem. Following on from that, the maximum file size you can have on 32-bit Linux is 2GB, unless your distro has LFS (Large File Support), in which case is is much larger (terabytes, n

Re: Newbie - dependencies

2004-03-11 Thread Alex Greg
> > > Having just set up a RedHat Enterprise Server V.3 I am trying to add a > > MySQL database function. I tried and failed using up2date (following > > instructions from RH), so downloaded the rpms and began to install by > > myself. My input and the output is shown below: > > > > # rpm -i

Re: Newbie - dependencies

2004-03-11 Thread Alex Greg
> Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL > database function. I tried and failed using up2date (following instructions > from RH), so downloaded the rpms and began to install by myself. My input > and the output is shown below: > > # rpm -i mysql-server-3.23

Re: Hitting max_connections - safe to raise this?

2004-03-08 Thread Alex Greg
> Alex Greg wrote: > > Hi, > > > > > > Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI > > RAID-5 made up of 3 36GB disks. It does between 300 and > > 1200 queries per second. The read to write ratio is about 4:1. > >

Hitting max_connections - safe to raise this?

2004-03-03 Thread Alex Greg
Hi, Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5 made up of 3 36GB disks. It does between 300 and 1200 queries per second. The read to write ratio is about 4:1. My problem is that we're hitting our max_connections more and more frequently. Is it safe to

Re: Remove a RPM Installation

2004-03-02 Thread Alex Greg
> Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to > install MySQL, but how can I delete it. rpm -e MySQL-server-4.1.1-1.i386 -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

MySQL load balancing

2004-02-25 Thread Alex Greg
this isn't an option. Any advice on this would be appreciated. Alex Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Which is MySQL optimised for - BETWEEN or AND?

2004-02-19 Thread Alex Greg
Hi, I have a select query which is selecting all records in a table (which has around 8,000,000 rows in). "time" is a field of type "time". Should I be using <= and >= or BETWEEN to find records in a certain range? Which does MySQL optimise for? select time,price from csq where id = 12345 and da

Re: Installation Problem - PLEASE HELP

2004-02-18 Thread Alex Greg
> Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': > > ld: fatal: library -lz: not found > ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 > make[2]: *** [libmysqlclient.la] Error 1 > make[2]: Leaving direct

Re: Where is my typo?

2004-02-18 Thread Alex Greg
> I try to grand some rights by using GRAND You want GRANT, not GRAND. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Restore And Dump

2004-02-16 Thread Alex Greg
> Hello, > > I am running two instances of mysql. They both run on different boxes, not networked. > > Anyway, I have been developing on one machine, and trying to do a dump and keep the other box updated with Database changes. > > I have ran this from the dev box. > mysqldump --add-drop-table -u d

Re: Enabling Mysql in php

2004-02-16 Thread Alex Greg
> Hi. > I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql 3.23.36, both installed on linux RH 7.3. Install the php-mysql RPM. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT

RE: MySQL Administrator certain options only valid at localhost

2004-02-13 Thread Greg . Cope
. The scheduled bit of this is blank on mine so I assume that this is a bug as it should display the "Local host only" message. Greg > -Original Message- > From: Iago Sineiro [mailto:[EMAIL PROTECTED] > Sent: 13 February 2004 12:10 > To: MySql Mail List > Sub

Re: MySQL RPM Upgrade

2004-02-12 Thread Alex Greg
> Thx' Alex. > > do the old RPM's need to be removed first before upgrading ?? You can just do: rpm -Uvh MySQL-* in the directory with the new RPM's in - this will overwrite the old packages with the new ones. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Second mysqld fails...

2004-02-12 Thread Greg G
The .err file in var2 says: 040212 09:30:23 mysqld started /usr/local/mysql4017/libexec/mysqld Ver 4.0.17 for sun-solaris2.7 on sparc (Source distribution) 040212 09:30:24 mysqld ended That's it. -Greg g [EMAIL PROTECTED] wrote: What message is being logged to the error log? Ori

Re: MySQL RPM Upgrade

2004-02-12 Thread Alex Greg
> Hello, > > we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and > would like to upgrade. the current RPM's installed are: > > MySQL-client-4.0.15-0 > MySQL-embedded-4.0.15-0 > MySQL-devel-4.0.15-0 > MySQL-shared-compat-4.0.15-0 > MySQL-shared-4.0.15-0 > MySQL-server-4.0.

Second mysqld fails...

2004-02-12 Thread Greg G
be doing wrong here? The my.cnf just has some ssl certificates in it, and nothing else. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Memory Leak using InnoDB ?

2004-02-06 Thread Greg Day
Geoffrey wrote: Hi, I'm running MySQL 4.0.17 with RH Linux 8 on Xeon 3.0/1GB RAM. One application has to access the database (1 connection to the DB is open on startup and left open). However this application performs a lot of queries on the DB. Main InnoDB table : 50.000 Rows Other InnoDB table

Re: select on set yields exponential notation

2004-02-06 Thread Greg Vines
cast(var2 as unsigned) | > +--++ > |1 |562949953421312 | > |1 | 1 | > |1 | 32768 | > +--++ > 3 rows in set (0.00 sec) > > Note I add a row with "1" and another with "16"

Re: select on set yields exponential notation

2004-02-06 Thread Greg Vines
. Do you know if there is a way to set the number of characters in a numeric response? On Fri, 2004-02-06 at 12:54, Michael Stassen wrote: > Why are you adding 0? Try this: > >SELECT var1, var2 FROM test1; > > Michael > > Greg Vines wrote: > > > I'm t

select on set yields exponential notation

2004-02-06 Thread Greg Vines
quot;,"43","44","45","46","47","48","49","40", "51","52","53","54","55","56","57","58","59","60") ); Add a row: insert into test1 values (1, "40"); Then select & oops: select var1,var2+0 from test1; +--+-+ | var1 | var2+0 | +--+-+ |1 | 5.6294995342131e+14 | +--+-+ How can I get this output as an integer? I've tried both MySQL 3.23 and 4.0.17 with the same result. I'm running on linux (RHL 8.0) Thanks - Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: compiling mysql with ssl

2004-01-09 Thread Greg G
You'll want this: --with-openssl-libs=/usr/local/ssl/lib (not /usr/lib) -Greg G Cion Chen wrote: I have Redhat 9 with openssl-0.9.7a-20 tring to re-compiling mysql-4.0.17 again with the options: ./configure --with-openssl --with-openssl-includes=/usr/include/openssl --wi th-openssl-libs

Re: compiling mysql with ssl

2004-01-07 Thread Greg G
nssl seems to confuse configure. You also don't want to specify the particular .a file, just the directory. -Greg G Cion Chen wrote: Hi! I have some trouble tring to compile Mysql 4.0.17 with de options: --with-vio & --with-openssl, I try with some recomedation about it but

Get counts of col=value with an GROUP BY clause?

2004-01-05 Thread Greg Owen
o this, or should I just make a bunch of different queries and glue it all together on the other side? Any help is appreciated. I'm decent at basic SQL but this is pushing into an area I'm unfamiliar with, so if you can just point me toward the answer I can probably teach myself, but

Re: 4.0.17 - Still no SSL joy

2003-12-26 Thread Greg G
That's a good workaround, but I'd definately like to see that get fixed at some point. -Greg G [EMAIL PROTECTED] wrote: I shouldn't need to make a symlink in /usr/local/include. That may be the case, but the only way you will satisfy the #include in the my_global.h file is

4017 - make test fails

2003-12-26 Thread Greg G
This is 4.0.1.7 and it happens on both Solaris and Mandrake. This is just after finishing a make. Should this work at this stage, even? -Greg G # make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no

Re: 4.0.17 - Still no SSL joy

2003-12-26 Thread Greg G
I should have posted this, but I did this: $ ./configure --with-openssl --with-openssl-includes=/usr/local/ssl/include --with-openssl-libs=/usr/local/ssl/lib --with-vio --prefix=/usr/local/mysql4017 I shouldn't need to make a symlink in /usr/local/include. -Greg G [EMAIL PROTECTED]

4.0.17 - Still no SSL joy

2003-12-26 Thread Greg G
such file or directory make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-4.0.17/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-4.0.17' make: *** [all] Error 2 -Greg G -- MySQL General Mailing List For list archives: htt

Re: MySQL with SSL enabled

2003-12-17 Thread Greg G
know if you manage to get SSL working during the compile phase. I found an open bug ( http://bugs.mysql.com/bug.php?id=1915 ) which pretty much indicates that you're not going to be able to build in SSL support. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysq

Re: [RE-REPOST] Openssl support not activated?

2003-12-12 Thread Greg G
had to do the same thing in the dbug, mysys, extra, regex, isam, merge, innobase/*... I gave up after a few of these. Any ideas where to go from here? This is for mysql 4.0.16, openssl 0.9.7c and gcc 2.95.4 on a Debian linux box (2.2.20). Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [RE-REPOST] Openssl support not activated?

2003-12-11 Thread Greg G
7;s probably the problem. :) However, I didn't get any messages when running configure. I've even specified --with-openssl-include and --with-openssl-lib since the --with-openssl directory doesn't seem to be getting using to determine those directories. I'm not sure what's happening. I have a lot of trouble debugging configure. -Greg G

Re: [RE-REPOST] Openssl support not activated?

2003-12-11 Thread Greg G
Mark Matthews wrote: Greg G wrote: I'm still having trouble figuring this out. Please help! I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the variables with mysqladmin, "has_openssl" is set to "NO". I've got OpenSSL 0.9.7c installed. I

[RE-REPOST] Openssl support not activated?

2003-12-10 Thread Greg G
d Debian hosts. I'm not seeing any errors during the configure or compile phases. What could have happened to cause this, and how can I fix it? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is mySQL right for me??

2003-12-08 Thread GREG BARBER
on of queries that are then arranged on the output page according to preset positioning instructions. Regards Greg MAIL IS CONFIDENTIAL. If you have received this e-mail in error, please notify us by return e-mail and delete the document. If you are not the intended recipient you are hereby not

[REPOST] Openssl support not activated?

2003-12-08 Thread Greg G
gure or compile phases. What could have happened to cause this, and how can I fix it? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

with-openssl failing?

2003-12-05 Thread Greg G
x27;m not seeing any errors during the configure or compile phases. Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Openssl support?

2003-12-04 Thread Greg G
I realized that I should probably mention that I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have

Openssl support?

2003-12-04 Thread Greg G
I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Openssl support?

2003-12-04 Thread Greg G
I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

4.0.16 doesn't like my Berkley DB version!

2003-12-03 Thread Greg G
The configure script appears to really be checking for 3.2.9, in any case. I'm going to override this for now, but I wanted to know if that's going to cause problems down the road. Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com

Debug options for mysqlimport?

2003-12-02 Thread Greg G
looking for is to get the text of warnings that were generated during and import. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Help

2003-12-02 Thread Greg Jones
l Front gives me the following error: 'You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select l2.ltsysid from lientrak as l2 where l2.lientraknum like' I am running MySQL Front version 2.5, and MySql version 4.0.15. Thanks, Greg

mysql/radius populate db question

2003-11-28 Thread Greg G
CT on RADIUS.attrib to radius@'%';) What I don't understand is how I was able to do it from the command line but it's not working from the perl script? Any advice? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Space efficiency for values repeated across rows

2003-10-24 Thread Greg Kuperberg
and scalability. I don't think that I could make do with just a simple wrapper for MySQL's full-text search. Maybe I could exploit the full-text search function for the narrow problem of finding a connected phrase. It would be nice to know the data structures and algorithms for the full-text

<    1   2   3   4   >