Deleting column data & LOAD question

2003-11-19 Thread Patrick Larkin
Hello - what would the syntax be to delete all the data in a column for every record but still maintain the column? In other words, I don't want to delete the column, just the data in it. Second, is there a way I can LOAD a file of plain text passwords into a mysql database and encrypt them d

Re: myadmin for mac? or?

2003-10-07 Thread Patrick Larkin
, including this open source offering as hit #3 :-) <http://cocoamysql.sourceforge.net/> HTH! Cocoa MySQL is quite good! Patrick Larkin Bethlehem Area School District -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: mysqldump from cron > empty file

2003-10-07 Thread Patrick Larkin
On Monday, October 6, 2003, at 05:11 PM, Paul DuBois wrote: I don't understand. Here you say that mysqldump is in the path, but above you say that you don't know if mysqldump is in the path for cron jobs. I suggest you change the crontab entry to invoke mysqldump by its full pathname and then s

Re: mysqldump from cron > empty file

2003-10-06 Thread Patrick Larkin
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote: Please reply to [EMAIL PROTECTED] (not to me personally), so that others can follow this discussion. At 16:56 -0400 10/6/03, Patrick Larkin wrote: On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote: Does the PATH setting for

mysqldump from cron > empty file

2003-10-06 Thread Patrick Larkin
Hello - I have the following command to back up a MySQL database on a remote machine. Works beautifully from the command line when run manually as root: mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database > /Dumps/my_database.dump This results is a nifty SQL file with da

Re: Mac OS X Server 10.0.4 and startup

2001-07-05 Thread Patrick Larkin
provided startup script to the /etc/rc.d dir >> structure. >> >> In MacOS X, there is no such directory. Thanks! > > Have a look at: > > /System/Library/StartupItems and subdirectories therein. > >> >> >