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 25 12:52

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

no, we won't help you do this! ... just kidding... sorry... we're too
nice... we'll help you anyway...

If you don't have too many tables, just open up the tables in PhpMyAdmin
and copy & paste the table entries to Excel & save.

Even writing such tool doesn't sound too hard in PHP -- just connect, and
write out CSV data for each table.

Now, ask a ASP/MS-SQL guy to do the same thing and it'll take twice as
long... (just knowing the surface of the ASP syntax and the availability
of tools for MS products...)


On Mon, 25 Oct 2004, Dylan Beaudette wrote:

> Greetings!
> Well it is a sad day for in the world of opensource software gaining ground
> over proprietary products... (and in this case all at the taxpayer's expense)
> 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... needless to say I won't have the
> privilege of participating in this act, but it would seem that before I go
> they want "flat files" of the MySQL DB. Short of writting some code to build
> the files, I was wondering if there is any such tool in the MySQL utils that
> will save something like a CSV file that represents the records in the DB...
> something like mysqldump, but without all of the SQL code mixed with the
> data...
> any ideas?
> Thanks in advance!
> --
> Dylan Beaudette
> Soil Science Graduate Group
> University of California at Davis
> _______________________________________________
> vox-tech mailing list
> vox-tech@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech

Mark K. Kim
AIM: markus kimius
Homepage: http://www.cbreak.org/
Xanga: http://www.xanga.com/vindaci
Friendster: http://www.friendster.com/user.php?uid=13046
PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
PGP key available on the homepage
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.