Restoring mysql data to postgres fail
HI,
I am getting below error while restoring from backup. Can anyone please help on this?
Regards.
Hasan
You chose to open this file: C:\ManageEngine\backup\backup_mysql_9200_fullbackup_05_06_2021_12_22\backup_mysql_9200_fullbackup_05_06_2021_12_22_part_1.data
File name is : C:\ManageEngine\backup\backup_mysql_9200_fullbackup_05_06_2021_12_22\backup_mysql_9200_fullbackup_05_06_2021_12_22_part_1.data
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Not Replaced File: startDB.bat
Not Replaced File: wrapper.conf
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Backpup data : Thu May 06 12:22:31 GST 2021
Database name : servicedesk
Total Tables : 1383
Database Server : mysql
Build Number : 9200
localhost:65432 - no response
localhost:65432 - accepting connections
Active DB Server = postgres
Database connectionProp : null
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
==================================QUERY = INSERT INTO WorkOrder (WORKORDERID,REQUESTERID,CREATEDBYID,CREATEDTIME,RESPONDEDTIME,DUEBYTIME,COMPLETEDTIME,TIMESPENTONREQ,TITLE,DESCRIPTION,MODEID,SLAID,WORKSTATIONID,DEPTID,SITEID,AUTOCLOSETIME,CLOSEAUTHKEY,ISPARENT,TEMPLATEID,SERVICEID,IS_CATALOG_TEMPLATE,FR_DUETIME,HASCHANGE,HASPROBLEM,SURVEYSTATUS,HASDRAFT,HASCAUSEDBYCHANGE,RESOLVEDTIME,OBOID,HASDEPENDENCY,HASPROJECT,CIID) VALUES(14, 319, 1, 1251258180128, 0, -1, 1265802328774, 4101320000, N'FW: SLWP PO - PP - 0920 - Carbon Area - CM - 6668 - Request ID : [##13##]', N' Details of Rejected Material From: Habib Zinali Sent: Thursday, August 06, 2009 4:50 PM To: Wajeed Ahmed Cc: Saifulla Baig Subject: FW: SLWP PO - PP - 0920 - Carbon Area - CM - 6668 - FYI Regards Habib Zinali Expeditor . Supply chain Gerab National Enterprises P.O Box 17719, Dubai, UAE T: +971 4 8065811 M: +971 50 181 3021 F: +971 4 8065861 www.gerabgroup.com From: mic.mech@target.ae [mailto:mic.mech@target.ae] Sent: Thursday, A...', 1, NULL, NULL, NULL, NULL, NULL, NULL, '0', 5, NULL, '0', 0, '0', '0', 0, '0', '0', 0, NULL, '0', '0', NULL);
Unable to restore database : Batch entry 0 INSERT INTO WorkOrder (WORKORDERID,REQUESTERID,CREATEDBYID,CREATEDTIME,RESPONDEDTIME,DUEBYTIME,COMPLETEDTIME,TIMESPENTONREQ,TITLE,DESCRIPTION,MODEID,SLAID,WORKSTATIONID,DEPTID,SITEID,AUTOCLOSETIME,CLOSEAUTHKEY,ISPARENT,TEMPLATEID,SERVICEID,IS_CATALOG_TEMPLATE,FR_DUETIME,HASCHANGE,HASPROBLEM,SURVEYSTATUS,HASDRAFT,HASCAUSEDBYCHANGE,RESOLVEDTIME,OBOID,HASDEPENDENCY,HASPROJECT,CIID) VALUES(1, 479, 1, 1250514259930, 1254723102913, 1251176406811, 1266060139747, 4440529000, 'FW: Problems in TC - LPO MED 391603 - 16" X 6" SCH 80 CS BRANCH OUTLET (4 NOS) - 16" Saih Nihayda pipeline project', 'Dear Rupesh, We will check the same with our QA team and will revert back. Best Regards,Abu Thahir Sales Engineer .Commercial DeptArab Desert L.L.CP.O ,PC:112, Ruwi, Sultanate of OmanT: +968 24816444 -Extn: 24F: +968 24813308www.gerabgroup.com Box 3915 From: Rupesh [mailto:rupesh@galfar.com] Sent: Monday, August 17, 2009 3:41 PMTo: Abu ThahirCc: Saif Sait; Nasser Mubarak Alqasmi; ''Sukumaran - O&G''; Anwar - QA; ''Vimal U R.''; ''Galfar Engg. & Cont. SAOG (QLM ODC)''; ''Amit A.Deode - MMU''Subj...', 1, NULL, NULL, 302, 304, NULL, 1265827160461, '1', 5, NULL, '0', 0, '0', '0', 0, '0', '0', 0, NULL, '0', '0', NULL) was aborted. Call getNextException to see the cause.
Batch entry 0 INSERT INTO WorkOrder (WORKORDERID,REQUESTERID,CREATEDBYID,CREATEDTIME,RESPONDEDTIME,DUEBYTIME,COMPLETEDTIME,TIMESPENTONREQ,TITLE,DESCRIPTION,MODEID,SLAID,WORKSTATIONID,DEPTID,SITEID,AUTOCLOSETIME,CLOSEAUTHKEY,ISPARENT,TEMPLATEID,SERVICEID,IS_CATALOG_TEMPLATE,FR_DUETIME,HASCHANGE,HASPROBLEM,SURVEYSTATUS,HASDRAFT,HASCAUSEDBYCHANGE,RESOLVEDTIME,OBOID,HASDEPENDENCY,HASPROJECT,CIID) VALUES(1, 479, 1, 1250514259930, 1254723102913, 1251176406811, 1266060139747, 4440529000, 'FW: Problems in TC - LPO MED 391603 - 16" X 6" SCH 80 CS BRANCH OUTLET (4 NOS) - 16" Saih Nihayda pipeline project', 'Dear Rupesh, We will check the same with our QA team and will revert back. Best Regards,Abu Thahir Sales Engineer .Commercial DeptArab Desert L.L.CP.O ,PC:112, Ruwi, Sultanate of OmanT: +968 24816444 -Extn: 24F: +968 24813308www.gerabgroup.com Box 3915 From: Rupesh [mailto:rupesh@galfar.com] Sent: Monday, August 17, 2009 3:41 PMTo: Abu ThahirCc: Saif Sait; Nasser Mubarak Alqasmi; ''Sukumaran - O&G''; Anwar - QA; ''Vimal U R.''; ''Galfar Engg. & Cont. SAOG (QLM ODC)''; ''Amit A.Deode - MMU''Subj...', 1, NULL, NULL, 302, 304, NULL, 1265827160461, '1', 5, NULL, '0', 0, '0', '0', 0, '0', '0', 0, NULL, '0', '0', NULL) was aborted. Call getNextException to see the cause.
localhost:65432 - accepting connections
localhost:65432 - accepting connections
localhost:65432 - rejecting connections
localhost:65432 - rejecting connections
localhost:65432 - no response