MySQL upgrade

Hi,

I have a pending task: upgrade the tables of some mysql databases I have.

I look at “/var/log/mysql/mysqld-upgrade.log” and it says:

Code:

Will update MySQL now, if you encounter any problems, please read
following file:
/usr/share/doc/packages/mysql/README.SuSE

Biblioteca.Colecciones
error : Table upgrade required. Please do "REPAIR TABLE Colecciones"
or dump/reload to fix it!

However, the “README.SuSE” file says nothing about “repair” or “dump/reload”.

Could someone point me to some doc I can read, for dummies if possible?

I have tried:

mysql> REPAIR TABLE Colecciones
->

which I do not know if is the expected result or is waiting for something
else. I can see that the timestamp of the database is not changed.


Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

you forgot the semicolon:

REPAIR TABLE `Colecciones`;

On 2010-11-23 06:06, brian j wrote:
>
> robin_listas;2256486 Wrote:
>>
>>
>> mysql> REPAIR TABLE Colecciones
>> →
>>
>
> you forgot the semicolon:
>
>
> Code:
> --------------------
> REPAIR TABLE Colecciones;
> --------------------

Rather, “they” forgot to tell me so. But something else is needed:

Code:

mysql> REPAIR TABLE Colecciones;
ERROR 1046 (3D000): No database selected

I know the name of the database, but I don’t know how to “select” it. The
“select” help indicates it selects things, but not entire databases. I
tried, anyway.

mysql> select Biblioteca;
ERROR 1054 (42S22): Unknown column ‘Biblioteca’ in ‘field list’

It is clear that I never use the command line client, I know very little
about it, just follow blind instructions. I tried a go with
“mysql-workbench”, but I don’t know how to open a database with it. When I
try to connect, it hangs and has to be killed.

I found a way with mysql-administrator.

…]

There is a check function… and it says the tables are Ok :-?

AH!

The log “mysqld-upgrade.log” that said a repair was needed, actually did
the repair itlself later on:

Repairing tables
Biblioteca.Colecciones OK
Biblioteca.Generos OK
mysql.help_category OK

So I didn’t need to do anything, really. Fantastic!


Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

mysql> REPAIR TABLE `Colecciones`;
ERROR 1046 (3D000): No database selected

I know the name of the database, but I don’t know how to “select” it. The
“select” help indicates it selects things, but not entire databases. I
tried, anyway.

Good to see that your problem is solved, but anyway: That would have been:

mysql> USE name-of-your-db;
mysql> REPAIR TABLE Colecciones;

Remark: You can omit the backticks around the table name as long as it does not contain any special characters, but it does no harm to use them.

On Tue, 23 Nov 2010 21:16:08 +0530, Carlos E. R.
<robin_listas@no-mx.forums.opensuse.org> wrote:

> On 2010-11-23 06:06, brian j wrote:
>>
>> robin_listas;2256486 Wrote:
>>>
>>>
>>> mysql> REPAIR TABLE Colecciones
>>> →
>>>
>>
>> you forgot the semicolon:
>>
>>
>> Code:
>> --------------------
>> REPAIR TABLE Colecciones;
>> --------------------
>
> Rather, “they” forgot to tell me so. But something else is needed:
>
>
> Code:
> ---------------------
> mysql> REPAIR TABLE Colecciones;
> ERROR 1046 (3D000): No database selected
> ---------------------
>
> I know the name of the database, but I don’t know how to “select” it. The
> “select” help indicates it selects things, but not entire databases. I
> tried, anyway.
>
>
> mysql> select Biblioteca;
> ERROR 1054 (42S22): Unknown column ‘Biblioteca’ in ‘field list’

you select a database with the command ‘use’:

“use <database name>;”

(and here, for some reason i don’t understand, the closing semicolon is
not needed; doesn’t do any harm, though.)

>
>
> It is clear that I never use the command line client, I know very little
> about it, just follow blind instructions. I tried a go with
> “mysql-workbench”, but I don’t know how to open a database with it. When
> I
> try to connect, it hangs and has to be killed.
>
> I found a way with mysql-administrator.
>
> …]
>
> There is a check function… and it says the tables are Ok :-?
>
> AH!
>
> The log “mysqld-upgrade.log” that said a repair was needed, actually did
> the repair itlself later on:
>
> Repairing tables
> Biblioteca.Colecciones OK
> Biblioteca.Generos OK
> mysql.help_category OK
> …
>
> So I didn’t need to do anything, really. Fantastic!
>

good for you, in this case. if you have to deal with MySQL databases more
often, i’d recommend learning some basic syntax (documentation on their
website, other sources). to make life easier you can install phpMyAdmin,
but you’ll need to set up some valid authentication for the web interface.
isn’t difficult, but i don’t find it particularly intuitive.


phani.

On 2010-11-23 17:19, phanisvara wrote:
> On Tue, 23 Nov 2010 21:16:08 +0530, Carlos E. R. <> wrote:

Thank you both, vodoo and phani :slight_smile:

>
> you select a database with the command ‘use’:
>
> “use <database name>;”

ah!

> (and here, for some reason i don’t understand, the closing semicolon is
> not needed; doesn’t do any harm, though.)

Curious.

> good for you, in this case. if you have to deal with MySQL databases
> more often, i’d recommend learning some basic syntax (documentation on
> their website, other sources).

I use a database now and then, but I don’t administer it except very
rarely, like this time. I’m comfortable with the CLI, but not with
databases: for this I prefer graphical tools, as much MS-Access style as
possible. Which is a problem, because the only one I can use is rekall and

> to make life easier you can install
> phpMyAdmin, but you’ll need to set up some valid authentication for the
> web interface. isn’t difficult, but i don’t find it particularly intuitive.

I did install it years ago, but I haven’t used it again since then. I think
that “mysql-administrator” might be enough. Dunno. Perhaps I should see if
it still runs, this is an upgraded system with a decade long inheritance :wink:


Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

On 2010-11-24 01:22, Carlos E. R. wrote:
> On 2010-11-23 17:19, phanisvara wrote:

> to make life easier you can install
>> phpMyAdmin, but you’ll need to set up some valid authentication for the
>> web interface. isn’t difficult, but i don’t find it particularly intuitive.
>
> I did install it years ago, but I haven’t used it again since then. I think
> that “mysql-administrator” might be enough. Dunno. Perhaps I should see if
> it still runs, this is an upgraded system with a decade long inheritance :wink:

I tried. Interestingly, phpMyAdmin is no longer part of the distro, but of
the “server:/php:/applications” repo. It has been removed of the mainline
distro - why, I wonder?


Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

I guess you would call it outsourcing, hahaha. No, I don’t know why either, but it seems to be one of the apps deemed non-core.

On 11/23/2010 06:06 PM, ken yap wrote:
>
> robin_listas;2257044 Wrote:
>> Interestingly, phpMyAdmin is no longer part of the distro, but of
>> the “server:/php:/applications” repo. It has been removed of the
>> mainline
>> distro - why, I wonder?
>
> I guess you would call it outsourcing, hahaha. No, I don’t know why
> either, but it seems to be one of the apps deemed non-core.

Debian has their “popularity contest” feature that tracks what you
install (strictly opt-in of course) so they can see what packages are
marginal and what folks can’t seem to live w/o. All w/out user
intervention. Does openSUSE have anything like that? If not, perhaps
we should.

…Kevin

Kevin Miller - http://www.alaska.net/~atftb
Juneau, Alaska
In a recent survey, 7 out of 10 hard drives preferred Linux
Registered Linux User No: 307357, http://counter.li.org

On 2010-11-24 06:33, Kevin Miller wrote:

> Debian has their “popularity contest” feature that tracks what you
> install (strictly opt-in of course) so they can see what packages are
> marginal and what folks can’t seem to live w/o. All w/out user
> intervention. Does openSUSE have anything like that? If not, perhaps
> we should.

No, we don’t have it.

It is not possible to track mirrors, it would have to be some program
running on each computer that feeds that info.


Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)

FYI - As a substitute for PHPMySQLadmin, I’m just starting to take a look at mergeant which is highly recommended, supports multiple database engines (cool for Admins). And, is in the SuSE repos.

Tony