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:

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]

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

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
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: 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-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: 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: 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

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: 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

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: 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: 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]

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: 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

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: 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: 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

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

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

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:

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

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]

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]

SET Conversion Questions

2002-02-20 Thread Greg Willits
SET selections are redefined? The reason behind the previous setup was to allow easy changes to the selection list and isolate the definition of the list from the database. I know SET is faster, but these are really small databases. Thanks. -- Greg Willits -- [EMAIL PROTECTED]

Converting Column to SET

2002-02-21 Thread Greg Willits
olumn as SET, then reimport it into this column? 3 - what happens to field data when the SET selections are redefined? The reason behind the previous setup was to allow easy changes to the selection list and isolate the definition of the list from the database. I know SET is faster,

Case for Field Name Alias

2002-01-27 Thread Greg Willits
I suspect aliases are best reserved to solve hairy conflicts when merging sysems or something. But does the simplification of using standardized routines like this also make for good reason to use them? Wanting to have adopt good habits from the beginning Thanks.

Re: print database schema

2002-01-29 Thread Greg Willits
Check out this program. Just wish there was an OS X version :-( http://www.datanamic.com/dezign/index.html -- greg willits -- [EMAIL PROTECTED] From: Steven Wren <[EMAIL PROTECTED]> Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST) To: Paul DuBois <[EMAIL PROTECTED]> Cc: [EMAIL PROTEC