er 02, 2004 1:44 PM
To: 'Josh Howe'; [EMAIL PROTECTED]
Subject: RE: mysqldump
Did you try this one? I simplified it for you. You just need to put this
in
a file and chmod +x the file. Then you can execute it from a crontab or
with
the shell.
~~~ Copy/paste after this ~~~
#!/bin
with z_.
mysqldump -u root -p -x -e db1 z_* > /tmp/backup/db1_table1.sql
On Mon, 2004-11-01 at 11:30, Josh Howe wrote:
>
> Hi,
> Can anybody help me with a linux newbie question. I want to use
> mysqldump to backup all of the tables in a database that start with
z_.
> C
Hi,
Can anybody help me with a linux newbie question. I want to use
mysqldump to backup all of the tables in a database that start with z_.
Can I do this in linux with a single line? Thanks.
Sent: Wednesday, October 27, 2004 4:51 PM
To: Josh Howe; [EMAIL PROTECTED]
Cc: Leo; [EMAIL PROTECTED]
Subject: Re: what is wrong woth this statement?
Have you considered doing what you want to do in Ant? I haven't done
exactly
what you want to do but Ant supports properties and conditions. I could
e each script directly I can execute each
via an intermediate perl script that updates the db to indicate which
change scripts have been applied. That's more complex though. Any ideas
would be greatly appreciated. Thanks!
____
From: [EMAIL PROTECTED]
nesday, October 27, 2004 3:25 PM
To: Josh Howe
Subject: Re: what is wrong woth this statement?
> How can I do this?
By using the CASE staement?
On Wed, 27 Oct 2004 15:15:11 -0400, Josh Howe <[EMAIL PROTECTED]> wrote:
> Sorry, I don't think I was very clear. I'm asking a more
f ([record exists]) then
Do some sql
End If
How can I do this? Thanks.
-Original Message-
From: Leo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 11:38 PM
To: Josh Howe
Cc: [EMAIL PROTECTED]
Subject: Re: what is wrong woth this statement?
i didnt fully catch you...
i
Thanks, but I don't think a unique index is what I want. I need to allow any
number of records with the same user_id and a value of 'N' in is_primary.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 11:18 PM
To: Josh
if (select count(*) from z_mail_systems > 0) then [insert statement]
endif;
How do I do this kind of conditional insert? Thanks.
Hi all,
I have a table with these fields:
user_id
dept_id
is_primary ('Y' or 'N')
I want to make sure that there are never two rows in this table with the
same user_id and is_primary='Y'. For any user_id, there can only be one
primary record. In MS SQL I would define a user constra
Does anybody know of any free tools to compare two mysql schemas? Thanks.
11 matches
Mail list logo
