Re: WANTED: Utility to reverse engineer existing database II
Dear Kevin, mysqldump -w or something like SELECT * FROM my_table INTO OUTFILE my_dumpfile WHERE my_id BETWEEN 100 AND 500 Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # 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 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- --where='where_clause'. Of course, 'where_clause' would be something like 'id200' or whatever's appropriate. It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluable book, btw. Jay Fesco - 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
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 want all of the records. 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 -Original Message- From: Kevin [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:58 PM To: [EMAIL PROTECTED] 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 table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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: 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. mysqldump -w / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: WANTED: Utility to reverse engineer existing database II
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 (http://www.urbanresearch.com/ursql) allows you to export the results of any query (to a variety of formats). On Tue, 7 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 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 - 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: WANTED: Utility to reverse engineer existing database II
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 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 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 -Original Message- From: Kevin [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:58 PM To: [EMAIL PROTECTED] 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 table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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
RE: WANTED: Utility to reverse engineer existing database II
...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- --where='where_clause'. Of course, 'where_clause' would be something like 'id200' or whatever's appropriate. It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluable book, btw. Jay Fesco - 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: WANTED: Utility to reverse engineer existing database II
Dear Kevin, an option on mysqldump that would limit the number of records. Any ideas without writing a program? AFAIK you cannot do this with mysqldump. But you can use the SELECT ... INTO OUTFILE syntax, in some way like this: SELECT * FROM my_table INTO OUTFILE some_records WHERE id BETWEEN 200 AND 400 or (from the manual ;-) SELECT a,b,a+b INTO OUTFILE /tmp/result.text FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table WHERE id BETWEEN 200 AND 400 Check: http://www.mysql.com/doc/S/E/SELECT.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 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 want all of the records. 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 -Original Message- From: Kevin [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:58 PM To: [EMAIL PROTECTED] 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 table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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
RE: WANTED: Utility to reverse engineer existing database
Or you can just use the whereclause option in MySQLDump. (i.e. -w'RecordID200') http://www.mysql.com/doc/m/y/mysqldump.html Jay -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:47 AM To: Kevin; [EMAIL PROTECTED] Subject: Re: WANTED: Utility to reverse engineer existing database Dear Kevin, index, etc.) needed to recreate the database. Does such a utility exist? Yes. It's called PhpMyAdmin, and the recent version supports everything you asked for. You can get it at www.sourceforge.net - look for PhpMyAdmin there. Note: You need to have PHP installed in order to run this toolset. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - 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 table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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
RE: WANTED: Utility to reverse engineer existing database II
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 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? mysqldump -help look for the --where option Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - 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
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 table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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: WANTED: Utility to reverse engineer existing database
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 mysqldump? :) Greetz, Peter -- Against Free Sex! http://www.dataloss.nl/Megahard_en.html - 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: WANTED: Utility to reverse engineer existing database
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 - 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: WANTED: Utility to reverse engineer existing database
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+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - 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: WANTED: Utility to reverse engineer existing database
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). On Mon, 6 Aug 2001, 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? - 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: WANTED: Utility to reverse engineer existing database
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 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 - 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
Re[2]: WANTED: Utility to reverse engineer existing database
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 the database. Does such a utility exist? CHP mysqldump ? CHP / Carsten CHP -- CHP Carsten H. Pedersen CHP keeper and maintainer of the bitbybit.dk MySQL FAQ CHP http://www.bitbybit.dk/mysqlfaq - 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