Hi, I'll tell you what did my provider (http://www.claranet.fr ) to upgrade from 3.23 to 4.1. They setup a new server with new hardware and a clean new 4.1.11 on it. Then I have available the old 3.23 and the new 4.1. They let me the choice on which server, the DB are created. So the customer has to do the migration by himself (dump data from 3.23 and pipe it to 4.1, after PHP code upgrade). That's the most flexible solution, you let the old server up and running, and buy a new one (thus encouraging customer to migrate, since it will be faster). Your customers will be able to migrate at their own pace, and even downgrading to 4.0 in your case, if something goes wrong.
(and yes I agree, the timestamp + 0 (don't forgot any space) is the most hitting change between 4.0 and 4.1, I had to review all timestamp field cause the app rely on it heavily ! ) Good luck ! 2005/6/25, Rubas rubas rubas <[EMAIL PROTECTED]>: > Hi! > > I'm a hosting provider with several thousands of Mysql Databases under 4.0 > version. I'm specially worried about TIMESTAMP format changes you did in > 4.1. I'll have to update database server soon to have my systems updated. > > I think that if i update my server version thousands of tables are going to > have problems with TIMESTAMP types. I was looking for solutions as to put +0 > when selecting TIMESTAMP fields. But I can't imagine to change that in > thousands lines of PHP code by hand, I'm sure lots of my customers will have > no idea about how to fix that mistake so I'll have to fix their PHP code!. > > I'm almost sure that all ISP hosting providers are having or will have this > problem soon. > > Anyone have a good idea to update servers to 4.1? Do you think that should I > update my servers, wait for a better solution in another version... What do > you think I must to do? > > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
