[NTLUG:Discuss] Still NO Mysql - Is there at least a MySQL Mailing list?

[Robert Pearson]

On Thu, Feb 26, 2009 at 6:13 AM, Stephen Davidson
<gorky at freenet.carleton.ca> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Terry.
>
> Thanks.  Unfortunately, SuSE uses Yast instead of Apt-get, and SuSE 10.3
> is preconfigured for MySQL 5.0.  Hence the manual install -- "I was
> outside of the box".  I did eventually get that part worked out.  There
> were some leftover 5.0 files causing an issue (these files did NOT
> include my.cnf, btw -- I had to create my own as one was notinstalled
> with 5.1!).
>

You can add "apt" to openSUSE. See here:
<http://en.opensuse.org/APT>

[Note: YaST will do everything and more that "apt" (for openSUSE) will
do. It just takes more digging]
[The last time I used openSUSE, YaST was being phased out for zypper
and its CLI                            ]

Be advised that the "sources.list" file show on this page is very
simple and will not do everything you need.
You will have to add repositories. Which is another skill you'll have
to add unless you can Google "MySQL sources.list openSUSE" (or
similar) and get something useful.

I suspect you need to add one or more repositories for YaST to find
the "right" MySQL packages.
One of the reasons I quit using openSUSE is the repositories system
was in a state of flux. I had to figure out what I needed and manually
add them to get the "right" stuff. When I test installed openSUSE 11.0
I found it still in a state of flux.

When I last used openSUSE the RPM database was used for packages.
Have you run "rpm -qa | grep -i mysql" to see what packages and
version are installed?
Somewhere there is a list MySQl packages and versions for openSUSE 11.?

There probably is an upgrade path for MySQL as well. Hopefully the
MySQL upgrade would look at the openSUSE version and get the "right"
packages.
There is always the complete removal and re-installation but I guess
you have valuable data you want to ret

Most of the solution is an orderly process. If you get steps out of
order you will have major work to fix it.


> Now, my current issue is that Stored Procedures in the mysql 5.0 dump
> file will not be imported into mysql 5.1.  :(
>
> Regards,
> Steve
>
> terry wrote:
>> This might give you a clue,  (notes from a debian user's mysql install):
>>
>> =======================================================
>>
>> In order to install MySQL, we run
>>
>> apt-get install mysql-server mysql-client libmysqlclient15-dev
>>
>> You will be asked to provide a password for the MySQL root user - this
>> password is valid for the user root at localhost as well as
>> root at server1.example.com, so we don't have to specify a MySQL root password
>> manually later on:
>>
>> New password for the MySQL "root" user: <-- yourrootsqlpassword
>> Repeat password for the MySQL "root" user: <-- yourrootsqlpassword
>>
>> We want MySQL to listen on all interfaces, not just localhost, therefore we
>> edit /etc/mysql/my.cnf and comment out the line bind-address = 127.0.0.1:
>>
>> vi /etc/mysql/my.cnf
>>
>> [...]
>> # Instead of skip-networking the default is now to listen only on
>> # localhost which is more compatible and is not less secure.
>> #bind-address           = 127.0.0.1
>> [...]
>>
>>   Then we restart MySQL:
>>
>> /etc/init.d/mysql restart
>>
>> Now check that networking is enabled. Run
>>
>> netstat -tap | grep mysql
>>
>> The output should look like this:
>>
>> server1:~# netstat -tap | grep mysql
>> tcp        0      0 *:mysql                 *:*
>> LISTEN      6612/mysqld
>> server1:~#
>> _______________________________________________
>> http://www.ntlug.org/mailman/listinfo/discuss
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.4-svn0 (GNU/Linux)
> Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
>
> iD8DBQFJpodRSphIUSiVzgYRAqJNAJ9rUPn7db/dmgbgpMMSpwFpqPNeVgCeNDcx
> 75ipwOjsbI5W1YfvloM2jPo=
> =ePdK
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
>