Re: MySQL 4.0 (sarge) --> MySQL 5.0 (etch) -- Please do "REPAIR TABLE"
Jarek Buczyński escribió:
Hi
I've upgrades sarge to etch. I've got problem with MySQL 5 (previously I had
MySQL 4). MySQL server tells me:
------------------------------------------------------------------
Table upgrade required. Please do "REPAIR TABLE `adresy`"
to fix it!
...
Version: '5.0.32-Debian_7etch1-log'
socket: '/var/run/mysqld/mysqld.sock'
port: 3306 Debian etch distribution
/etc/mysql/debian-start[8752]: Upgrading MySQL tables if necessary.
/etc/mysql/debian-start[8760]: Checking for crashed MySQL tables.
....
Checking for corrupt, not cleanly closed and upgrade needing tables..
...
------------------------------------------------------------------
How I can repair all tables at some databases (not all), I don't want do
this manually
--
Regards
I suposse you will need to do inside the mysql client console:
mysql> USE <database>;
mysql> REPAIR TABLE <table>;
... and so on...
--
.---------------------------------------------------------------------.
| Miguel J. Jiménez |
| Programador Senior |
| Área de Internet/XSL/PHP |
| migueljose.jimenez@isotrol.com |
:---------------------------------------------------------------------:
| ISOTROL, S.A. |
| Edificio BLUENET, Avda. Isaac Newton nº3, 4ª planta. |
| Parque Tecnológico Cartuja '93, 41092 Sevilla (ESP). |
| Teléfono: +34 955 036 800 - Fax: +34 955 036 849 |
| http://www.isotrol.com |
:---------------------------------------------------------------------:
| "Aquellos que mueran mañana serán los que hayan sobrevivido hoy." |
| Dusty Attenborough, La Leyenda de los Heroes de la Galaxia |
'---------------------------------------------------------------------'
begin:vcard
fn;quoted-printable:Miguel J. Jim=C3=A9nez Jim=C3=A9nez
n;quoted-printable:Jim=C3=A9nez Jim=C3=A9nez;Miguel J.
org:ISOTROL, S.A.;XSL / PHP
adr;quoted-printable;quoted-printable;quoted-printable:Parque Tecnol=C3=B3gico Cartuja 93;;C/ Isaac Newton 3, 4=C2=AA;Sevilla;Sevilla;41092;Espa=C3=B1a
email;internet:mjjimenez@isotrol.com
title:Programador Senior
tel;work:+34 955 036 800 (ext. 1805)
tel;fax:+34 955 036 849
tel;cell:+34 607 44 87 64
x-mozilla-html:TRUE
url:http://www.isotrol.com
version:2.1
end:vcard
Reply to: