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
Michael Williams wrote:
Thanks for the responses everyone. Just a quick FYI, I am using
Python as an intermediary to sync the DBs (I'm fine with using
whatever as long as it's Debian compatible). I suppose I should have
explained before, but I'm using the Python script to connect from a
Thanks for the responses everyone. Just a quick FYI, I am using
Python as an intermediary to sync the DBs (I'm fine with using
whatever as long as it's Debian compatible). I suppose I should have
explained before, but I'm using the Python script to connect from a
"client" machine to a "se
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
You could still still use mysqldump. There is a parameter to specify
which specific table you want to dump.
Usage: mysqldump [OPTIONS] database [tables]
=C=
www.calevans.com
Michael Williams wrote:
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the command
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:30 PM
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