[kwlug-disc] MySQL Backups

[Khalid Baheyeldin]

This will backup all the databases on a MySQL instance:

mysqldump --all-databases | gzip -c > all.sql.gz




On Fri, Feb 14, 2014 at 3:29 PM, Chris Frey <cdfrey at foursquare.net> wrote:

> On Fri, Feb 14, 2014 at 03:19:29PM -0500, Khalid Baheyeldin wrote:
> > mysqldump db_name | gzip -c > db_name.sql.gz
>
> Depending on your databases, you may want to add --routines
> to your mysqldump command line too, unless you're backing up everything,
> including the mysql database, which contains the procedures.
>
> - Chris
>
>
>
> _______________________________________________
> kwlug-disc mailing list
> kwlug-disc at kwlug.org
> http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>



-- 
Khalid M. Baheyeldin
2bits.com, Inc.
Fast Reliable Drupal
Drupal optimization, development, customization and consulting.
Simplicity is prerequisite for reliability. --  Edsger W.Dijkstra
Simplicity is the ultimate sophistication. --   Leonardo da Vinci
For every complex problem, there is an answer that is clear, simple, and
wrong." -- H.L. Mencken
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20140214/000da06f/attachment.htm>