Error in Restore

Error in Restore

Hi

I accidentally ran the option reinitializeDB.bat and lost my database!
I'm trying to add my back up through the restoredb.bat but the message below:



                         Restore DB Setup Wizard
********************************************************************************
*

Execute Restore DB Utility from command prompt

        For Windows users :
                bin>restoreData -c [backup file]

        For Linux users :
                bin]#sh restoreData.sh -c [backup file]

********************************************************************************
*
FYI [SEVERE]: Please don't kill this utility until the operation is completed
 requestScheme is http
Please wait extracting backup file
Feb 9, 2010 2:01:42 AM com.adventnet.j2ee.deployment.service.internal.JarExtract
or extract
INFO: Extraction for C:\AdventNet\ME\SupportCenter\bin\Backup_scp_6500_02_05_201
0_07_14.data  to C:\AdventNet\ME\SupportCenter\bin\..
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8

Database started

*************************************************************
         Backpup data  : Fri Feb 05 07:14:21 GMT-03:00 2010
         Database name : supportcenter
         Total Tables  : 717
         Build Number  : 6500
*************************************************************



Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
====================================================


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
==========QUERY = INSERT INTO auditrecord (AUDITID,PRINCIPAL,TIMESTAMP,RECORDTYP
E) VALUES(5706, N'amamorim', 1170362885218, N'OperationAuditRecord');
java.sql.BatchUpdateException: Syntax error or access violation,  message from s
erver: "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'N'../../../../../
../../../etc/passwd' at line 1"
        at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:265)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:138)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:81)
        at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java
:317)
Unable to restore database : Syntax error or access violation,  message from ser
ver: "You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use near 'N'../../../../../..
/../../etc/passwd' at line 1"




































































                  New to ADSelfService Plus?