Description:
When i backing up my tables using MySQL Dump & putting --where=<cond> the backup is not happening.
Because the length of <cond> string is too high, actually i put it like --where="Cust_Code IN('123456','345543','343434','343433'..........)" some 200 customer codes i put it in arguments.
Exact String:-
C:\mysql\bin\mysqldump.exe --user=myadmin --password=mysqlab --opt --add-drop-table --complete-insert --extended-insert --skip-comments --result-file="C:\Data_Backups\Temp1.txt" HiQ accounts activation agreement_renewal backlog batch_invoice box_details box_replacement box_stock current_due_details customer_information customer_master customer_notes deadwood deadwood_recovery duedate_change hp_details hp_payments network_master operator_accounts operator_activation operator_details operator_payments payments scheme_updates subbase_change subs_transfer subscription transfer_details vc_replacement --where="cust_code in ('221000600122','221000600957','221000601450','221000601856','221000601898','221000601922','221000602045','221000602052','221000602409','221000602417','221000602946','221000602961','221000602995','221000603472','221000603514','221000603522','221000603530','221000603548','221000603555','221000603571','221000603589','221000603605','221000603639','221000603662','221000603720','221000603779','221000603795','221000603803','221000604173','221000604207','221000604546','221000605154','221000605451','221000605600','221000605618','221000605634','221000605667','221000605675','221000605691','221000605709','221000606301','221000606319','221000606368','221000606376','221000606392','221000606467','221000606483','221000606491','221000606525','221000606533','221000606681','221000607036','221000607069','221000607127','221000607473','221000607499','221000607549','221000607556','221000607564','221000607861','221000608257','221000608273','221000608331','221000608547','221000608604','221000609800','221000609818','221000609891','221000610014','221000610089','221000610428','221000610485','221000610493','221000610535','221000610600','221000610626','221000610634','221000610956','221000611053','221000611079','221000611244','221000611541','221000611657','221000611723','221000611954','221000612036','221000612267','221000612341','221000613430','221000613554','221000613638','221000613661','221000613802','221000613828','221000613935','221000613984','221000614040','221000614339','221000614354','221000614362','221000614370','221000614388','221000614396','221000614552','221000614891','221000614917','221000615047','221000615245','221000615344','221000615369','221000615500','221000615773','221000615823','221000616516','221000616557','221000616565','221000616615','221000616656','221000616664','221000616672','221000618223','221000618272','221000618280','221000618298','221000618348','221000618421','221000618439','221000618454','221000618462','221000618512','221000618546','221000618553','221000618561','221000618579','221000618678','221000618686','221000618777','221000618843','221000618850','221000618868','221000618892','221000618934','221000618942','221000618959','221000619031','221000619056','221000619312','221000619320','221000619387','221000619445','221000620526','221000620740','221000620773','221000621458','221000621516','221000621698','221000621722','221000621979','221000621987','221000622050','221000622092','221000622332','221000622456','221000622506','221000622688','221000622746','221000623215','221000623231','221000623256','221000623264','221000623272','221000623322','221000623355','221000623371','221000623413','221000623470','221000623488','221000624064','221000624114','221000624130','221000625160','221000625202','221000625236','221000625988','221000626119','221000626143','221000626663','221000626689','221000626838','221000626960','221000626994','221000627059','221000627133','221000627174','221000627554','221000627570','221000627604','221000628446','221000628461','221000628560','221000629063','221000629071','221000629196','221000629477','221000629535','221000629790','221000629816','221000630541','221000630640','221000630673','221000630764','221000630780','221000631242','221000631762','221000632182','221000632232','221000632299','221000632638','221000632687','221000632984','221000633016','221000633156','221000633263','221000633339','221000633446','221000633594','221000633768','221000633859','221000633883','221000633925','221000633974','221000634014','221000634071','221000634238','221000634279','221000634303','221000634444','221000634477','221000634485','221000634667','221000634949','221000634972','221000635102','221000635144','221000635185','221000635235','221000635268','221000635391','221000635433','221000635532','221000635920','221000636084','221000636100','221000636126','221000636167','221000636175','221000636795','221000637009','221000637074','221000637082','221000637173','221000637181','221000637314','221000637389','221000637421','221000637561','221000637587','221000637751','221000637769','221000637777','221000637793','221000637892','221000638023','221000638171','221000638403','221000638445','221000638452','221000638486','221000638551','221000638767','221000638940','221000638981','221000639062','221000639286','221000639294','221000639302','221000639336','221000639351','221000639393','221000639443','221000639930','221000640052','221000640276','221000640284','221000640359','221000640466','221000640664','221000641449','221000641704','221000641910','221000641969','221000642066','221000642363','221000643106','221000643825','221000644187','221000644559','221000644591','221000644948','221000645234','221000645325','221000645382','221000645929','221000646083','221000646364','221000646620','221000646729','221000646943','221000647826','221000647909','221000647990','221000648220','221000648311','221000648360','221000648378','221000648600','221000648758','221000649020','221000649038','221000649053','221000649079','221000649335','221000649343','221000649517','221000649525','221000649897','221000649913','221000649921','221000649939','221000650010','221000650200','221000650408','221000650671','221000650713','221000651083','221000651216','221000651471','221000651497','221000651505','221000651752','221000652438','221000652503','221000652552','221000652669','221000652750','221000652784','221000652859','221000653063','221000653287','221000653451','221000653857','221000653865','221000654061','221000654160','221000654178','221000654210','221000654236','221000654368','221000654392','221000654707','221000654715','221000654723','221000654905','221000654921','221000655084','221000655167','221000655571','221000655621','221000655795','221000655845','221000655860','221000656041','221000656058','221000656074','221000656199','221000656371','221000656488','221000656504','221000656553','221000656751','221000656868','221000656876','221000656884','221000656892','221000656926','221000657031','221000657106','221000657114','221000657122','221000657148','221000657304','221000657387','221000657411','221000657726','221000657817','221000657874','221000657957','221000657973','221000658021','221000658070','221000658187','221000658195','221000658302','221000658344','221000658377','221000658658','221000658666','221000658773','221000658781','221000658799','221000658906','221000658948','221000659045','221000659052','221000659060','221000659151','221000659169','221000659185','221000659334','221000659649','221000659755','221000659821','221000660019','221000660035','221000660043','221000660092','221000660217','221000660407','221000660415','221000660456','221000660571','221000660597','221000660811','221000660860','221000661025','221000661041','221000661066','221000661074','221000661082','221000661421','221000661876','221000661884','221000662056','221000662148','221000662700','221000662791','221000662833','221000662890','221000662908','221000662916','221000662940','221000662999','221000663005','221000663013','221000663021','221000663047','221000663104','221000663112','221000663138','221000663310','221000663328','221000663351','221000663473','221000663516','221000663543','221000663598','221000663641','221000663794','221000663838','221000663954','221000663990','221000664052','221000664061','221000664098','221000664150','221000664169','221000664454','221000664551','221000664579','221000664739','221000664766','221000664962','221000665015','221000665079','221000665275','221000665293','221000665300','221000665319','221000665328','221000665408','221000665426','221000665523','221000665569','221000665578','221000665667','221000665676','221000665685','221000665836','221000665863','221000666041','221000666149','221000666194','221000666201','221000666265','221000666345','221000666443','221000666452','221000666461','221000666489','221000666513','221000666657','221000666719','221000666826','221000666880','221000666906')"
How to repeat:
again and again it's not at all backing up tables.
Suggested fix:
I don't find any fix to this problem
Description: When i backing up my tables using MySQL Dump & putting --where=<cond> the backup is not happening. Because the length of <cond> string is too high, actually i put it like --where="Cust_Code IN('123456','345543','343434','343433'..........)" some 200 customer codes i put it in arguments. Exact String:- C:\mysql\bin\mysqldump.exe --user=myadmin --password=mysqlab --opt --add-drop-table --complete-insert --extended-insert --skip-comments --result-file="C:\Data_Backups\Temp1.txt" HiQ accounts activation agreement_renewal backlog batch_invoice box_details box_replacement box_stock current_due_details customer_information customer_master customer_notes deadwood deadwood_recovery duedate_change hp_details hp_payments network_master operator_accounts operator_activation operator_details operator_payments payments scheme_updates subbase_change subs_transfer subscription transfer_details vc_replacement --where="cust_code in ('221000600122','221000600957','221000601450','221000601856','221000601898','221000601922','221000602045','221000602052','221000602409','221000602417','221000602946','221000602961','221000602995','221000603472','221000603514','221000603522','221000603530','221000603548','221000603555','221000603571','221000603589','221000603605','221000603639','221000603662','221000603720','221000603779','221000603795','221000603803','221000604173','221000604207','221000604546','221000605154','221000605451','221000605600','221000605618','221000605634','221000605667','221000605675','221000605691','221000605709','221000606301','221000606319','221000606368','221000606376','221000606392','221000606467','221000606483','221000606491','221000606525','221000606533','221000606681','221000607036','221000607069','221000607127','221000607473','221000607499','221000607549','221000607556','221000607564','221000607861','221000608257','221000608273','221000608331','221000608547','221000608604','221000609800','221000609818','221000609891','221000610014','221000610089','221000610428','221000610485','221000610493','221000610535','221000610600','221000610626','221000610634','221000610956','221000611053','221000611079','221000611244','221000611541','221000611657','221000611723','221000611954','221000612036','221000612267','221000612341','221000613430','221000613554','221000613638','221000613661','221000613802','221000613828','221000613935','221000613984','221000614040','221000614339','221000614354','221000614362','221000614370','221000614388','221000614396','221000614552','221000614891','221000614917','221000615047','221000615245','221000615344','221000615369','221000615500','221000615773','221000615823','221000616516','221000616557','221000616565','221000616615','221000616656','221000616664','221000616672','221000618223','221000618272','221000618280','221000618298','221000618348','221000618421','221000618439','221000618454','221000618462','221000618512','221000618546','221000618553','221000618561','221000618579','221000618678','221000618686','221000618777','221000618843','221000618850','221000618868','221000618892','221000618934','221000618942','221000618959','221000619031','221000619056','221000619312','221000619320','221000619387','221000619445','221000620526','221000620740','221000620773','221000621458','221000621516','221000621698','221000621722','221000621979','221000621987','221000622050','221000622092','221000622332','221000622456','221000622506','221000622688','221000622746','221000623215','221000623231','221000623256','221000623264','221000623272','221000623322','221000623355','221000623371','221000623413','221000623470','221000623488','221000624064','221000624114','221000624130','221000625160','221000625202','221000625236','221000625988','221000626119','221000626143','221000626663','221000626689','221000626838','221000626960','221000626994','221000627059','221000627133','221000627174','221000627554','221000627570','221000627604','221000628446','221000628461','221000628560','221000629063','221000629071','221000629196','221000629477','221000629535','221000629790','221000629816','221000630541','221000630640','221000630673','221000630764','221000630780','221000631242','221000631762','221000632182','221000632232','221000632299','221000632638','221000632687','221000632984','221000633016','221000633156','221000633263','221000633339','221000633446','221000633594','221000633768','221000633859','221000633883','221000633925','221000633974','221000634014','221000634071','221000634238','221000634279','221000634303','221000634444','221000634477','221000634485','221000634667','221000634949','221000634972','221000635102','221000635144','221000635185','221000635235','221000635268','221000635391','221000635433','221000635532','221000635920','221000636084','221000636100','221000636126','221000636167','221000636175','221000636795','221000637009','221000637074','221000637082','221000637173','221000637181','221000637314','221000637389','221000637421','221000637561','221000637587','221000637751','221000637769','221000637777','221000637793','221000637892','221000638023','221000638171','221000638403','221000638445','221000638452','221000638486','221000638551','221000638767','221000638940','221000638981','221000639062','221000639286','221000639294','221000639302','221000639336','221000639351','221000639393','221000639443','221000639930','221000640052','221000640276','221000640284','221000640359','221000640466','221000640664','221000641449','221000641704','221000641910','221000641969','221000642066','221000642363','221000643106','221000643825','221000644187','221000644559','221000644591','221000644948','221000645234','221000645325','221000645382','221000645929','221000646083','221000646364','221000646620','221000646729','221000646943','221000647826','221000647909','221000647990','221000648220','221000648311','221000648360','221000648378','221000648600','221000648758','221000649020','221000649038','221000649053','221000649079','221000649335','221000649343','221000649517','221000649525','221000649897','221000649913','221000649921','221000649939','221000650010','221000650200','221000650408','221000650671','221000650713','221000651083','221000651216','221000651471','221000651497','221000651505','221000651752','221000652438','221000652503','221000652552','221000652669','221000652750','221000652784','221000652859','221000653063','221000653287','221000653451','221000653857','221000653865','221000654061','221000654160','221000654178','221000654210','221000654236','221000654368','221000654392','221000654707','221000654715','221000654723','221000654905','221000654921','221000655084','221000655167','221000655571','221000655621','221000655795','221000655845','221000655860','221000656041','221000656058','221000656074','221000656199','221000656371','221000656488','221000656504','221000656553','221000656751','221000656868','221000656876','221000656884','221000656892','221000656926','221000657031','221000657106','221000657114','221000657122','221000657148','221000657304','221000657387','221000657411','221000657726','221000657817','221000657874','221000657957','221000657973','221000658021','221000658070','221000658187','221000658195','221000658302','221000658344','221000658377','221000658658','221000658666','221000658773','221000658781','221000658799','221000658906','221000658948','221000659045','221000659052','221000659060','221000659151','221000659169','221000659185','221000659334','221000659649','221000659755','221000659821','221000660019','221000660035','221000660043','221000660092','221000660217','221000660407','221000660415','221000660456','221000660571','221000660597','221000660811','221000660860','221000661025','221000661041','221000661066','221000661074','221000661082','221000661421','221000661876','221000661884','221000662056','221000662148','221000662700','221000662791','221000662833','221000662890','221000662908','221000662916','221000662940','221000662999','221000663005','221000663013','221000663021','221000663047','221000663104','221000663112','221000663138','221000663310','221000663328','221000663351','221000663473','221000663516','221000663543','221000663598','221000663641','221000663794','221000663838','221000663954','221000663990','221000664052','221000664061','221000664098','221000664150','221000664169','221000664454','221000664551','221000664579','221000664739','221000664766','221000664962','221000665015','221000665079','221000665275','221000665293','221000665300','221000665319','221000665328','221000665408','221000665426','221000665523','221000665569','221000665578','221000665667','221000665676','221000665685','221000665836','221000665863','221000666041','221000666149','221000666194','221000666201','221000666265','221000666345','221000666443','221000666452','221000666461','221000666489','221000666513','221000666657','221000666719','221000666826','221000666880','221000666906')" How to repeat: again and again it's not at all backing up tables. Suggested fix: I don't find any fix to this problem