Fwd: Comma Delimited Import Error

2004-06-07 Thread Greg Willits
see where you have two commas together such as 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

API Changes from 4.0 to 4.1?

2004-06-02 Thread Greg Willits
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]

New 4.1.2 Startup Trouble

2004-06-01 Thread Greg Willits
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 General Mailing List For list archives: http

Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
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 I copy Bugs on this? -- greg willits -- MySQL General Mailing List For list archives: http

Short Passwords in 4.1.2

2004-06-01 Thread Greg Willits
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:http://lists.mysql.com/[EMAIL

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

Re: Are Views Supported?

2004-05-28 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
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: SELECTing to Substitute Text for Refc Codes

2004-05-25 Thread Greg Willits
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 can't even decide what

Re: cannot get into mysql console

2004-05-25 Thread Greg Willits
-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]

SELECTing to Substitute Text for Refc Codes

2004-05-24 Thread Greg Willits
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
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
into 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: 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
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 List For list

Large sample data sets for testing

2004-05-21 Thread Greg Willits
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

Re: HTML in MySQL Tables

2004-05-21 Thread Greg Willits
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

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

mysqld sock conflicts

2004-05-19 Thread Greg Willits
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
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: BLOB's - General Guidance

2004-05-19 Thread Greg Willits
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: BLOB's - General Guidance

2004-05-19 Thread Greg Willits
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

mysqld sock fights between two servers

2004-05-17 Thread Greg Willits
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:http://lists.mysql.com/[EMAIL

Converting Column to SET

2002-02-21 Thread Greg Willits
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

SET Conversion Questions

2002-02-20 Thread Greg Willits
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] - Before posting, please check: http://www.mysql.com

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 PROTECTED] Subject: Re

Case for Field Name Alias

2002-01-27 Thread Greg Willits
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. -- Greg Willits -- [EMAIL PROTECTED