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"