This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Help with mysqldump Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Help with mysqldump" Watch "Help with mysqldump" New topic
Author

Help with mysqldump

Duran Harris
Ranch Hand

Joined: Nov 09, 2008
Posts: 602

Hi all,

Firstly-
I was wondering if it is possible to include (AND/OR) in mysqldumps.
Secondly-
When I use mysqldump,everytime It overwrites existing files with the same name..is there no parameter to append to an existing file??I just want the insert statements.....

===>SCJP 1.5(72%)<===
==>SCWCD1.5(76%)<===
Haris Karameh
Ranch Hand

Joined: Oct 17, 2002
Posts: 38
Yes, it is possible
Change output file with -r option
and set your where clause with -w
to get only inserts use
--all=FALSE --complete-insert=TRUE

run mysqldump --help for details
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Help with mysqldump
 
It's not a secret anymore!