LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 10-22-2003, 05:59 AM   #1
cli_man
Member
 
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 mysql.com 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.

Code:
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, 07:04 AM   #2
skate
Member
 
Registered: Aug 2003
Location: Bulgaria
Distribution: OpenSuse 10.3, Debian 4.0r3 "Etch", FreeBSD 7.1, Ubuntu
Posts: 210

Rep: Reputation: 30
Go to ..
http://www.mysql.com/
http://www.mysql.com/downloads/index.html
Download the latest and stable MySQL version and install it on your machine...and then you must do not have any problems~~~ with it~
 
  


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


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

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