l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Oct 26 08:55

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Export MySQL DB to flat file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Export MySQL DB to flat file


Even if I knew how to make flat files from MySQL, I wouldn't tell you...and here's why:

I take particular interest in this article. While I tend to eschew MS as a whole (...yeah right, as my email comes from Hotmail--well FYI hotheads [some of whom I've heard from privately], I got this email address before MS bought them!!!), I would consider myself a relative expert in MSSQL, and actually enjoy the product. I have had great success using it in combination with Open Source Front Ends, and Open Source middle tier business app.s...(mainly Java, but some PHP, and some Python).

That said...these people are complete ignoramuses. If they don't realize that all they need is an ODBC driver for MySQL in order to access the DB directly from MSSQL, (which is always more preferable than converting the data to flat files), and that they can then populate their own MSSQL local tables through querying what MS calls a 'linked server' (--formerly referred to by MS as a 'remote server'),which is just a regular query to the MySQL server--then they don't really know their own product very well, and you want to be as far from them as possible.

If I were you, I would, in front of the appropriate authority figure, espouse the benefits of accessing the 'real' data, as it is stored on MySQL, rather than capitulating to the ignorance of the hack (i.e. definitely not "hacker"), who is staking his/her claim to your data, and relying on an inferior method of data transfer through flat files.

I can explain this to you if you like...but you can probably find the information you need on Microsoft.com or MSDN.

...My 2 cents.

Don't give 'em shit...give 'em the straight poop, and stand-up for what is right...at least technically...regardless of platform.

By the way...while it is always painful to see a curtain closing on your window of influence...just take it in stride, knowing that you are bound for far more important things.

Oh, and one more thing, now that the Open Source DBs are becoming more robust...I am definitely being swayed in their direction.



----Original Message Follows----
From: Dylan Beaudette <dylan@iici.no-ip.org>
Reply-To: dylan@iici.no-ip.org,lugod's technical discussion forum <vox-tech@lists.lugod.org>
To: "lugod's technical discussion forum" <vox-tech@lists.lugod.org>
Subject: Re: [vox-tech] Export MySQL DB to flat file
Date: Mon, 25 Oct 2004 13:56:04 -0700
MIME-Version: 1.0
Received: from www.livepenguin.com ([]) by mc10-f29.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Mon, 25 Oct 2004 13:53:08 -0700
Received: from ns1.livepenguin.com (localhost [])by www.livepenguin.com (Postfix) with ESMTP id 26C3EB018D;Mon, 25 Oct 2004 13:53:06 -0700 (PDT)
Received: from tripoli.ucdavis.edu (tripoli.ucdavis.edu [])by www.livepenguin.com (Postfix) with ESMTP id 7831790A87for <vox-tech@lists.lugod.org>; Mon, 25 Oct 2004 13:53:02 -0700 (PDT)
Received: from basho.dept-lawr.ucdavis.edu (pes2141b.dept-lawr.ucdavis.edu[])by tripoli.ucdavis.edu (8.12.10/8.12.9/it-defang-5.2.0) with ESMTP idi9PKqxEp024208for <vox-tech@lists.lugod.org>; Mon, 25 Oct 2004 13:53:00 -0700 (PDT)
X-Message-Info: yilqo4+6kc6uK0eE/qfSVnmHyMtyMZMN
X-Original-To: vox-tech@lists.lugod.org
Delivered-To: vox-tech@livepenguin.com
User-Agent: KMail/1.6.2
References: <200410251220.53052.dylan@iici.no-ip.org><200410251252.18407.rod@sunsetsystems.com>
In-Reply-To: <200410251252.18407.rod@sunsetsystems.com>
Message-Id: <200410251356.04859.dylan@iici.no-ip.org>
X-Scanned-By: MIMEDefang 2.41
X-BeenThere: vox-tech@lists.lugod.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: lugod's technical discussion forum <vox-tech.lists.lugod.org>
List-Unsubscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:vox-tech-request@lists.lugod.org?subject=unsubscribe>
List-Archive: <http://ns1.livepenguin.com/pipermail/vox-tech>
List-Post: <mailto:vox-tech@lists.lugod.org>
List-Help: <mailto:vox-tech-request@lists.lugod.org?subject=help>
List-Subscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:vox-tech-request@lists.lugod.org?subject=subscribe>
Errors-To: vox-tech-bounces@lists.lugod.org
Return-Path: vox-tech-bounces@lists.lugod.org
X-OriginalArrivalTime: 25 Oct 2004 20:53:08.0445 (UTC) FILETIME=[A1D9B8D0:01C4BAD4]

On Monday 25 October 2004 12:52 pm, Rod Roark wrote:
> On Monday 25 October 2004 12:20 pm, Dylan Beaudette wrote:
> ...
> > We had a beautiful system for managing about 500 volunteers written in
> > PHP/MySQL and running on a linux machine, that was set to be moved to a
> > MacOS X box for permenant use... Now it would seem that after some
> > re-shuffling of administrative departments this is no longer the case,
> > and they want the application re-written in ASP/MS-SQL...
> All that for 500 volunteers? I wonder how that will work
> out in terms of development expense per volunteer. Sounds
> like someone wants MS SQL on their resume.

Actually, it sounds like a department that refuses to support, or even put up
with anything non-MS... even existing systems that need only be hosted.

ah well...


PS: thanks David and Mark for the ideas!
vox-tech mailing list

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.