On 12/21/12 13:27, Dan Langille wrote:
> On Dec 21, 2012, at 12:46 PM, Joseph De Nicolo wrote:
>> Now my question is.. should my script(backupmysql.sh) be located on the
>> backup system only, the client only, or both? I'm not sure if bacula takes
>> the script locally and ports it over to the client or if it searches fo the
>> script on the client itself. I hope you understand what I'm talking about.
>> Appreciate the help.
>
> It can be where ever you can run mysqldump.
>
> I suggest it should be on the same machine as the MySQL server. i.e. the
> client
Just as a suggestion, you might want to look into using mydumper rather
than mysqldump. mysqldump has been pretty much the red-headed stepchild
of MySQL tools; it is long overdue for a major overhaul and it hasn't
gotten it. mydumper is actually a much better tool, possibly the most
important single difference being that it is inherently aware of
transactional and non-transactional storage engines, and automatically
just Does The Right Thing for both types of tables on a table-by-table
basis in a single dump, something which is literally impossible to do
with mysqldump.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
