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