Re: Restore take lot of time

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

Re: Restore take lot of time

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

Re: Restore take lot of time

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,

Re: Restore take lot of time

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

Restore take lot of time

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