Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: MySQL upgrade

  1. #1
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default 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)

  2. #2

    Default Re: MySQL upgrade

    Quote Originally Posted by robin_listas View Post

    mysql> REPAIR TABLE `Colecciones`
    ->
    you forgot the semicolon:

    Code:
    REPAIR TABLE `Colecciones`;

  3. #3
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: MySQL upgrade

    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)

  4. #4
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: MySQL upgrade

    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.
    Good to see that your problem is solved, but anyway: That would have been:

    Code:
    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.
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

  5. #5
    Join Date
    Mar 2009
    Location
    sri mayapur, west bengal, india
    Posts
    958

    Default Re: MySQL upgrade

    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.

  6. #6
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: MySQL upgrade

    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 :-)

    >
    > 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 ;-)

    --
    Cheers / Saludos,

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

  7. #7
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: MySQL upgrade

    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 ;-)


    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)

  8. #8
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: MySQL upgrade

    Quote Originally Posted by robin_listas View Post
    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.

  9. #9

    Default Re: MySQL upgrade

    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

  10. #10
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: MySQL upgrade

    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)

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •