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]

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 for

Re: ORDER BY problem

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

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

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: Adding InnoDB support

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 Support [EMAIL PROTECTED] wrote: Hi 1 user has

Re: Adding InnoDB support

- Original Message - From: Hassan Schroeder [EMAIL PROTECTED] To: Obantec Support [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, September 12, 2005 4:51 PM Subject: Re: Adding InnoDB support Obantec Support wrote: I found upgrading info but no info on how to install a second

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:09Obantec Support : Hi I have a database supplied to me

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

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,

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