[daisy] backup-tool error

[Karel Vervaeke]

Here's how the mysqldump command is built when performing a backup:

String command = dumpExecutableName + " --single-transaction" + "
--databases " + " --user=" + this.username + " --password=" +
this.password + " --host=" + this.host + " --result-file=" +
dumpFile.getPath() + (port.intValue() > 0 ? " --port=" + port : "") + "
" + this.dbName;

Process dumpProcess = Runtime.getRuntime().exec(command);

As you can see, not all the parameters are quoted... My quess is that
one of the parameters contains a space which causes mysqldump to
interpret the part after the space as the databasename.
Likely candidates are your password and/or the path to the dumpfile.
Less likely candidates are the username and hostname.

Anyway if my guess is correct, please create a jira issue - as a
workaround just make sure the parameter which causes the problem does no
longer contain spaces.

Regards,
Karel


On Mon, 2008-04-28 at 21:41 -0400, Bob Ellison wrote:
> This occurs when performing a backup.  The databases are the default
> names, daisyrespository and activemq.  I have done little more than an
> install of 2.2 and some testing with skins that will be applied on
> another Daisy installation. The test of the backup was in advance of
> using backup/restore as a way of moving a beta version of Daisy to the
> production server. I can run mysqldump manually.
> 
> Bob
> 
> On Mon, Apr 28, 2008 at 9:18 AM, Karel Vervaeke <karel at outerthought.org> wrote:
> > Is this when performing a backup or when performing a restore?
> >
> >  What are your activemq and Daisy repository databases called?
> >
> >  Note that 'repouser' should be a mysql user, not a Daisy user (but that
> >  should be ok since database parameters are loaded from myconfig.xml)
> >
> >  Regards,
> >  Karel
> >
> >
> >
> >  On Sun, 2008-04-27 at 15:12 -0400, Bob Ellison wrote:
> >  > When I execute daisy-backup-tool I get  error 1044: Access denied for
> >  > user repouser at localhost to database 'and' when selecting the database.
> >  >
> >  > Running Daisy 2.2 on Windows XP Professional with MySQL 4.1.
> >  >
> >  > Bob
> >  > _______________________________________________
> >  > daisy community mailing list
> >  > Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
> >  > mail to: daisy at lists.cocoondev.org
> >  > list information: http://lists.cocoondev.org/mailman/listinfo/daisy
> >  _______________________________________________
> >  daisy community mailing list
> >  Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
> >  mail to: daisy at lists.cocoondev.org
> >  list information: http://lists.cocoondev.org/mailman/listinfo/daisy
> >
> _______________________________________________
> daisy community mailing list
> Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
> mail to: daisy at lists.cocoondev.org
> list information: http://lists.cocoondev.org/mailman/listinfo/daisy