I would do it like this: 1 - Stop iMS services 2 - Upscale database to MySQL 3 - Change all DSource.cfm files to point to the new MySQL db (you need to specify the datasource name and the db type as MySQL). 4 - Restart iMS services
The only things that changes all of the FusionMail code for MySQL are the DSource.cfm files. You may also need to restart CF... You can also try this on a dev server so that there are no surprises. HTH, Howie ----- Original Message ----- From: "Sean Hynes" <[EMAIL PROTECTED]> To: "inFusion Support List inFusion Support List" <[EMAIL PROTECTED]@eoscape.com> Sent: Tuesday, June 15, 2004 12:25 PM Subject: [iMS] mysql UPGRADE Plan > THank you Howie, I always think everything is in the iMS directory, I keep > my templates elsewhere. > ALSO, > > Can you review is my plan for upgrading from MSACESS to MYSQL. > > Install Mysql database, and configure ALL FUSIONMIAL FILES IN a new Directory. > Warn all clients to check mail by XX date > Then in the Middle of that night, change the Template FILE PATH to new > MySQL directory. > Offer an OLD URL to get all OLD EMAIL via the COOLFUSION web based interface. > Test all night. > If problem, change template directory back to MSAccess one. > > DOES That sound like a good plan? > Any things I need to change in terms of templates or code? > ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------------------------------------------------------- This list is provided as a free service. Although we will try to address issues in a timely manner, support via this list is not guaranteed. If you require expedited support then a support contract is required. Support may be purchased from http://www.coolfusion.com/commerce. Details regarding support options may be reviewed at: http://www.coolfusion.com/SupportOptions.cfm -------------------------------------------------------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/Support/ Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/Developers/ List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [EMAIL PROTECTED] ==^=======================================================
