Michael
>Is there a command similar to "SHOW CREATE TABLE. . ." that will
>output the commands to fully duplicate a table; data and all? I want to
>retrieve the command and write it to a text file.
See the docs for mysqldump.
PB
-----
Michael Williams wrote:
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will
output the commands to fully duplicate a table; data and all? I want
to retrieve the command and write it to a text file.
Basically what I need is a "SHOW" on "CREATE TABLE copy SELECT * FROM
original", but SHOW doesn't seem to work here. I need a copy of this
command so that I can then replicate that table as often as desired
in the future on whatever system is in place. I could obviously dump
the entire db, but i only want this on a per table basis, as I deem
necessary, whenever I deem it so. Any help would be greatly
appreciated.
Thanks in advance!
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.10/186 - Release Date: 11/29/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
