Re: GA download reverted back to 5.5.24?

2012-06-30 Thread Govinda
> Oracle have been quick to announce new releases of mysql, but failed to issue > a notice saying " uhoh, you better not use it" instead, putting a small > notice, where, on a fricken manual page FFS. who the hell reads that! and > they say use version "a" which does not even exist, I'd hate to

Re: GA download reverted back to 5.5.24?

2012-06-29 Thread Govinda
everyones' sake. Just us humans under the hood. -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Community Server 5.1.63 has been released

2012-05-14 Thread Govinda
ht on this topic from those who KNOW. I have read a lot of rhetoric, but not seen much truly authoritative writing. Thanks, -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: [First email] Problem with backup and ID's for a Database with INNODB

2012-02-03 Thread Govinda
er pieces.. both to make it easier for you to debug, and also easier to ask one small thing at a time on this list. -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: delete all hosts using a wildcard

2012-01-16 Thread Govinda
post, excellently written! -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Date and Time

2012-01-08 Thread Govinda
> > leave it stored as a timestamp type or datetime type, and when you need to > display it otherwise.. then covert with date() oops, Paul's post reminded me I was suggesting a PHP function here ^^^ ... and this is the MySQL list. > -G -- MySQL General Mailing List For list archives: http:/

Re: Date and Time

2012-01-08 Thread Govinda
> What's your problem/reason with how it is? I assume Andy means: leave it stored as a timestamp type or datetime type, and when you need to display it otherwise.. then covert with date() -G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2012-01-04 Thread Govinda
e contents is the paths to those commands. I am now able to run "mysqldump" or "mysql" directly. Thanks to everyone who replied! For the archives, should any newbie actually find this thread on topic for where he/she is stuck, please note this (another great resource for dri

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2012-01-03 Thread Govinda
/bin:/usr/local/git/bin:/usr/X11/bin ...nor here: Govind% printenv PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/local/git/bin:/usr/X11/bin [snip] I use git commands without full path, from any directory, successfully, so I know this is right: Govind% echo $PATH /usr/bin:/bin:/usr/sbin:/sb

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-31 Thread Govinda
ght.. but 'sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.locate.plist' seemed to have no effect. (Again, way over my head for now). > How about "echo $PATH"? Govind% echo $PATH /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/local/git/bin:/usr/X11/bin Thanks for poking :-) -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Govinda
ldump mysqldump: Command not found. Govind% which /usr/local/mysql/bin/mysqldump /usr/local/mysql/bin/mysqldump kind of defeats the purpose of having to know the path in advance in order to use the command to detect the path ;-) -Govinda -- MySQL General Mailing List For list archives: http://lis

why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Govinda
ust reveal a gaping (basic) hole in my knowledge. .. but I would appreciate any help ;-) [1] http://stackoverflow.com/questions/8663454/why-does-basic-mysqldump-on-db-table-fail-with-permission-denied Thanks -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: delete syntax

2011-12-02 Thread Govinda
[snip] > so please do not tell other peopole on what knowledge they can rely > *all* the back and forth in these threads is good.. is susses out all the knowledge for everyone to see. Sincerely thanks to everyone who chimes in from all perspectives, -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Inserting a new row

2011-11-14 Thread Govinda
take further inserts. hmmm... I am also relative newbie with mysql, but I am guessing this means that your ID field is not set to auto_increment. FIx that, and then test. -Govinda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
Roger, 2 mins. of Google turned up these (just f.y.i.): http://www.cyberciti.biz/faq/mysql-change-root-password/ http://www.cyberciti.biz/tips/recover-mysql-root-password.html -G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
se it helps you (who seem to be even more newbie than me). and also in case Reindl wants to teach us/comment some more (please do!) :-) (coming from a developer who only learns the minimum (server admin skills) that he has to; I like to focus on *development*. I mean I would like to b

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
> ...as Brandon said.. from terminal you have to type something to get into > mysql, and if you are like me, then that is: > > /usr/local/mysql/bin/mysql Oh, I forgot to add - but you might need to be super user first. su (input pass..) > > -Govinda > >> I ins

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
...as Brandon said.. from terminal you have to type something to get into mysql, and if you are like me, then that is: /usr/local/mysql/bin/mysql -Govinda > I installed Mysql using the .dmg package. I can use System Preferences to > start and stop the program. When I open a terminal

Re: DBA Mentor?

2011-05-05 Thread Govinda
. When I really look into people's motivation, I never find real mal intentions.. I just have to look deep enough; Everyone seemed innocent here (not deserving of any flippant remarks). Communication is the trick, eh? Are we surprised? ;-) - Govinda -- MySQL General Mailing List For list a

Re: what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Govinda
I see such nice formated text output serving to illustrate people's tables and I think it must be due to some code which is spitting that out, rather than people typing so painstakingly. What is that function/MySQL/code? It's the default output format of the mysql command line client, no

what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Govinda
My table group_member looks like this: +---+---+-+ | member_id | name | head_id | +---+---+-+ | 1 | Elim |NULL | | 2 | Ann | 1 | | 3 | David |NULL | | 4 | John | 3 | | 5 | Jane | 3 | +--