On the cobalt site they have the 3.23.36 version of MySQL as a package file:

http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-3.23.36-1.pkg

Has anyone successfully installed this package over the old 3.22.32, on a RAQ4i? What are the pros of installing the newer package?

Thanks

I installed it but have not used it yet ...

you have to uninstall the old one first though I remember reading somewhere on that page.

If you remove the old pkg, will the databases gone as well ?

This package will upgrade over the older 3.22.32 pkg listed above. Uninstall the older version first - See the UnInstall-HOW-TO ( run the uninstaller script at /var/lib/cobalt/uninstallers/MySQL-3.22.32-1.uninst )
Next, install the newer version as it will retain your data that is located in /home/mysql

had a problem
after installign couldnt change th pass
i used
mysqladmin -uroot -pcobalt-mysql password newpass
it said access denied for user root@localhost
;-(
nyone know a fix
thanx
l8r
®acker
P.S:i started a new site nop-web.com it has nothin to do with hostin
check it out

I'm not sure about this cobolt package, but the password may have been reset to nothing. When you install mysql from scratch, it doesn't set any passwords. Try logging in without specifying a password. See if that works.

Can anyone please answer my question ?

Will the exist databases being delete if you remove the MySQL before installing the new one ?

databases are still there after upgrade ...
see chicken's earlier post
"Next, install the newer version as it will retain your data that is located in /home/mysql"
i did it the way he mentioned ... first running the uninstall script and then install the .pkg file ...

Any error, bug found so far ?

Originally posted by Donovan
Can anyone please answer my question ?

Will the exist databases being delete if you remove the MySQL before installing the new one ?

Backup your database just in case. Just do a dump. Do this:

mysqldump [db_name] > dump.file

still no work:(
access denied for suer root@localhost
i tried without a pass same error
fook this is gettin buggin
l8r
®acker

Just wondering if you tried your old root pass?

Originally posted by vizi


Backup your database just in case. Just do a dump. Do this:

mysqldump [db_name] > dump.file

dump.file ?? That's the backup file for MySQL Databases?

Hmm, i just upgraded and everything works except chilisoft ASP can't connect anymore so i guess the ASP MySQL driver hasn't been upgraded :-(

The old TESTDNS looks to /home/casp/odbc/opensource/lib/libmyodbc.so but there is a zerobyte file :-(
HTTP Error 507
507 Unexpected
The Web server encountered an unexpected error while communicating with the ASP service.
Please contact the server's administrator if this problem persists.

Anyone know where i can get the correct driver?

Thanks,
Domenico

I put the one in the package at: http://www.gilby.com/cobalt/libmyodbc-2.50.36.so

Looking at the installation script, there looks to be a bug that makes the link to the file point to the wrong place. I also noticed that in your error message, the directory was casp instead of chiliasp. I don't have access to a raq4 now, so I can't check the directory name, so change the directory name below from chiliasp to casp if that's how it is on your server.

Anyways, here are the commands you need to do as root (if libmyodbc-2.50.36.so is already inthe directory below, then just do the last 3 commands):
wget http://www.gilby.com/cobalt/libmyodbc-2.50.36.so
cp -p libmyodbc-2.50.36.so /home/chiliasp/odbc/opensource/lib
chown chiliasp.chiliasp /home/chiliasp/odbc/opensource/lib/libmyodbc-2.50.36.so
rm /home/chiliasp/odbc/opensource/lib/libmyodbc.so
ln -s /home/chiliasp/odbc/opensource/lib/libmyodbc-2.50.36.so /home/chiliasp/odbc/opensource/lib/libmyodbc.so
/etc/rc.d/init.d/asp-apache-3000 restart
/etc/rc.d/init.d/asp-admin-5100 restart

Hi Gilby!

my dir is called casp so i changed that but I made the odbc symlink and i restarted everything.

Then i go to admin console, properties, databases and click on add new dns. After that you see the driver but only the old MySQL 3.22.32-1 is there not the new 3.23.36 :-(
It still says MySQL 3.22.32-1 /opt/casp/odbc/opensource/lib/libmyodbc.so 3.22.32

What now?

The rest does work...

i just made a test DNS and it works.
Why doesn't it give back the correct driver version number? It says it is the former driver but it works so who cares i gues ;-)

Thanks gilby!

Originally posted by Donovan


dump.file ?? That's the backup file for MySQL Databases?

Yes; however, you can call it anything you want. The database structure and data will be placed in that file. You can call it anything you want.