Re: Database restore
Curtis Maurand <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <CAOU0tYAv-mSo8z-g4RCETyOxrUH6Q0JWYKi2JD9-vA7vXvOVfw@mail.gmail.com> |
Thanks, I'll give that a shot while i look at replicatuon which I've never been able to make work. On Feb 5, 2015 8:58 AM, "Andrea Brancatelli" <[email protected]> wrote: > 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]> > 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 >> 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 >> >> > > _______________________________________________ > DBmail mailing [email protected]://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 > > _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail