Transfered MySQL w/ "/" Slash in Description Contents & Made Double New Line

[programguru]

Hello,

 

I assume this is in .ini setting. But it seems particularly odd in this scenario, so I just wanted anyones input if they've had a similar experience and possible what caused it.

 

I transfered sql from one server to another as normal, but found all content where a "/" (slash) was located, after the query was complete all descriptions that had this / were double/triple spaced like this:

 

Original: (Server version: 4.1.22-standard)

 

Hello my name / is Goyobaha Jones

 

After transfer: (Server version: 4.1.22-standard)

 

Hello my name /

 

 

is Goyobaha Goyobaha Jones

 

The slash of course stayed in tack, but appears to have "pushed" the content down acting as a /n multiple times or something.

 

Anyone know what I can do to prevent this in the future? Or what might have triggered this effect? Same mysql server version in both cases.

 

Anyone??

 

 

[fenway]

Have you confirmed that the DB value is actually the same before/after? Is the php version the same?

[programguru]

Everything is the same except when the data was transfered, there were added newlines, and the text was actually smaller font size in the phpmyadmin on the new server.

[fenway]

Everything is the same except when the data was transfered, there were added newlines, and the text was actually smaller font size in the phpmyadmin on the new server.

How was the data transferred?

[programguru]

mysql export dump through phpmyadmin, and then queried the dump into the new db w/ phpmyadmin.

[fenway]

No Windows<=>*NIX conversion?

[programguru]

nope. all nix based  but rh9 to rdent.

[programguru]

rdent == meant rh enterpri..

[fenway]

Then check the actual dump file... unless some terminator or separator changed, I find this hard to believe.

[programguru]

fenway,

I will check everything again. I agree with you it's hard to believe. But something must have been out of place I am not aware of.