MySQL Forums
Forum List  »  MySQL Administrator

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),

Options: ReplyQuote


Subject
Written By
Posted
Backup not in plain text
January 21, 2010 03:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.