Hello Anselme, I did the same job few days ago, upgrading my 3.23.52-max-debug MyIsam tables to 4.0.13 InnoDB tables on a database of about 35 MB storage. I found the most quick way to upgrade the database is exporting the old one from 3.53 server by a mysqldump, reimporting as a plain MyIsam database (as you did, if I well understood) and next applying the alter table commands necessary to change the type of tables, and adding foreign key constaints (with table data already present). I had to correct few little things, having found some relational inconsistency on my data (some orphan row, and so forth). I tried also the way to redefine tables recreating them as InnoDB, defining foreign key constraints and finally importing data. The time employed in this way is *MUCH* longer than the first one (about 2 hours against 5 minutes on a Intel Celeron 1.1 GHz, 240 MB RAM, MSWindows OS!!!). Hoping to have been helpful,
best regards, Marco Barbato http://www.betaingegneria.it ----- Original Message ----- From: "Anselme" <[EMAIL PROTECTED]> To: "Mysql_MailingList" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 11:27 AM Subject: upgrade mysql3.23.55 to mysql4.0 > Hi Everybody, > > I am running mysql3.23.55 on a FreeBSD4.8 > > I would like to upgrade to MySql4.0 and I need some help :) > > Is the following way the right way to do : > > I do a mysqldump --add-drop-table with all my databases (included the > 'mysql' one) > > I run > #portinstall -rR mysql4.0 > > and then > # mysql -uroot -p mysql < mysql.sql > > and the same for all my databases ? > > And what about php and jdbc ? Do I need to do something else ? > > Thank you for any help > > > -- > Anselme <[EMAIL PROTECTED]> > > > -- > 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]
