already exists, and to add if it's the first time a particular
DB is syncing, etc. I never want to drop.
Regards,
Michael
On Jan 16, 2006, at 6:22 PM, Jake Peavy wrote:
DROP TABLE IF NOT EXISTS?
On 1/16/06, Michael Williams <[EMAIL PROTECTED]> wrote:
Hi All,
Having a bit of mysq
Hi All,
Having a bit of mysqldump trouble again. I've looked over the
documentation (again) and can't seem to find the flag to make
'mysqldump' out put "CREATE TABLE IF NOT EXISTS". Any ideas?
Regards,
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Hi all,
In yet another predicament. I'm wondering if there is any way to use
the -B db_name option while at the same time specifying the table
name(s) to be exported. The reason I ask is I am attempting to
synchronize files from multiple databases from the dump files, and it
would make
Hi All,
I have read thehttp://dev.mysql.com/doc/refman/5.0/en/
mysqldump.html and can find nothing regarding getting dump to
INSERT IGNORE instead of simply INSERT INTO. Is there any way to get
INSERT IGNORE to be dumped? Otherwise, I fear I may be forced to
parse the dump file a
When performing "mysqldump" is there any way to ensure that each
record gets an INSERT of it's own? I keep getting the following:
INSERT INTO 'mytable' (1,'test item'), (2,'test item'), (3,'test
item'), (4,'test item'), (5,'test item');
but I'd rather have
INSERT INTO 'mytabl
Hi all,
I'm trying to use "mysqldump" over SSH. I'm pretty familiar with
port forwarding in and of itself, so I doubt that's the issue. No
matter what port I forward (or to where for that matter), "mysqldump"
still connects to the local MySQL server and dumps local data. It's
as if it
ry for
the command so as to write it to a text file on the "client" machine
for use, etc. Sort of a "hey, server, what would it take to make
table BLAH if I wanted to recreate it completely?" kind of thing.
Thanks again!
On Nov 30, 2005, at 12:02 AM, Rhino 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 doe
Okay, this may well be a LINUX issue I am having, so be kind before you
flame.
When I try to index a large file, it fails with a write error on the /tmp
directory. Now my /tmp directory is on a smaller partition (as sent to me
by dell). Can I configure MySQL to use a different area when creati