473,372 Members | 820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

upgrading from 4.1.12 to 5.0.1

my question is can i just install the new version of mysql, stop the
old, point the data directory for the new one to the data directory and
just start up mysql 5? or do i need to take some extra steps int eh
process. also is there any data corruption possible in the process i
described

Dec 14 '05 #1
5 1581
"Shiraz" <sh*****@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
my question is can i just install the new version of mysql, stop the
old, point the data directory for the new one to the data directory and
just start up mysql 5? or do i need to take some extra steps int eh
process. also is there any data corruption possible in the process i
described


There is always data corruption possible! A system admin friend of mine
said, "always assume the computer is out to get you... not users in general,
but YOU. It's personal."

First, read the following pages, and perform the recommended steps.
Consider if your databases or applications use any of the features for which
there are incompatible changes between 4.1 and 5.0.
http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

Back up your databases under MySQL 4.1, then then restore the databases
using MySQL 5.0. That is the safer procedure. Plus you have a backup
(which should be your daily habit already).

I recommend against configuring two instances of MySQL to use the same data
directory, because if both of them are running simultaneously, they are
_certain_ to corrupt the databases. You might forget to disable MySQL 4.1
as a starts-during-boot service, and then next time you reboot, both
instances will start up, and they'll be writing to the same data dir.

Also be sure to get the latest production release of MySQL 5.0, which is
currently 5.0.16. 5.0.1 is 18 months old, and it is pre-beta software.

Regards,
Bill K.
Dec 15 '05 #2
"Shiraz" <sh*****@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
my question is can i just install the new version of mysql, stop the
old, point the data directory for the new one to the data directory and
just start up mysql 5? or do i need to take some extra steps int eh
process. also is there any data corruption possible in the process i
described


There is always data corruption possible! A system admin friend of mine
said, "always assume the computer is out to get you... not users in general,
but YOU. It's personal."

First, read the following pages, and perform the recommended steps.
Consider if your databases or applications use any of the features for which
there are incompatible changes between 4.1 and 5.0.
http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

Back up your databases under MySQL 4.1, then then restore the databases
using MySQL 5.0. That is the safer procedure. Plus you have a backup
(which should be your daily habit already).

I recommend against configuring two instances of MySQL to use the same data
directory, because if both of them are running simultaneously, they are
_certain_ to corrupt the databases. You might forget to disable MySQL 4.1
as a starts-during-boot service, and then next time you reboot, both
instances will start up, and they'll be writing to the same data dir.

Also be sure to get the latest production release of MySQL 5.0, which is
currently 5.0.16. 5.0.1 is 18 months old, and it is pre-beta software.

Regards,
Bill K.

Dec 15 '05 #3
thanks for the advice. actually i am about to install 5.0.15, missed
that on my post. i am a newbie and any and all advice is appreciated.

i am planning to back up the database anyways, but due to limited
resources, i am not able to backup the database in one go using
mysqldump. for starters, the size of the DB is more than 250 GBs. but i
will do a data dump.

anyways when you say restore the DB, what do you mean by that? get the
mysqldump output and restore that?

anyways will come up with a plan by tomorrow and post it. hopefuly all
will go well.

Dec 15 '05 #4
"Shiraz" <sh*****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
i am planning to back up the database anyways, but due to limited
resources, i am not able to backup the database in one go using
mysqldump. for starters, the size of the DB is more than 250 GBs. but i
will do a data dump.
Mysqldump has many options for backing up individual tables. You can even
back up subsets of a specified table using the --where option. See
documentation.

Mysqldump output usually compresses very well, with tools such as Zip or
gzip.
anyways when you say restore the DB, what do you mean by that? get the
mysqldump output and restore that?


Yes, that is what I meant.

Regards,
Bill K.
Dec 15 '05 #5
I recently experimented with installing multiple MySQL instances on one
machine - here's what my experiences were:

In Windows, it was very easy, you would only have to make a 2nd
installation, using a different location and a different port. Then you'd
have to install a second service (I suppose, you'd like to run it as
service/deamon) and redirect the second installation to the different
service (MySQL Administrator is a great tool for this). That's all you
should have to do (except setting the MySQL privileges of course).

With Linux, there's a little more to do - again you would have to install
the second server on a different location. You need to run the
mysql_install_db script (if you install it using the tar.gz file) and
install the mysql.server in the /etc/init.d directory (of course, use
another name as the existing start up file for the other server). You will
probably have to make some changes in it - to set the data directory, the
base directory, the different port and maybe other things. You should also
make the same settings in the my.cnf file, which should be located in the
data directory of each MySQL installation.

You also shouldn't forget to set the permissions right and it's good
practice to start the server with a separate user (mostly mysql) that only
has the required Linux privileges to do what's really necessary.

As Bill already said, you should be careful that both servers don't share
any resources - the minimum is to set different data locations and different
ports, but you should keep everything separated: the configuration files,
the InnoDB tablespaces, the log file locations a.s.o.

The best practice to transfer the data will be mysqldump - I don't think,
there is a more efficient (and secure) way to backup and restore your data.

However, you should also read this:
http://dev.mysql.com/doc/refman/5.0/...e-servers.html

Wish you good luck ;-)!

Markus
Dec 15 '05 #6

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...
1
by: bartolomesintes | last post by:
Hi, I have installed PHPHome 2.3.4 in Windows XP. This WAMP package installs Apache 2.0.50 , PHP 5.0.0 and it works fine. The SQLite installed version is 2.8.14 and I would like to upgrade to a...
6
by: Michael Foord | last post by:
http://www.voidspace.org.uk/python/articles/upgrading_python.html I've been looking at whether to upgrade immediately from Python 2.3 to Python 2.4 or postpone it. This is my first `major version...
0
by: Jonathan Hilgeman | last post by:
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if MySQL 4.0 is fully backwards-compatible with 3.23.x...
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...
13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
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: 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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.