sd:~/AdventNet/ME/ServiceDesk/bin# ./restoreData.sh -c ./backup_servicedesk_7018_fullbackup_08_28_2008_06_00.data
[...]
*********************************************************************************
Database not started. Starting .........
28.08.2008 9:15:28 com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [sh, ../bin/startDB.sh, 33366, /root/AdventNet/ME/ServiceDesk/mysql/tmp]
DB_HOME /root/AdventNet/ME/ServiceDesk/bin/../mysql DB_PORT 33366 TMP_HOME /root/AdventNet/ME/ServiceDesk/mysql/tmp
080828 9:15:38 InnoDB: Started; log sequence number 0 9142128
080828 9:15:38 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
/root/AdventNet/ME/ServiceDesk/bin/../mysql/bin/mysqld: ready for connections.
Version: '4.1.18-pro' socket: '/root/AdventNet/ME/ServiceDesk/bin/../mysql/tmp/mysql.sock' port: 33366 MySQL Pro (Commercial)

*************************************************************
Backpup data : Thu Aug 28 06:00:00 KRAST 2008
Database name : servicedesk
Total Tables : 1072
Build Number : 7018
*************************************************************

28.08.2008 9:15:38 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: ..
28.08.2008 9:15:38 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=7.0.0}, BUILD={number=7018}}
28.08.2008 9:15:38 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}


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


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
============================QUERY = INSERT INTO periodic (SCHEDULE_ID,START_DATE,END_DATE,TIME_PERIOD,UNIT_OF_TIME) VALUESnull
java.sql.BatchUpdateException: Syntax error or access violation, message from server: "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 '06:00:00.0, NULL, 24, 'Hours')' at line 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:84)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:317)
java.sql.BatchUpdateException: Syntax error or access violation, message from server: "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 '06:00:00.0, NULL, 24, 'Hours')' at line 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:84)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java:317)
Unable to restore database : Syntax error or access violation, message from server: "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 '06:00:00.0, NULL, 24, 'Hours')' at line 1"