MySQL Export through phpmyadmin

[KA_Curtis]

Hi,

Any idea what would cause an exported db to have characters like these:

[quote]
0x613a31333a7b733a323a226964223b693a313b733a37 3a2264656661756c74223b693a303b733a363a226c61796f7574 223b693a313b733a343a226e616d65223b733a343a2264656d6f 223b733a333a22637373223b733a31323a2266726f6e74656e64 2e637373223b733a383a2268746d6c68656164223b733a34313 23a223c7374796c6520747970653d22746578742f637373223e0 d0a3c212d2d0d0a2e6d656e756267207b0d0a096261636b6772 6f756e642d696d6167653a2075726c28696d616765732f64656d 6f70687077636d735f72325f63322e676966293b0d0a096261636 b67726f756e642d7265706561743a206e6f2d7265706561743b0 d0a096261636b67726f756e642d706f736974696f6e3a206c6566
[ /quote]

Note: I added linebreaks to make it more forum friendly.

Everything else looks okay, so it's not like it's compressed or anything. This has happened 3 times all backups from phpmyadmin and each time the section that deals with content from an installed cms (phpwcms) is encrypted or something.

Has anyone seen this before? Know of anyway to change it so I can import into a new db. The example text is creating errors that stop it from importing.

Thanks,

[coopster]

Looks like hexadecimal data to me. Probably serialized as well. Try this...

function hex_to_ascii($hex) { 
 $ascii = ''; 
 $length = strlen($hex); 
 for ($i = 0; $i < $length; $i += 2) { 
  $ascii .= chr(hexdec(substr($hex, $i, 2))); 
 } 
 return $ascii; 
} 
print hex_to_ascii($myvalue);

[KA_Curtis]

hi thanks for replying. How would I do that? Should the script be formatted as php or? Although I've messed around with scripting I more or less a newbie when it comes to actually doing something of value. :)

thanks

[KA_Curtis]

Hi I tried converting it to ascii with bbedit and it didn't give me any changes. either there's a problem with bbedit or there wasn't anything it could do with it.

[jatar_k]

is it from one specific column? do the column names give you any hints as to what it might be? have you taken a look at the code that inserts to mysql to see if you can figure out what it is doing?

[KA_Curtis]

Hi,

It is the content part of the cms, when importing ex:

INSERT INTO `om_version_content` VALUES ('2.2', 18, 'textareanametext', 1, 0x53946d746c6963686520417274696b656c20756e642042696c64657220 73696e6420766f6e20646572205b625d4f6e6c696e6520417573676162652 0646573205370696567656c735b2f625d206b6f706965727420756e642064 69656e656e20686965722064656d20426569737069656c2066b8722065...

It seems that maybe the content is encrypted, but I dont' know for sure. I have posted on the cms' support forum, but nobody has replied yet.