I tried to upgrade my mysql server from the instructions on ART, but unfortunately it didn't complete successfully and now the site is down.
[root@u15166285 cleanserver]# rpm -e MySQL-Max MySQL-server MySQL-client MySQL-shared-compat --nodeps
error: package MySQL-Max is not installed
error: package MySQL-server is not installed
error: package MySQL-client is not installed
error: package MySQL-shared-compat is not installed
[root@u15166285 cleanserver]# yum install mysql-server mysql mysql-compat
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 9 - Atomic PSA-Compatible RPMS
Server: Atomic Rocket Turtle - 9 - Base OS RPMS mirror
Server: Atomic Rocket Turtle - 9 - SW-Soft PSA 7.5 RPMS
Server: Atomic Rocket Turtle - 9 - OS Update RPMS mirror
Finding updated packages
Downloading needed headers
Resolving dependencies
Dependencies resolved
I will do the following:
[install: mysql-compat 4.0.23a-1.rh90.art.i386]
[update: mysql-server 4.0.23a-1.rh90.art.i386]
[update: mysql 4.0.23a-1.rh90.art.i386]
Is this ok [y/N]: y
Downloading Packages
Getting mysql-server-4.0.23a-1.rh90.art.i386.rpm
mysql-server-4.0.23a-1.rh 100% |=========================| 1.4 MB 00:16
Getting mysql-4.0.23a-1.rh90.art.i386.rpm
mysql-4.0.23a-1.rh90.art. 100% |=========================| 7.4 MB 01:34
Getting mysql-compat-4.0.23a-1.rh90.art.i386.rpm
mysql-compat-4.0.23a-1.rh 100% |=========================| 243 kB 00:02
Running test transaction:
Test transaction complete, Success!
mysql 100 % done 1/5
mysql-compat 100 % done 2/5
mysql-server 100 % done 3/5
Completing update for mysql-server - 4/5
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
packagemng: Unable to connect to the mysql database
System error 2: No such file or directory
packagemng: Unable to connect to the mysql database
System error 2: No such file or directory
error: %trigger(psa-7.5.2-rh9.build75050128.10) scriptlet failed, exit status 1
Installed: mysql-compat 4.0.23a-1.rh90.art.i386
Updated: mysql-server 4.0.23a-1.rh90.art.i386 mysql 4.0.23a-1.rh90.art.i386
Error from /var/log/mysqld.log
050221 20:04:02 mysqld started
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 640 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 6400 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
050221 20:04:02 Can't init databases
050221 20:04:02 Aborting
050221 20:04:02 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
050221 20:04:02 /usr/libexec/mysqld: Shutdown Complete