On Thu, 2008-07-10 at 10:05 +0200, Rafal Somla wrote:
> Hi Peter
> Peter Gulutzan wrote:
> > I've been looking at the MySQL Reference Manual description of datadir
> > and I assume there will be something similar for backupdir saying
> > --backupdir = path
> > Option sets variable: yes, backupdir
> > Variable name: backupdir
> > Variable scope: Global
> > Dynamic variable: No
> > Value set: Type filename
> One differnece is that backupdir *is* a dynamic variable. That is you can say
> "SET BACKUPDIR = <path>". Unless I'm mistaken - I'll send correction if I am.
Chuck's comment on Bug#35230 is
"This patch adds the dynamic variable --backupdir ...".
But is that the right thing to do?
I wrote for the article, as early as January 11:
"The 'backupdir' i.e. 'backup directory' variable is new.
You can see its value with "SELECT @@backupdir" but it
is read only so you may not set it while the server is up."
And on June 23 in an email to Chuck I said:
"What I'd like best is:
* Both datadir and backupdir are read-only."
Descriptions for all the other "dir" variables (basedir,
character-sets-dir, datadir, tmpdir) say dynamic = no.
And I worry about replication.
Lead Software Engineer / SQL Architect
MySQL / Sun Microsystems