Daniel, ----- Original Message ----- From: "Daniel Kasak" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 2:22 AM Subject: Quick & Nasty upgrade...
> Hi all. > > I am running MySQL-4.0.4 and have just compiled 4.0.5. > On the MySQL website, I found a bit that says: > > > You can always move the MySQL form and datafiles between different > > versions on the same architecture as long as you have the same base > > version of MySQL. > > So does this mean I can do a 'make install' and then dump my old > /usr/local/mysql/var directory on top of the new one and all will be OK? > I am using MyISAM and InnoDB tables. > Or should I use the 'safe' method of backing up with mysqldump and > importing into the new install? > Thanks! MyISAM and InnoDB tables of 3.23 can be used in 4.0 without any changes. Thus the 'quick & dirty' upgrade of simply installing MySQL-4.0 over MySQL-3.23 works. Similarly, you can simply install 4.0.5 over 4.0.4. MySQL has a history that upgrades have always been possible without dumping and reimporting the tables. > -- > Daniel Kasak > IT Developer > * NUS Consulting Group* > Level 18, 168 Walker Street > North Sydney, NSW, Australia 2060 > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > email: [EMAIL PROTECTED] > website: www.nusconsulting.com Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php