472,779 Members | 2,833 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,779 software developers and data experts.

Pitfalls for upgrading: 3.23 => 4.1

Dear newsies,

My ISP has offered to upgrade my servers from 3.23 to 4.1.

I'm excited by the potential gains in performance, and the ability to
write subqueries, but am wary of any forward incompatibilities. I have
a mass of PHP code with MySQL throughout. I don't relish peeking into
every file and making a determination of 'it should work' by eyeballs
alone.

What do I need to watch out for? Or where can I find a nice summary of
differences between the versions?

Thanks!
Jul 20 '05 #1
2 1568
wellington fan wrote:
What do I need to watch out for? Or where can I find a nice summary of
differences between the versions?


Read these upgrade guides:
http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html
http://dev.mysql.com/doc/mysql/en/Up...from-3.23.html

You can read the changes in 4.0 and 4.1 here:
http://dev.mysql.com/doc/mysql/en/News-4.1.x.html
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html

I'd suggest googling through newsgroup archives for other folks' stories
about upgrading. I tried one search for simply "mysql" "upgrade" and
found a bunch of hits. Many of the issues are probably already noted in
the Upgrading web pages above.

And, though this should already be in place, create and verify backups
of your databases first!

Regards,
Bill K.
Jul 20 '05 #2
Thanks for the pointers Bill... I will check them out.
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: S. Crespel | last post by:
Hi, Where can I find informations about consequences of upgrading from PHP 4.2.3 to 4.3 regarding existing PHP applications ? I have lots of existing PHP (4.2.3) scripts, will everything still...
2
by: wellington fan | last post by:
Dear newsies, My ISP has offered to upgrade my servers from 3.23 to 4.1. I'm excited by the potential gains in performance, and the ability to write subqueries, but am wary of any forward...
5
by: Mike Owen | last post by:
Hi, I have just used the import Wizard to import a VS 2003 app to VS 2005. I have a lot of work to do to enable it to compile successfully with all the errors and warnings it gave me, but as a...
11
by: Aidan Tobin | last post by:
Hi, I have to upgrade a number of databases from Access 2.0, Access 97 and Access 2000 to work in Office 2003. These databases contain a number of Forms coded with VBA as well as a number of...
1
by: spamfurnace | last post by:
Hello. I have a common area of a website that sales agents use. I got sick and tired of typing response.redirect(path) so i implemented a shared function in Global that i can call and all i have...
1
by: progTiger | last post by:
The upgrade wizard just hangs on step 5 of 5 when it reaches "Upgrading DataEnvironment..." I have let it sit for 3 hours and it does nothing. .Net Studio is not frozen, but the process does...
6
by: JimLad | last post by:
Hi, We have a major ASP app that we are in the process of upgrading to ASP.NET 1.1 and probably on to ASP.NET 2.0 in the middle of next year. (We will also be upgrading to SQL2K5 at the same...
3
by: abbu | last post by:
Hi All, I have just finished my graduation. I'am attending my interviews for software companies. If any one has the book "C Traps and Pitfalls" please send it as attachment across to my mail...
1
by: Mark Ingram | last post by:
Hi, I'm in the middle of upgrading our code with VC8, but when I include <dequeI get the following errors: warning C4995: 'gets': name was marked as #pragma deprecated warning C4995: 'sprintf':...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.