469,903 Members | 1,893 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

dumping specific inserts

Hi,

I need to do a mysqldump of specific inserts, updates & deletes. I
read in the docs that I can use -w or --where.

Can I do a join?

Could someone provide an example?

Is there another way?

Thanks,

Kerri
Jul 20 '05 #1
3 1710
"kerri3" wrote:
Hi,

I need to do a mysqldump of specific inserts, updates & deletes. I
read in the docs that I can use -w or --where.

Can I do a join?

Could someone provide an example?

Is there another way?

Thanks,

Kerri


You can use phpmyadmin, and do any kind of query. Then in the window
showing the query result, there is an export option. You can use that
to output the result of query (even join query, or having where
clause) to diff. formats.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-dumpin...ict136238.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=455115
Jul 20 '05 #2
Hey Steve,

I would normally follow that route, but this is for a work project and
we're purely a perl house right now.

But I'm assuming that phpmyadmin. probably takes the query and puts it
into a mysqldump -w.

Will play around some more and repost.

Thanks,

Kerri

steve <Us************@dbForumz.com> wrote in message news:<41**********@news.athenanews.com>...
"kerri3" wrote:
> Hi,
>
> I need to do a mysqldump of specific inserts, updates & deletes. I
> read in the docs that I can use -w or --where.
>
> Can I do a join?
>
> Could someone provide an example?
>
> Is there another way?
>
> Thanks,
>
> Kerri


You can use phpmyadmin, and do any kind of query. Then in the window
showing the query result, there is an export option. You can use that
to output the result of query (even join query, or having where
clause) to diff. formats.

Jul 20 '05 #3
Today I learned that you can't do a join in the where_clause of
mysqldump. Would be really helpful if you could.

An easy solution was to output my queries (modified with insert
statements) to a log file.

Kerri
steve <Us************@dbForumz.com> wrote in message news:<41**********@news.athenanews.com>...
"kerri3" wrote:
> Hi,
>
> I need to do a mysqldump of specific inserts, updates & deletes. I
> read in the docs that I can use -w or --where.
>
> Can I do a join?
>
> Could someone provide an example?
>
> Is there another way?
>
> Thanks,
>
> Kerri


You can use phpmyadmin, and do any kind of query. Then in the window
showing the query result, there is an export option. You can use that
to output the result of query (even join query, or having where
clause) to diff. formats.

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by kerri | last post: by
6 posts views Thread by Greg Brant | last post: by
3 posts views Thread by rozrabiak | last post: by
10 posts views Thread by ken | last post: by
3 posts views Thread by noleander | last post: by
22 posts views Thread by Christopher Nelson | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.