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