Re: Database restore

Andrea Brancatelli <[email protected]>
Newsgroups gmane.mail.imap.dbmail
Organization Schema31 S.p.a.
Message-ID <[email protected]>
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
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
abrancatelli.vcf (text/x-vcard, 343 B)
begin:vcard
fn:Andrea Brancatelli  
n:Brancatelli;Andrea
org:Schema31 S.p.a.
adr:;;Via Giovanni Andrea Badoero 67;Roma;RM;00125;Italia
email;internet:[email protected]
title:Responsabile IT
tel;work:+39-06-98358472
tel;fax:+39-055-71880466
tel;cell:+39-331-2488468
x-mozilla-html:TRUE
url:http://www.schema31.it/
version:2.1
end:vcard
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.