Re: Seriously Disruptive DBA

2007-08-24 Thread Mark Schoonover
Jonathan,

On 8/24/07, Jonathan G. Lampe [EMAIL PROTECTED] wrote:

 Hello,

Here's 4 easy steps that show how you too can be a Seriously
 Disruptive DBA:

 1) Sign on to MySQL as root
 2) Perform a show databases;
 3) For each entry you see, issue a drop database X; command
 4) Sign out and disavow any knowledge of your actions

 At 03:22 PM 8/23/2007, james benjamin wrote:
 We are, like, totally down with recruiting a Seriously Disruptive MySQL
 DBA.
 ...hardcore MySQL DBA with contributions to the code base...

 Now seriously...I was a bit confused here: many MySQL DBAs
 (certainly the ones chasing the MySQL certificates) just want to
 master the latest production-rated edition of MySQL; they aren't
 really interested in coding.  In fact, I was a bit surprised to see
 that there was no mention of the MySQL cert program in Mr. Benjamin's
 advertisement looking for a MySQL DBA - wouldn't that pool of
 certified MySQL DBAs seem like a better place to start?



snip

Regards,
 - Jonathan Lampe
 - Standard Networks, Inc.
 - http://www.standardnetworks.com
 - [EMAIL PROTECTED]


I don't think a blanket description of MySQL DBAs works in all cases. I for
one, am a CMDBA, and interested in coding. I code more client software than
contributing to the MySQL codebase. I don't know if that classifies me as
Seriously Disruptive DBA or not. I think having both skills as an asset
any company can take advantage of. I guess it all depends on what you
believe, being more general or specific in a set of skills.

I see contributing to the code base leaning towards being a software
engineer instead of a DBA. A software engineer can learn to be a DBA, but
I'm not exactly sure if the reverse is true.

Just my $.02USD.

-- 
Mark Schoonover, CMDBA
[EMAIL PROTECTED]
http://marksitblog.blogspot.com
Cell: 619-368-0099

Database Administration * System Engineering * Software Development *


RE: Access to MySQL

2002-08-16 Thread Mark Schoonover

Take a look at MyODBC...

.mark

 -Original Message-
 From: Oladejo, Tokunboh [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 16, 2002 10:48 AM
 To: [EMAIL PROTECTED]
 Subject: Access to MySQL
 
 
 Hi All,
 
 Does anyone knows of any easy way/short cut of exporting 
 Microsoft access
 tables into MySql database.
 
 Thanx
 All
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: MySQL: Problem Installing on RH 7.3

2002-07-18 Thread Mark Schoonover

At first blush it looks like it's a rights problem. Need to have the
/var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user
mysql...

HTH

.mark

 -Original Message-
 From: Richard Fox [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, July 18, 2002 8:44 AM
 To: Noamn; [EMAIL PROTECTED]
 Subject: Re: MySQL: Problem Installing on RH 7.3
 
 
 The mysqld.log file says:
 
 020717 13:05:05  mysqld started
 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
 './mysql/host.frm' (errno: 13)
 020717 13:05:05  mysqld ended
 
 But I do see the host.frm file:
 
 -rw-rw1 root root 8958 Jul 17 13:04
 /var/lib/mysql/mysql/host.frm
 
 How did you fix this problem?
 
 I do have the /var/lib/mysql/mysql.sock file...
 
 Thanks
 Rich
 
  I'm near enough in the same position as you are. Check the file
  /var/log/mysqld.log to see what the problem is. I had a 
 problem accessing
  the file './mysql/host.frm', but I think that I've fixed this now.
 
  What happens when you try the 'mysql' command? I get the response
  can't connect to local MySQL server through socket
  '/var/usr/mysql/mysql.sock'
  And indeed there is no such file.
  Do you have this file?
 
  -Original Message-
  From: Richard Fox [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, July 17, 2002 10:41 PM
  To: [EMAIL PROTECTED]
  Subject: MySQL: Problem Installing on RH 7.3
 
 
 
  The MySQL daemon does not run. I installed the binary RPM's 
 from the RH
 cd,
  MySQL 3.23.49. I run mysql_install_db, outputs some text 
 and appears to
  execute correctly. The I run safe_mysqld , and I get:
 
  [root@thor rfox]# /usr/bin/safe_mysqld 
  [1] 2212
  [root@thor rfox]# Starting mysqld daemon with databases from
 /var/lib/mysql
  020717 15:21:28  mysqld ended
 
  That's it! I tried both the rpm and compiling it myself 
 from source with
  BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
 
  I just need a little hint, please! How do I troubleshoot this?
 
  Thanks,
 
  Rich
 
  sql
 
 
  
 -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: 
 http://lists.mysql.com/php/unsubscribe.php
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php