Upgrading MySQL version 3 to 4 RedHat / Fedora

tommytomato · 09-05-2004, 07:14 AM

Hi all

Any one had problems upgrading MySQL from 3 to 4

I came across this page

http://fedoranews.org/contributors/tony_smith/mysql/

Is the old version of MySQL have to be removed before installing newer version

TT

hw-tph · 09-05-2004, 08:17 AM

No, you can upgrade from 3.x to 4.x without having to remove the 3.x rpms but I suggest you back up your databases (if you have any) before doing the actual upgrade.

Håkan

tommytomato · 09-05-2004, 08:20 AM

Thank you

So its the rpm i need and not the source one
as in MySQL-4.0.20-0.src

I'm on a roll today, linux seems to be playing nice

TT

tommytomato · 09-05-2004, 09:39 PM

Can any one tell me what package to get please as in MySQL from 3 to 4

Their are so many to chose from

TT

tommytomato · 09-06-2004, 05:56 AM

Hi all

MySQL seem to install ok

but i have a question

what is the GRANT command i have been looking every where and i cant seem to find it

Code:

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

TT

hw-tph · 09-06-2004, 06:09 AM

The GRANT command is used in MySQL to set users' privileges. Just make sure you run that mysql_fix_privilege_tables script and you should be OK.

Håkan

tommytomato · 09-06-2004, 06:20 AM

I did run what i think i had to run and got an error

Code:

[root@rockinghamgateway downloads]# /usr/bin/mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
/usr/bin/mysql_fix_privilege_tables: line 100: /usr/bin/mysql: No such file or d
irectory

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
/usr/bin/mysql_fix_privilege_tables: line 115: /usr/bin/mysql: No such file or d
irectory

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
/usr/bin/mysql_fix_privilege_tables: line 132: /usr/bin/mysql: No such file or d
irectory

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
/usr/bin/mysql_fix_privilege_tables: line 159: /usr/bin/mysql: No such file or d
irectory

Creating the new table and column privilege tables
/usr/bin/mysql_fix_privilege_tables: line 175: /usr/bin/mysql: No such file or d
irectory
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
/usr/bin/mysql_fix_privilege_tables: line 206: /usr/bin/mysql: No such file or d
irectory

Fixing the func table
You can ignore any Duplicate column errors
/usr/bin/mysql_fix_privilege_tables: line 218: /usr/bin/mysql: No such file or d
irectory

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
/usr/bin/mysql_fix_privilege_tables: line 230: /usr/bin/mysql: No such file or d
irectory
/usr/bin/mysql_fix_privilege_tables: line 255: /usr/bin/mysql: No such file or d
irectory
/usr/bin/mysql_fix_privilege_tables: line 266: /usr/bin/mysql: No such file or d
irectory
/usr/bin/mysql_fix_privilege_tables: line 278: /usr/bin/mysql: No such file or d
irectory
[root@rockinghamgateway downloads]#

does that look right i dont mine learning how to do it.

do i need to run database install command then add in root user pass etc

I hope you get my dift, i keep my own little forum full of notes but its down right now due to me upgrading from 3 to 4, so i cant remember the command off the top of my head.

TT

tommytomato · 09-06-2004, 06:37 AM

This is what i meant i findly remember it

/usr/bin/mysql_install_db

but this gave me an error and its asking me to copy files to another dir

Code:

Installing all prepared tables
040906 19:31:26  Warning: Asked for 196608 thread stack, but got 126976
040906 19:31:26  /usr/sbin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h rockinghamgateway.com password 'new-password'
See the manual for more instructions.

and so on

I found where the files may be

[root@localhost bin]# whereis support-files/mysql.server
mysql: /usr/lib/mysql /usr/share/mysql

where do i copy them too ?

TT