You have to, at least, add --opt. My suggestion would be to go for something like
--opt --single-transaction -u ... -p ... --databases dbmailIf 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" <abrancate...@schema31.it <mailto:abrancate...@schema31.it>> 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 DBmail@dbmail.org <mailto:DBmail@dbmail.org> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org 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
<<attachment: abrancatelli.vcf>>
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
