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 me on above!

Thanks
Naufal

from the mydump screen:

$ mysqldump --
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 <naufalzamir@gmail.com> 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 me on above!
>
> Thanks
> Naufal
>



--
- michael dykman
- mdykman@gmail.com

- All models are wrong. Some models are useful.