problem with the database backup module

[Santhosh Vairavan]

Hi I installed the database backup module and use it as a backup.  I was wondering if anyone had a problem with restoring the backup file back to the new database.  I have found two problems with the module.  After dropping the database and creating it again the database creation is not ended with a semicolon.  The second one is that escape characters are not properly escaped so when inserting data into the database we get syntax errors.  PLease let me know if anyone else is having these issues. Thank you.

[Mathias Lin | Meta Healthcare]

Hi Santhosh,

I will take a look into it once I have my laptop with OpenMRS running
again, currently having some hardware issues.

> The second one is that escape characters are not properly escaped so when inserting data into the database we get syntax errors.

Do you have a sample line for that.
Thanks

- Mathias

On Thu, May 3, 2012 at 11:46 PM, Santhosh Vairavan <vha...@gmail.com> wrote:
>
> Hi I installed the database backup module and use it as a backup.  I was wondering if anyone had a problem with restoring the backup file back to the new database.  I have found two problems with the module.  After dropping the database and creating it again the database creation is not ended with a semicolon.  The second one is that escape characters are not properly escaped so when inserting data into the database we get syntax errors.  PLease let me know if anyone else is having these issues. Thank you.

> ________________________________
> Click here to unsubscribe from OpenMRS Implementers' mailing list

[Mathias Lin | Meta Healthcare]

Hi Santhosh,

both issues are now fixed in the latest module version (1.0), which is available via the module repository.

- Mathias

On Thu, May 3, 2012 at 11:46 PM, Santhosh Vairavan <vha...@gmail.com> wrote:

Hi I installed the database backup module and use it as a backup.  I was wondering if anyone had a problem with restoring the backup file back to the new database.  I have found two problems with the module.  After dropping the database and creating it again the database creation is not ended with a semicolon.  The second one is that escape characters are not properly escaped so when inserting data into the database we get syntax errors.  PLease let me know if anyone else is having these issues. Thank you.

[Santhosh Vairavan]

hey mathias sorry i went out of town for the last three weeks i will take a look thanks a lot for the help.