List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:December 23 2011 9:38pm
Subject:Re: FULL mysqldump
View as plain text  
Hi Jim happy holidays to you!

actually you just need to add the --routines trigger

mysqldump --all-databases --*routines* > fulldump.sql

with this you get all databases including the system one with privileges
(mysql), triggers is on by default, you enable routines with the flag --*
routines*
*
*
Keep in mind that this method needs any application to be stopped from
writing either by shutting it down, blocking it at network level or locking
the database with something like  FLUSH TABLES WITH READ LOCK;
Depending on your application, your SLA, etc.

Keep also in mind that for database larger than a few GB it is not
recommended to use mysqldump (text dump) but any binary method, among which
 Percona XtraBackup in my opinion is the golden tool,
derived from InnoBackup allows hot backups.

Cheers

Claudio

2011/12/23 Jim McNeely <jmcneely@stripped>

> Hello all, happy holidays!
>
> What is the best way to run a mysqldump to get the tables, the data, the
> triggers, the views, the procedures, the privileges and users, everything?
> It seems confusing in the online documentation, or is that just me?
>
> Thanks,
>
> Jim McNeely
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Claudio

Thread
FULL mysqldumpJim McNeely23 Dec
  • Re: FULL mysqldumpReindl Harald23 Dec
    • Re: FULL mysqldumpWm Mussatto23 Dec
      • Re: FULL mysqldumpReindl Harald23 Dec
    • Re: FULL mysqldumpIgor Shevtsov24 Dec
      • Re: FULL mysqldumpReindl Harald24 Dec
  • Re: FULL mysqldumpClaudio Nanni23 Dec