LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 09-05-2004, 07:14 AM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Rep: Reputation: 32
Upgrading MySQL version 3 to 4 RedHat / Fedora


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
 
Old 09-05-2004, 08:17 AM   #2
hw-tph
Senior Member
 
Registered: Sep 2003
Location: Sweden
Distribution: Debian
Posts: 3,032

Rep: Reputation: 58
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
 
Old 09-05-2004, 08:20 AM   #3
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
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
 
Old 09-05-2004, 09:39 PM   #4
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
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
 
Old 09-06-2004, 05:56 AM   #5
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
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
 
Old 09-06-2004, 06:09 AM   #6
hw-tph
Senior Member
 
Registered: Sep 2003
Location: Sweden
Distribution: Debian
Posts: 3,032

Rep: Reputation: 58
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
 
Old 09-06-2004, 06:20 AM   #7
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
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
 
Old 09-06-2004, 06:37 AM   #8
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
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

Last edited by tommytomato; 09-06-2004 at 06:39 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Probelm after upgrading MySQL on Fedora sdsouza Fedora 5 02-09-2005 01:12 PM
Upgrading to mysql 4.0.20 on Fedora Core 2 tomdkat Fedora 18 09-09-2004 06:25 PM
Upgrading MySQL 3 to 4 on Fedora Core 2 tarnishedXhalo Fedora 1 05-31-2004 08:15 PM
redhat fedora gcc version (compiled for 2.4.20) doesn't match kernel version 2.4.22 start1000 Linux - Software 0 03-16-2004 08:17 PM
Upgrading to newer version (Fedora) ntloser Linux - Software 9 01-25-2004 06:27 PM


All times are GMT -5. The time now is 09:06 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration