03/17/2004: MySQL Upgrade - Reseller Hosting, Shared Hosting, Dedicated Hosting by Vortech Inc.

Carly · #1 03-15-2004, 09:36 PM

MySQL on HSphere will be upgraded to 4.0.18 this Wednesday, March 17th, 2004. The upgrade will take place in the evening, around 8pm EST. Downtime for the MySQL servers may be up to one hour, but we will do all we can to make the downtime minimal.

This is a major version increase from 3.x->4.x so we highly suggest you ensure that your script is compatible (It should be) and that you have a backup of your database.

** I believe the announcement that went out said March 18th, but it is Wednesday, March 17th **

***jazzimac*** · #2 03-16-2004, 09:37 AM

Can anyone verify that OsCommerce 2.2 MS1 will continue to function after the upgrade? I've searched the OSC forums, but haven't had any luck. Was hoping someone here more knowledgeable with MySQL could provide some peace of mind. Many thanks!

***nhdonny*** · #3 03-16-2004, 10:34 AM

Quote:

Originally Posted by Carly

I believe the announcement that went out said March 18th, but it is Wednesday, March 17th **

Will you be drinking Vixens Green Vodka during the upgrade?

***Vixen*** · #4 03-16-2004, 10:58 AM

Vixen will be at home, which is where the vodka will be also.

#5 03-16-2004, 02:40 PM

OsCommerce will still work. I really doubt anything will break as MySQL4 is backwards compatible with MySQL3 provided you are using it properly

***jazzimac*** · #6 03-16-2004, 03:05 PM

Thanks Bladesnitz! Just wanted to make sure.

#7 03-17-2004, 09:04 PM

Hopefully we will not loss any databases durning this upgrade

.

***porpoise*** · #8 03-21-2004, 11:31 AM

I have a PHP script that ran using a CRON job. This script had contained a command to create a TEMPORARY TABLE in my MySQL database (using MyISAM tables). Since the upgrade, the script was no longer able to create TEMPORARY TABLES.

In my case, I was able to create a simple work-around by creating a regular table and then at the end of the script adding a command to drop that table.

Just FYI.

abdu5hahid · #9 03-28-2004, 01:07 PM

When will Vortech be moving to MySQL 5 or whatever the new version is that allows for stored procedures in MySQL?

***admin*** · #10 03-28-2004, 05:31 PM

We just got to mysql4 I don't see mysql 5 coming any time soon that I know of.

***admin*** · #11 03-28-2004, 05:33 PM

MySQL 4.0 -- Production release (recommended)
MySQL 4.1 -- Alpha release (use this for new development)
MySQL 5.0 -- Development tree (use this for previewing and testing new features)

5.0 is a long was away. We only use Production release if we can.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Major Network Upgrade 5/5/2004	admin	Network / Server Status	58	05-23-2004 06:29 PM
Network Upgrade 5/16/2004	admin	Network / Server Status	13	05-17-2004 11:34 AM
03/17/2004: MySQL Upgrade	Bladesnitz	Network / Server Status	4	03-17-2004 11:32 PM
03/04/2004 - cp.hsphere.cc - upgrade	bigdave	Network / Server Status	1	03-04-2004 11:34 PM
MySQL needs an upgrade	somereseller	Chit Chat Public	0	03-03-2003 06:35 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)