Backup not in plain text
Posted by:
John Dunn
Date: January 21, 2010 03:08AM
I am new to mysql.
I want to be able to dump table data to a text file, bulk edit some values and reload.
However when I run backup from MYSQL Administrator the data is not output in plain text. The file contains lines like the following.
How can I dump the data in plain text and then reload the data?
(0x494E464F5052494E5432,NULL,NULL,NULL,0x48424F53,0x53544152544544,0x4552524F52,0x53595354454D5F414C4C,NULL,0,0,0,NULL,NULL,0x52756E6E696E6720556E697820436F6D6D616E64202F686F6D652F70726F64756365722F7072696E7465725F736372697074732F46726565466C6F774950505072696E7465725374617475732E7079202D544D50202F686F6D652F70726F64756365722F747261666669632F74656D70202D455252202F686F6D652F70726F64756365722F747261666669632F74656D702F7072696E7465727374617475735F494E464F5052494E54322E657272202D4F5554202F686F6D652F70726F64756365722F747261666669632F74656D702F7072696E7465727374617475735F494E464F5052494E54322E786D6C20202D44454255475F46494C45202F686F6D652F70726F647563657231327379732F6C6F672F66726565666C6F776970702E6C6F67202D534552564943455F434C41535320636F6D2E73656661732E70726F64756365722E706C7567696E2E7072696E7465727479706566756C6C2E73657276696365732E5072696E7465725479706546756C6C506C7567696E20202D5043202F686F6D652F70726F64756365722F72656D616B652F66726565666C6F77636F6D706C6574696F6E202D5052494E5445525F545950452046524545464C4F574950202D50525120687474703A2F2F31302E352E322E3433202D4E414D4520494E464F5052494E5432202D4853542031302E352E322E34332072657475726E65642031,'',NULL,0x59,'2010-01-18 18:17:36','',NULL,NULL,NULL,NULL,0,0x4E,NULL,0x4E,0x4E,NULL,NULL,0x4E,0x4E,0x4E4F4E45,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,0x4E),