moving from 3.23.58 to 5.0.45

Hi are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 moving from a Fedora Core3 to Centos5.2 server. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER BY problem

ompany SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes REGEXP "^R" and gold_id="2" ORDER BY Company ASC -Original Message- From: Obantec Support [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2008 9:29 AM To: mysql@lists.mysql.com Subject:

ORDER BY problem

Hi while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes REGEXP "^R" and gold_id="2" ORDER BY "Company" ASC on mysql server3.23.58 i get company result in ASC order. on mysql server4.1.22 i get non ASC order f

u/g to 4.1.22 but now getting mysql_connect() error in php

Hi FC3 test box running mysql 3.23.58 and php 4.3.9 worked ok. (i know they are old but is only a local test box server for testing before i update a live version). installed mysql 4.1.22 and it starts up ok 080626 20:14:58 mysqld started 080626 20:14:59 InnoDB: Started; log sequence numbe

Re: Adding InnoDB support

- Original Message - From: "Hassan Schroeder" <[EMAIL PROTECTED]> To: "Obantec Support" <[EMAIL PROTECTED]>; Sent: Monday, September 12, 2005 4:51 PM Subject: Re: Adding InnoDB support > Obantec Support wrote: > > > I found upgrading info

Re: Adding InnoDB support

is not so simple and many providers install another > MySQL server and then clients move their applications to it. See: > http://dev.mysql.com/doc/mysql/en/upgrade.html > > Use an official rpms or binaries from: > http://dev.mysql.com/downloads/ > > > > "Obantec Supp

Adding InnoDB support

Hi 1 user has requested InnoDB support. can i simple get the mysql-max rpm an use yum to install over the existing mysql server. currently running FC3 with default 3.23.58 I would upgrade to 4.x but a lot of user databases and i am worried about loosing data, so for now a quick fix is in order.

Re: A little SQL query help

- Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Obantec Support" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 27, 2003 2:05 AM Subject: Re: A little SQL query help > Hi Mark, > > 2003年 7月 27日 日曜日 06:09、Ob

A little SQL query help

Hi I have a database supplied to me that was excel but now uploaded to mysql. (the data is out of my hands.) i need to search for 1 of 2 categories against 3 fields with user inputted data. example Categories=Lessor , searchtype = BusinessCity searchdata = (user input) $sql = "SELECT * FROM Con

Cannot get example to work

Hi http://www.mysql.com/doc/en/Fulltext_Search.html the create and insert of data went ok but when i do SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); i get SQL-query I am using RH8.0 and mysql 3.23.56 and php 4.3.2 I connect ok and my other code works SELECT term, expl

diff between 7.2 and 8.0 rights?

Hi I have 2 servers both with 3.23.56-1 installed via rpm's proteus2 which is running RedHat 7.2 on 1 cpu and has been in use for over 1 year works as expected. [EMAIL PROTECTED] [/var/lib/mysql]# mysqladmin status Uptime: 515357 Threads: 1 Questions: 2412696 Slow queries: 782 Opens: 19654