[daisy] backup-tool error

[Karel Vervaeke]

Just a guess, but you're running windows and dumpFile.getPath() is
something like c:\Documents *and* Settings\user\daisy-backups.  Try
using another backuplocation.

Regards,
Karel

On Tue, 2008-04-29 at 11:20 +0200, Karel Vervaeke wrote:
> 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
> _______________________________________________
> 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