programguru Posted July 18, 2008 Share Posted July 18, 2008 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?? Quote Link to comment Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 Have you confirmed that the DB value is actually the same before/after? Is the php version the same? Quote Link to comment Share on other sites More sharing options...
programguru Posted July 24, 2008 Author Share Posted July 24, 2008 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 24, 2008 Share Posted July 24, 2008 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? Quote Link to comment Share on other sites More sharing options...
programguru Posted July 24, 2008 Author Share Posted July 24, 2008 mysql export dump through phpmyadmin, and then queried the dump into the new db w/ phpmyadmin. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 25, 2008 Share Posted July 25, 2008 No Windows<=>*NIX conversion? Quote Link to comment Share on other sites More sharing options...
programguru Posted July 26, 2008 Author Share Posted July 26, 2008 nope. all nix based but rh9 to rdent. Quote Link to comment Share on other sites More sharing options...
programguru Posted July 26, 2008 Author Share Posted July 26, 2008 rdent == meant rh enterpri.. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 26, 2008 Share Posted July 26, 2008 Then check the actual dump file... unless some terminator or separator changed, I find this hard to believe. Quote Link to comment Share on other sites More sharing options...
programguru Posted July 26, 2008 Author Share Posted July 26, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.