If you doing for innodb and myisam try this.
mysqldump --opt ..this will have one insert statements for multiple records . 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 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 > > > >
