# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Jay Fesco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 9:24 PM
Subject: RE: WANTED: Utility to reverse engineer existing database II
...Some of my tables have thousands of records and I
: Utility to reverse engineer existing database
I need a utility that will probe my existing mysql database,
analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate the database. Does such a utility exist?
Kevin
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records.
I see that
mysqldump allows data copy by providing the cooresponding INSERT
statements.
mysqldump -w
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
Did you see the -w, --where option? It might be what you're looking
for...
Dump only selected records.
--http://www.mysql.com/doc/m/y/mysqldump.html
If you have a more complicated query and you are using Windows, you can
use urSQL + MyODBC to accomplish this as urSQL
emacs
MJM
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 11:30 AM
Subject: WANTED: Utility to reverse engineer existing database II
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data
...Some of my tables have thousands of records and I may only want the first
200 or so. I did not see
an option on mysqldump that would limit the number of records. Any ideas
without writing a program?
Kevin
Try the WhereClause option in mysqldump.
Syntax is:
-w 'where_clause'
-or-
, 2001 5:30 PM
Subject: WANTED: Utility to reverse engineer existing database II
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records. I see
that
mysqldump allows data copy by providing the cooresponding INSERT
statements.
However, I don't always
-
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 10:57 PM
Subject: WANTED: Utility to reverse engineer existing database
I need a utility that will probe my existing mysql database, analyze
the 90+
tables and spit out the data definition language (create
On 07-Aug-2001 Kevin wrote:
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records. I see that
mysqldump allows data copy by providing the cooresponding INSERT statements.
However, I don't always want all of the records. Some of my tables have
I need a utility that will probe my existing mysql database, analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate the database. Does such a utility exist?
Kevin
On Mon, Aug 06, 2001 at 04:57:41PM -0400, Kevin wrote:
I need a utility that will probe my existing mysql database, analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate the database. Does such a utility exist?
Tried
For mysql you can use mysqldump
Kevin wrote:
I need a utility that will probe my existing mysql database, analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate the database. Does such a utility exist?
Kevin
mysqldump
It comes with MySQL.
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 3:57 PM
Subject: WANTED: Utility to reverse engineer existing database
I need a utility that will probe my existing mysql database, analyze the
90
Yup. You can use mysqldump (comes with the MySQL distribution). See the
MySQL manual for details:
http://www.mysql.com/doc/m/y/mysqldump.html
You can also use a graphical tool such as urSQL (MS Windows + MyODBC) to
accomplish the scripting if you wish (http://www.urbanresearch.com/ursql).
Got it! Thanks.
-Original Message-
From: Colin Faber [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 5:11 PM
To: Kevin
Cc: [EMAIL PROTECTED]
Subject: Re: WANTED: Utility to reverse engineer existing database
For mysql you can use mysqldump
Kevin wrote:
I
Check out CaseStudio at www.casestudio.com.
Mark Chalkley
On Monday, August 06, 2001, 5:40:15 PM, you wrote:
I need a utility that will probe my existing mysql database,
analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate
16 matches
Mail list logo