Hello,
On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
Hi Anand,
the command is
mysqldump -B dp user1 user2 > dump.sql
dp - database
user1, user2 - table
The following excerpt is from the mysqldump manpage. It might helps.
-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. 'SE db_name;'will be included in the output
Best
- RuiXian
Regards,
Krishna
On 7/19/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> what is the command u used for taking mysqldump
>
> On 7/19/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
> >
> > Hi All,
> >
> > I have taken dump of two table using mysqldump. The size of the dump
> > file is
> > 175 MB. To restore dump file to another machine. It takes about more
> > than 30
> > minutes. Why it is taking a lot of time for such a small file.
> > Please help me.
> >
> > Regards,
> > Krishna
> >
>
>
