[daisy] Error while restoring backup

[Paul Focke]

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