Hi! It is NOT safe to upgrade to 5.0 and then downgrade to 4.0 again.
http://www.innodb.com/ibman.php " IMPORTANT NOTE: if you upgrade to InnoDB-4.1.1, you cannot downgrade any more! That is because earlier versions of InnoDB are not aware of multiple tablespaces. " InnoDB-5.0.0 is essentially the same as InnoDB-4.1.1. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Sergei Golubchik" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, December 29, 2003 5:13 PM Subject: Re: MySQL 5.0.0 has been released > Hi! > > On Dec 29, Thomas Spahni wrote: > > Hi, > > > > is there any change in data format for MySQL 5.0.0? Is it safe (for a user > > of stable 4.0.17) to test 5.0.0 on existing data and then go back to > > 4.0.17 for production? > > As far as I know it should be safe. > But, of course, a backup is always recommended :) > > Regards, > Sergei > > -- > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ www.mysql.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]