rom: 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
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
- 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;
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 ta
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 doe
thanks but I already have a bash version that logs to local filesystem
(then hacks the log into insert statements).
what I'm working on is something to log to another MySQL DB (outside
replication environment) to which I point (f)cgi (, etc.)
I think I've answered my own ?:
it seems DBI will par
does MySQL have a "pretty" way to persist snapshots of various show
commands?
for example in Oracle you could just do:
insert into sysstat_log select sysdate, * from v$sysstat;
--(an ugly, overly simple example)
can the show commands be called/parsed with DBD/DBI?
so far the onl
does MySQL have a "pretty" way to persist snapshots of various show commands?
for example in Oracle you could just do:
insert into sysstat_log select sysdate, * from v$sysstat;
--(an ugly, overly simple example)
can the show commands be called/parsed with DBD/DBI?
so far the onl
10 matches
Mail list logo