downgrade Mysql

[Henrich Balaz]

> Dobry den,
>
> Podarila sa mi velmi mudra vec, naistaloval som MySQL-server-4.1.9-0.
> Samozrejme som ohladom zavislosti musel balicek odinstalovat a chcel som
> vratis balicek z instalaciek Mandrake 10.1.
> Toto sice prebehlo OK. ale Mysql mi nefunguje.
> aplikaciemi vracaju:
>  Warning: mysql_pconnect(): Can't connect to local MySQL server through
> socket '/var/lib/mysql/mysql.sock' (2)
>
> V logu var/lib/mysql/***.err:    sa sa nachadzaju tieto hlasky:
> Fatal error: Can't open privilege tables: File
> '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
>
>
> Po downgrade sa obajavilo toto:
>
> InnoDB: You are downgrading from the multiple tablespace format of
> InnoDB: >= MySQL-4.1.1 back to the old format of MySQL-4.0.
> InnoDB:
> InnoDB: MAKE SURE that the mysqld server is idle, and purge and the insert
> InnoDB: buffer merge have run to completion under >= 4.1.1 before trying to
> InnoDB: downgrade! You can determine this by looking at SHOW INNODB STATUS:
> InnoDB: if the Main thread is 'waiting for server activity' and SHOW
> InnoDB: PROCESSLIST shows that you have ended all other connections
> InnoDB: to mysqld, then purge and the insert buffer merge have been
> InnoDB: completed.
> InnoDB: If you have already created tables in >= 4.1.1, then those
> InnoDB: tables cannot be used under 4.0.
> InnoDB: NOTE THAT this downgrade procedure has not been properly tested!
> InnoDB: The safe way to downgrade is to dump all InnoDB tables and recreate
> InnoDB: the whole tablespace.
> InnoDB: You are downgrading from an InnoDB version which allows multiple
> InnoDB: tablespaces. Wait that purge and insert buffer merge run to
> InnoDB: completion...
> InnoDB: Full purge and insert buffer merge completed.
> InnoDB: Downgraded from >= 4.1.1 to 4.0
> 050201 13:12:51  InnoDB: Started
> /usr/sbin/mysqld: ready for connections.
> Version: '4.0.20'  socket: '/var/lib/mysql/mysql.sock'  port: 0
> 050201 13:13:01  mysqld started
> 050201 13:13:02  InnoDB: Database was not shut down normally.
> InnoDB: Starting recovery from log files...
> InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 43644
> InnoDB: Doing recovery: scanned up to log sequence number 0 43644
> 050201 13:13:03  InnoDB: Flushing modified pages from the buffer pool...
> 050201 13:13:03  InnoDB: Started
> 050201 13:13:03  Fatal error: Can't open privilege tables: File
> '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
> 050201 13:13:03  Aborting
>
> je to moja prva instalacua Apache, php, a mysql. co je myslim zrejme z
> predchadzajuceho.
>
> Prosim o radu ako toto vyriesit.
>
> Dakujem

Baláž