[root@megaraid bin]# ./backUpData.sh
Starting....
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8

Database not started. Starting .........
25.04.2008 10:40:15 com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [sh, ../bin/startDB.sh, 33367, /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/mysql/tmp]
DB_HOME /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/bin/../mysql DB_PORT 33367 TMP_HOME /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/mysql/tmp
080425 10:40:15 InnoDB: Started; log sequence number 0 469430437
080425 10:40:15 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
/backup/AdventNet/ME/ServiceDesk7/ServiceDesk/bin/../mysql/bin/mysqld: ready for connections.
Version: '4.1.18-pro' socket: '/backup/AdventNet/ME/ServiceDesk7/ServiceDesk/bin/../mysql/tmp/mysql.sock' port: 33367 MySQL Pro (Commercial)
25.04.2008 10:40:17 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: ..
25.04.2008 10:40:17 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=7.0.0}, BUILD={number=7012}}
25.04.2008 10:40:17 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
tableNames = 1067
[ creating backup_info.xml ] : true
Going to take full backup with file attachments
deleting duplicate entries in WordMap table : 0

Please wait ! backup in Progress...................
0-----------------------50------------------------100(%)
===========ERROR = *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 'columns' at line 1"*
ERROR = *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 'columns' at line 1"*
java.lang.Exception: Unable to get the data from [columns] table
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:492)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:511)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:511)
at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:240)
at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:78)
at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1020)


stopping DB Server >>>>> true
25.04.2008 10:40:29 com.adventnet.db.adapter.DBInitializer stopDBServer
INFO: Command to stop DB server [sh, ../bin/stopDB.sh, 33367, root, /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/mysql/tmp]
080425 10:40:29 [Note] /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/bin/../mysql/bin/mysqld: Normal shutdown

080425 10:40:31 InnoDB: Starting shutdown...
080425 10:40:33 InnoDB: Shutdown completed; log sequence number 0 469430487
080425 10:40:33 [Note] /backup/AdventNet/ME/ServiceDesk7/ServiceDesk/bin/../mysql/bin/mysqld: Shutdown complete

java.lang.Exception: Unable to get the data from [columns] table
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:492)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:511)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:511)
at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:240)
at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:78)
at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1020)