[daisy] Error while restoring backup

[Karel Vervaeke]

There also was an issue with the backup tool if your password contains a
space - this was fixed in subversion and will only be available with the
next Daisy release cycle (2.2).

Karel

On Thu, 2008-06-26 at 13:10 +0200, Paul Focke wrote:
> I'm just taking a wild guess here. But it might be because the database
> doesn't exist and the backup tool tries to remove it. The process will
> then return a exit code 1, which means it failed. try doing a mysqladmin
> -u root create daisyrepository to see if it works. 
> 
> Paul
> 
> On Thu, 2008-06-26 at 10:48 +0200, Christian Weigel wrote:
> > Hello, 
> > 
> > I am running into problems restoring a previouly created backup. 
> > 
> > The Backup was created on remote machine that has the same setup I have on the machine I am currently working on. 
> > 
> > That means - Daisy 2.1, same directories, same users and passwords (as I encountered that the reashing functionality of the backup tool is kind of broken in 2.1).
> > 
> > It seems that there is a problem with the execution of database commands (dropping the currently existing tables). Please find the corresponding error below ... 
> > 
> > I also tried using Daisy 2.2 - but the results are the same ( java.io.IOException )
> > 
> > Is this a know problem, maybe a workaround already exists?
> > 
> > Many thanks in advance!
> > 
> >    Christian
> > 
> > ----
> > 
> > C:\Daisy\daisyhome\bin>daisy-backup-tool -d C:\Daisy\RepoData\ -r 20080522_000 -l C:\d_backups\
> > 
> > Before restoring a backup, make sure that the repository server
> > and the Daisy Wiki are not running.
> > 
> > Restoring this backup will undo all changes made since Thu May 22  12:00:01 CEST 2008
> > 
> > Do you wish to restore the backup? [yes|no, default: no]
> > yes
> > 
> > Restoring backup-20080522_000 ...
> > Running mysqladmin -f --user=repouser --password=PASSWORD -h localhost --port=3306 drop daisyrepository
> > java.io.IOException: CreateProcess: mysqladmin -f --user=repouser --password=PASSWORD -h localhost --port=3306 drop daisyrepository error=2
> >         at java.lang.ProcessImpl.create(Native Method)
> >         at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
> >         at java.lang.ProcessImpl.start(ProcessImpl.java:30)
> >         at java.lang.ProcessBuilder.start(ProcessBuilder.java:451)
> >         at java.lang.Runtime.exec(Runtime.java:591)
> >         at java.lang.Runtime.exec(Runtime.java:429)
> >         at java.lang.Runtime.exec(Runtime.java:326)
> >         at org.outerj.daisy.backupTool.dbDump.MysqlDbDumper.restore(MysqlDbDumper.java:51)
> >         at org.outerj.daisy.backupTool.DbBackupEntry.restore(DbBackupEntry.java:50)
> >         at org.outerj.daisy.backupTool.BackupManager.restore(BackupManager.java:142)
> >         at org.outerj.daisy.backupTool.BackupTool.restoreBackup(BackupTool.java:205)
> >         at org.outerj.daisy.backupTool.BackupTool.main(BackupTool.java:98)
> > 
> > 
> > 
> > 
> > _______________________________________________
> > 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