hello community, i have today upgraded one of my testserver. before i have done a upgrade to mysql 5.5 all websites works perfectly (in most case i have installed typo 3). after the mysql 5.5 upgrade, the data in the mysql databases have changed? can this be? why? i have double spaces (like <br><br>) and dataloss on each tables... what i can do that i get all databases working as with mysql 5.1 setup? can anybody help me? thanks many greets, iceget
Did you do an exact copy as test environment, especially regarding the database configuration files? Have you different default locales set? How exactly did you copy the databases? Did you pay attention to innodb files and settings? If you didn't set some, make sure default values haven't change.
Hello, I have used a backup for the test (1 day ago). I only have done a dist Upgrade froh Debian squeeze. Have tried the Upgrade with leaving the my.cnf default and one Try with New my. Cnf... After MySQL was upgraded from 5.1 to 5.5 (wheezy) i have the Problems with the database How can i check what is going wrong? I dont have Export and then after Upgrade a Import.. Thanks
actually I don't see why there should be an issue - to save time I'd just try mysqldump from old database and restore to new and see if there are errors aswell.
Hello ztk.me, thanks, i have tried this so, bot no success have done a fully mysql dump from mysql database, then i have done a upgrade and dist-upgrade (from squeeze to wheezy). after this steps from mysqlserver 5.1 to 5.5, i have this problems. have comapred the tables, the mysql database is correct... i have created (uploadet here) a screenshot from the typo3 page (squeeze / jessie). in upgrade step from squeeze to wheezy, i get the error.
You not only did a switch from 5.1 to 5.5 you did a migration from MySQL 5.1 to MariaDB 5.5 I don't think that is recommended in any way. I think the howtos should be clearer about that. You don't just switch database software. So what happens if you use mysql 5.5 on the new system?
