Re: Database restore
Gordan Bobic <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
On 2015-02-05 13:59, Andrea Brancatelli wrote: > Don't mistreat mysqldump, if used correctly it's powerfull. It's reasonably powerful, but for datasets larger than a few GB the process is slow to back up, and unworkably slow to restore. > Especially if you have binary-logging enabled you can easily perform > daily incremental backups of the MySQL base.... In which case you might as well be replicating. And if you use the massively more efficient, flexible and powerful row based binlogging rather than statement based binlogging, you cannot just dump runnable sql using mysqlbinlog. Databases of grown-up size require grown-up solutions. If your email DB is a few GB it doesn't matter. If it's a few tens of GB it begins to matter. By the time you get to a few hundred GB, a heavier duty solution becomes necessary rather than optional.