Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 01-01-2003, 04:39 PM   #1
Registered: Jun 2002
Location: London
Distribution: Slackware
Posts: 201

Rep: Reputation: 30
upgrading to mysql 4

I have been running mysql 3.23.xx on a few boxes - built from source each time. I now want to upgrade to the new mysql 4 ( )

Firstly I don't see any source files anywhere, so I'm attempting to install the binary version - thinking that it should be much simpler anyway.

So my first step is to move the old mysql tree out of the way

# cd /usr/local/
# mv mysql mysqlold

I then unpack the binary tarball like so:

# tar -zxvf mysql-max-4.0.7-gamma-pc-linux-i686.tar.gz

and I symlink the new mysql tree in place by:

# ln -s mysql-max-4.0.7-gamma-pc-linux-i686 mysql

with all mysql processes killed off, I'm ready to restart the daemon. the result is as follows:

bash-2.05a# ./bin/safe_mysqld &
[1] 8284
bash-2.05a# Starting mysqld daemon with databases from /usr/local/mysql/data
030101 21:15:33 mysqld ended

I have tried to reinstall the default databases with the mysq_install_db script, but that dies too. Has anyone ever upgraded in this way, or have you got any ideas?

thanks guys,

(happy new year by the way !)
Old 01-02-2003, 12:20 AM   #2
Registered: Sep 2002
Distribution: Red Hat
Posts: 68

Rep: Reputation: 15
what u hv done is only moving the mysql binaries to another location.

there is still the actual database in the /var directory. Try moving
the db to another location as well
Old 03-19-2003, 07:45 AM   #3
LQ Newbie
Registered: Feb 2003
Location: Somehere in the corner
Distribution: Slackware 8.1
Posts: 8

Rep: Reputation: 0

yeah me too. i need help on upgrading my mysql 3.23.xx version to version 4.0. please somebody shade some lights ... any good links and how to's is really apreciated ...

my system is running on slackware 8.1


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
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 05:28 PM
Upgrading mySql from 3.23 to 4.1.10 atomicx Linux - Software 2 02-22-2005 11:54 AM
upgrading mysql mabus92920 Linux - Newbie 2 01-16-2005 10:35 AM
Upgrading to Mysql 4.0 ombill Fedora 2 08-19-2004 01:30 PM
Upgrading to Mysql 4.0 ombill Fedora 1 08-19-2004 12:29 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:08 PM.

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