from the mydump help screen: $ mysqldump --help mysqldump Ver 10.10 Distrib 5.0.22, for redhat-linux-gnu (x86_64)
... with all databases selected. --add-drop-database Add a 'DROP DATABASE' before each create. --add-drop-table Add a 'drop table' before each create. ... --create-options Include all MySQL specific create options. -B, --databases To dump several databases. Note the difference in usage; In this case no tables are given. All name arguments are regarded as databasenames. 'USE db_name;' will be included in the output. - michael On Dec 11, 2007 2:04 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > Hello every one, > > I have two questions actually. If there is a database server with couple of > databases, and we only want to take the dump of few of them, can we specify > a list of those on either mysqldump or mysql prompt ( for any other purpose > ).or we have to run the mysqldump command seperately for every database. > > e.g. mysqldump --database1 > database1.sql > mysqldump --database2 > database2.sql > > or mysqldump --database1 --database2 > database.sql > > Second, when I am importing a dump file into another server, if that server > already has thate database, it gives me an error of saying that the > table/column already exists. Is there any switch to over ride that. > > > > I'll appreciate if some can please help me on above! > > Thanks > Naufal > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]