List:General Discussion« Previous MessageNext Message »
From:Naufal Sheikh Date:December 11 2007 7:04pm
Subject:mysql dump
View as plain text  
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!


mysql dumpNaufal Sheikh11 Dec
  • Re: mysql dumpMichael Dykman11 Dec