Michael, You have three option with mysqldump command to do what you are looking for
$>mysqldump --add-drop-table db_name table_name -> this one will dump data, create table info and add DROP TABLE IF EXIST on the top of the dump, so you would be able to re-create original table and its data to a tee. $mysqldump --no-create-info db_name table_name -> this will dump only data. nothing of table structure. $mysqldump --no-data db_name table_name -> this will dump only table structure, nothing of data will be dumped. Regards, Mikhail Berman -----Original Message----- From: Michael Williams [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 11:30 PM To: mysql@lists.mysql.com Subject: SHOW commands. 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
