Polly,
This isn¹t a backup/restore issue, it¹s a versioning issue. Let me guess.
You backed up Mifos, tried upgrading, decided against it and wanted to
restore the old database?
If that¹s the case, you might want to first drop the mifos db, then create
it, then reload the db. I¹ve found that you can run into issues like this,
especially when trying to restore a database over a different version of the
Mifos database.
Ryan
On 10/14/10 14:51, "Polly" <[email protected]> wrote:
>
>
> Hello,
>
> When all backups are done ok, why is it that some dumps restore successfully
> while some fail like the one attached? Theres nothing I that I can point out
> that I do differently when doing the backups....
>
>
>
> Mifos Database Error
> A database error occurred. Correct the error and restart the application.
> Details:
> Failed to upgrade database. Database Version = 212 Application Version = 257.
> More details:
> java.sql.BatchUpdateException: Duplicate key name
> 'loan_counter_client_perf_idx'
> Using Mifos database connection settings from file(s): [C:\Program
> Files\Apache\Tomcat 6.0\Mifos_Conf\mainDatabase.properties, C:\Program
> Files\Apache\Tomcat 6.0\Mifos_Conf\local.properties] Connection
> URL=jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8.
> Username=mifos. Password=********
>
--
Ryan Whitney
Mifos Technical Program Manager
[email protected]
Mifos® - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
