[daisy] backup-tool error

[Bob Ellison]

My password has no spaces and the parameters in the script I execute
are all quoted because of they contain  "Program Files" or "Document
and Settings".  The directory for the dumps does have entries -- all
empty directories or files.

I then used a backup directory path that had no spaces. Now I got the
error  Files\Daisy\daisyhome ""=="" was unexpected at this time.
Finally I executed the script in the folder Program Files\Daisy with
just
 "-d RepoData " in the script rather than the full path. This worked.

Bob


On Tue, Apr 29, 2008 at 5:20 AM, Karel Vervaeke <karel at outerthought.org> 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
>