problem moving database

[tonyw]

hi, I need to move a mysql database from a shaky old server to a lovely new one somewhere else.

I dump the database using the supplied phpMyAdmin 2.1.0 then load it back up again using the new servers 2.5.2-pl1

It all works except for my TEXT fields which now have &lt and &gt instead of < and > which is rather annoying. It's the dump that is inserting these.

short of searching and replacing all the text fields in the new database, is there a nifty trick i can use to make it dump the way i want?

If need be i can stick another phpMyAdmin up there and dump from that if it lets me control this issue...

thanks
tony

[Frederick]

Create a script to loop through your tables and str_replace() the characters.

$value = str_replace("&lt","<",$row["value"]);
$value = str_replace("&gt",">",$value);
// Run UPDATE query