Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
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 10-22-2003, 04:59 AM   #1
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
How to Upgrade MySQL

First off this is unrelated to my other post I just made a couple of minutes ago, I am just full of questions today.

I have a Redhat 7.2 Server with the default redhat install of mysql, 3.23.52 I would like to upgrade the mysql to 4.0.15 but not with an rpm, I don't like the mysql rpm's, I downloaded the binary from untarred it to /usr/local/mysql I have set this up on quite a few servers with no problem but how do I now import in the databases from the old install, (in /var/lib/mysql)

I tried shutting down the database and just copying the files over to the /usr/local/mysql/data/ directory but that failed pretty bad,

Here is the logfile from when I tried to start the mysql the first time with the copied over databases.

031021 14:25:15  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
031021 14:25:15  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
031021 14:25:15  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
031021 14:25:16  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
031021 14:25:17  InnoDB: Started
031021 14:25:17  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
031021 14:25:17  Aborting

031021 14:25:17  InnoDB: Starting shutdown...
031021 14:25:19  InnoDB: Shutdown completed
031021 14:25:19  /usr/local/mysql/bin/mysqld: Shutdown Complete
What is the correct way to import in the data with minimal downtime? Thanks
Old 10-23-2003, 06:04 AM   #2
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Rep: Reputation: 30
Go to ..
Download the latest and stable MySQL version and install it on your machine...and then you must do not have any problems~~~ with it~


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
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 06:43 PM
mysql upgrade no_names_left Linux - Software 1 03-04-2005 09:30 AM
Upgrade to MySQL 4? VxJasonxV Red Hat 1 02-06-2004 03:15 PM
mySQL Upgrade from 3.23 to 4.0 SForsgren Linux - Software 6 12-29-2003 04:11 AM
How do I upgrade MySQL... correro Linux - General 1 04-16-2003 11:43 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:14 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