Re: Database restore

You have to, at least, add --opt.

My suggestion would be to go for something like

--opt --single-transaction -u ... -p ... --databases dbmail

If you don't specify --opt mysqldump will write a different INSERT for 
each ROW and that will literally kill mysql in the import step. With 
extended insert it puts different rows for each INSERT (insert values 
(...), (...), (...)) and it will be hugely faster.

Il 05/02/15 14:37, Curtis Maurand ha scritto:
>
> I think the defaults.  mysqldump -u root -ppassword --databases 
> dbmail.  I'll have to change that.
>
> On Feb 5, 2015 3:21 AM, "Andrea Brancatelli" <[email protected] 
> <mailto:[email protected]>> wrote:
>
>     Il 04/02/15 18:57, Curtis Maurand ha scritto:
>>     I just had to drop the dbmail database and restore from a
>>     backup.  The restore process took an inordinate amount of time
>>     for an 8 GB (that was the size of the dump file) database (it
>>     took hours).  Is there anyway to speed that up?  are there dump
>>     options I should be looking at to make the restore go faster?
>
>     It's probably related to mysqldump parameters, like
>     extended-inserts and such.
>
>     What command line did you use to export it?
>
>
>     -- 
>     *Andrea Brancatelli*
>
>     *Schema31 S.p.a.*
>     *Responsabile IT*
>
>     ROMA - FIRENZE - PALERMO
>     ITALY
>     Tel: +39.06.98358472 <tel:%2B39.06.98358472>
>     Cell: +39.331.2488468 <tel:%2B39.331.2488468>
>     Fax: +39.055.71880466 <tel:%2B39.055.71880466>
>     Società del gruppo SC31 ITALIA
>
>     _______________________________________________
>     DBmail mailing list
>     [email protected] <mailto:[email protected]>
>     http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
>
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-- 
*Andrea Brancatelli

Schema31 S.p.a.
Responsabile IT*

ROMA - FIRENZE - PALERMO
ITALY
Tel: +39.06.98358472
Cell: +39.331.2488468
Fax: +39.055.71880466
Società del gruppo SC31 ITALIA

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

begin:vcard
fn:Andrea Brancatelli  
n:Brancatelli;Andrea
org:Schema31 S.p.a.
adr:;;Via Giovanni Andrea Badoero, 67;Roma;RM;00154;Italia
email;internet:[email protected]
title:Responsabile IT
tel;work:+39-06-98358472
tel;fax:+39-055-71880466
tel;cell:+39-331-2488468
url:http://www.schema31.it/
version:2.1
end:vcard