All, I would like to put in my two farthings and second DL's opinion of MySQLFront- it is a great tool. I use it for a number of tasks, including porting my development database (which I run under IIS 5.0 on Win 2k, together with PHP 4.0.6) to my "production" database on my web site (which runs under Solaris). IMHO, it's the best GUI (for Windows, at least) for MySQL out there.
Cheers, Fred Woolsey -----Original Message----- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 10:38 AM To: Dexter Coelho; [EMAIL PROTECTED] Subject: Re: How to copy table structure easily. > Just want to copy the table structure of a table i Have but dont have the > the create statement and dont want to have to type it again , it has a lot > of fields. Can I easily replicate a table. Hi Dexter, I took a look at a number of the MySQL management tools as mentioned in articles/discussions on various MySQL-interest web sites. Currently I am using one called MySQL-Front (www.MySQLFront.de) which I believe works on a variety of OpSys/platforms. I find that I rarely need to drop into 'native' MySQL these days (which may not be the best thing for my SQL DDL skills, but...). Amongst other things, this tool allows the exporting of tables - either the structure, or the data, or both. These are exported as a *.sql file, all ready to be piped straight back into 'native' MySQL, or using MySQL-Front, brought back into its editing window - where a quick change to the table name, etc, followed by in-tool SQL code execution will produce a clone. Brilliant stuff! Regards, =dn BTW did we solve your previous problem? --------------------------------------------------------------------- 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