Upgrade from 4.0.26 to 5.0.67

Hi! I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67. Is there any possibility to upgrade directly from MySQL 4.0.26 to 5.0.67, without upgrading first to the intermediate versions? TIA Nanu -- MySQL General Mailing

Re: Upgrade from 4.0.26 to 5.0.67

Nanu Kalmanovitz schrieb: Hi! I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67. Is there any possibility to upgrade directly from MySQL 4.0.26 to 5.0.67, without upgrading first to the intermediate versions? yes, but

about powerbuilder calling SP

hi guys, I used powerbuilder to connect MySQL database,but it seems like that powerbuilder can not call stored procedure in my database. It said the database does not currently support retrieval of procedure text. Is this ok? or I was wrong somewhere. Thanks. *^_^*

Re: Upgrade from 4.0.26 to 5.0.67

FYI the manual for 5.0 recommends upgrading to 4.1 first. As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. If you wish to upgrade from a release series previous to MySQL 4.1, you should

Re: Zip Codes with Leading Zeros

FYI, we have the same issue with exporting phone numbers from MS SQL. All phones numbers in the UK start with zero which causes no end of grief when exporting data to Excel. Even if we then change the column data type to text, it doesn't put the zeros back in (it's like Excel has deleted

multiple mysql service on the same server

Hi All, I am asking a very simple question. I need to install two mysql service (instances) on the same server. I know we can do that using different port, but should i use two different my.cnf files, and also, what is the procedure to stop one mysql service and keep other one running. regards

Re: Zip Codes with Leading Zeros

Hi Keith, I don't know how to fix it in MySQL, but if you import them into Excel, select the zip code field, go under format rows under the Special option is Zip Code. If you use that it will add a leading zero to any field that does NOT have at least 5 characters. Also.. If you have

Re: Zip Codes with Leading Zeros

Keith Spiller schrieb: Hi Johnny, Yeah. Sadly I missed the fact that the zip codes were hacked in our original Works to MySQL conversion until long after I had imported the data into our current MySQL table. Now we have to fix the numbers in our MySQL table and guarantee that we can

Re: multiple mysql service on the same server

You really need different config files if you're going to log anything or if you need different server ids. You should also use different sockets. You can stop a specific server by specifying the host on the mysqladmin shutdown command. I did it by keeping everything different, including the

Loading data on Master

I'm new to bin-logging and replication. I have a database, about 3GB that I have been converting data off of an old system into this new one. The basic procedure is to take the database offline at 10PM once a week, export the entire DB as an SQL file using mysqldump then download and import it

RE: Zip Codes with Leading Zeros

-Original Message- From: Keith Spiller [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 10:12 PM To: mysql@lists.mysql.com Subject: Zip Codes with Leading Zeros Hi, RE: Zip Codes with Leading Zeros We need to export a MySQL table with a zip code field to Excel. We currently

RE: Zip Codes with Leading Zeros

-Original Message- From: Andy Shellam [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2008 4:39 AM To: mysql@lists.mysql.com Subject: Re: Zip Codes with Leading Zeros FYI, we have the same issue with exporting phone numbers from MS SQL. All phones numbers in the UK start with zero

ERROR 1050 ( ) at line : Table 'columns_priv' already exists

Hi to list i ve installed new server. while i was restoring my backup to this server. i took this error and restoring procees is to stop. *ERROR 1050 ( ) at line : Table 'columns_priv' already exists* My old server mysql version is mysql-client-4.0.20 is running on old server but

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

You're restoring the mysql database itself, do you mean to do this? You probably do if it's a new server but there already exists a mysql database so, unless your restore program does DROP TABLE before each create, you'll keep getting this error. On Fri, Aug 22, 2008 at 10:22 AM, Deniss Hennesy

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

As I said, it appears your mysqldump output is not doing a DROP TABLE before each create. You need to correct that. Do the drop table commands yourself, then load the tables. Afterwards, do a FLUSH PRIVILEGES to activate the new permissions.l 2008/8/22 Deniss Hennesy [EMAIL PROTECTED] İ am

Is there a GROUP function that can help me with this?

Hi MySQL Users- I have a query problem I have been working on for quite some time and I am really at a loss to find a native function(s) to handle my task. I have this table: CREATE TABLE BookCategoryMetrics ( BookName VARCHAR(255), CategoryId VARCHAR(128), RatingSum DOUBLE, Cost DOUBLE,

Failed auth loggin

Hello, I've been looking through the documentation/list and haven't found anything directly on this subject. It's possible that I'm just not looking in the right place. I would like to log all failed authentications to the server. It would be nice to be able to log the attempted user

ME VOY A CASAR !!!!!

hola amigosss...cuanto tiempo no? sorry por la ingratitud! COMO ESTAN? ESTO VA PARA LAS PERSONAS QUE QUIERO Y QUE NECESITO QUE ME ACOMPAÑEN DE CORAZÓN EN ESTE DIA TAN ESPECIAL PARA MI... LES COMENTO QUE HE TOMADO UNA DECISION IMPORTANTE EN MI VIDA... BUENO POR LO PRONTO EL CIVIL, TAL VEZ CREAN

Re: Is there a GROUP function that can help me with this?

David, My goal is to create a report, that lists the Top 100 most expensive BookNames, for every CategoryId in this table. I think you can map the example under Within-group quotas (Top N per group) at http://www.artfulsoftware.com/infotree/queries.php to your requirement. PB David