SQL Image Viewer 2.4.0.132 released

SQL Image Viewer helps you retrieve, view, convert and export images and binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF, and

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

Mysql5.0 Connector J issue with Tomcat 4

Dear Person in charge: We recently replaced mysql 4.0.16 with the free version of mysql 5.0.45 and the access from Tomcat 4 to the database has stopped working. It says java.sql.SQLException: Communication failure during handshake. Is there a server running on 192.168.2.34:3306? The server

mysql on a NAS

Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every

DWHS inc.

Hello, Is there anything we can do to help the MySQL project, we are firm believers and would like to contribute in some way. We have a several 100 mps connections and server space. Thank you, Charles DWHS Inc. Manager http://www.dwhs.com http://www.dwhs.com/hostingforum/

Thank you for your email support request

Thank you for your email support request. Our support team will respond with the recommended solution in the quickest time possible, but may be delayed due to the complexity of the problem or volume of requests for support. Once we have replied to your initial question, please be sure to use

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

Hi I found upgrading info but no info on how to install a second mysql server. Mark - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, September 12, 2005 12:42 PM Subject: Re: Adding InnoDB support Hello. Usually it is not so simple

Re: Adding InnoDB support

My original question was how to add InnoDB support to 3.23.58 server. It was suggested that i could run a second server. as i have FC3 i use yum to add / update programs. are you suggesting i get the source , unpack and build the server setting some configs to run it on a different port? Mark

[ANN] DBManager Professional 3.0.2 Released

WebService (Datasheet StatusBar) p.. Dump Tables now Dumps triggers of the selected table correctly (SQLITE) q.. When Dumping only one table do not dump objects that are not table children New Features a.. Servers Sorted By Name b.. Added Role Support for Interbase/Firebird (Server Properties

[ANN] Webyog releases FREE edition of SQLyog

at regular intervals * ODBC Import - Wizard driven painless migration to MySQL Please visit the following link for to view the feature comparison between SQLyog and SQLyog Enterprise. http://www.webyog.com/sqlyog/featurematrix.html Thanks for your attention! Webyog Support http://www.webyog.com

SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23

. Doing SLAVE STOP; SLAVE START; has no effect. Fix: Unknown (except to work around it as shown above). Submitter-Id: submitter ID Originator:root Organization: NewsNow Publishing Limited MySQL support: none Synopsis: SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23

Re: Excel file

Please read the attached file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: To Re-write complex query with JOINS

they are the recent one for othertableid = 1 and 2 respectively. Please be sure that I want to retrive all fields including RecordId. The result should not depend on any other fields but EffectiveDate only. I am using MySQL 4.0.12 and it does not support SUBQUERIES which is now given support

Re: 4.1.1 not an update or upgrade of 4.1.0

Hi, I also faced this kind of error in sub query, any solution for this?: -Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 When the SUB-SELECT contains more than one field, it does not work (this works

Re: converting tables MyISAM to InnoDB

Unknown Sender [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I recently upgraded from MySQL v3.23 to MySQL 4, and converted my tables from MyISAM to InnoDB by using the ALTER TABLE command. I did this for 16 tables. I know that MyISAM creates seperate data/index files for

InnoDB file data size against MyISAM files data sizes

Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives:

Re: Getting a particular row from GROUP BY

Michael Shuler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What would be the rules for deciding if id 3 should be fr or de? if 'en' does not exist, then it does not matter which language is returned (even be the first available language in the rows order in the DB). But would be

Re: Getting a particular row from GROUP BY

Thanks for your help, but it is not giving the result. The problem is that when you make GROUP BY id then the row representing the group is the first row in the group, and adding ORDER BY ... after the group by part just orders the grouped rows, but the grouped rows are in the wrong languages,

RE: Excel 2 CSV into phpMyAdmin

I save as CSV (MS-DOS). I then import into MySQL using SqlYog and the following parameters: Line terminator \r\n Delimiter , Strings Optionally surrounded by That gives me a successful import every time. I have tried other variations and achieved same results as you - 'jumbled'

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

Data query by date

Hi all. I have spent some time studying the manual and previous posts, trying to get a grip on the whole date_format issue... I am VERY new to MySQL having been converted from an ADO/DAO environment with Access dBs... Where I am having trouble is coming up for a syntax to SELECT * FROM tableA

MysQL Installation

I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - Before posting, please check:

RE: MysQL Installation

PROTECTED] Subject: RE: MysQL Installation Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed

RE: MySQL Installation

: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 12:51 PM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: MysQL Installation Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page

Re: rename database

From what I heard, yes. If you stop MySQL, then rename the dir/database. It may work. Worked for me (did it about 3 months ago). HTH, Ricardo. - Original Message - From: Jorge Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:57 AM Subject: rename

error updating table

Hi, we have an application that connect to MySQL via MyODBC. Sometimes, we have this error: [TCX][MyODBC] Got error 5 from table handler and MySQL drops. When it comes back up, it first gives an error with BDB tables (the type we use): 020911 15:10:17 bdb: page 0: illegal page type or format

MySQL statement problem

Shouldn't this come up with a list of names from each table that matches? SELECT * FROM table1,table2 WHERE table1.name = table2.name; Does anyone see anything wrong with this query? It keeps giving me an empty set - but there definitely matches. I even did a LIKE instead of =, takes

SQL Sorting

Hi, I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns with Russian entries doesn't work properly. Is there an easy way to resolve this and sort rows by Russian alphabet? Vyacheslav -

SQL-query

Hello, A real SQL-query works well SELECT MAX(date_value) AS date_value FROM dates WHERE version_id='2' But the problem is, that I can't get a value of another column, i.e. the row in a table consists of three columns - id, date_value and version_id The task - to get a value of id column

Data transition

Hello, everybody! Please give me a hint at some resources about synchronization of two MySQL databases, situated in different places. The point is, I have my local and providers' versions of the same database. And need to synchronize them at a daily basis with the least traffic involved.

Determining character set from table data

Hello, I am wondering if there is any way to determine the character set used for data in a table. For example, a single database has 10 tables, six with 'latin1' characters, two with 'cp1251' characters, and two with 'greek' characters. The character_set variable is set to 'latin1' on this

Announcing native .NET provider to MySQL

Hello, This is an announcement of a new product that will interest some of you. I have completed work for the first Beta release of a native ADO.NET provider to MySQL. You can find the details at http://www.mattculbreth.com/eidmysql. Thank you, Matt Culbreth

databases under users dir

Hi Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. Mark -- Obantec Support www.obantec.net WebHosting and Domains

Re: databases under users dir

Hi Thanks for the tip! it works fine. Now all i need to do is modify my create database code to use $HOME/mysql and make symbolic link Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Original Message - From: Andreas Frøsting [EMAIL PROTECTED

Getting Data From One Table Based On Another - Agh!

Looking through the MySQL stuff online, I still can't come up with a statement to pull data from one table based on data from another. Table1 Contains: orderid Table2 Contains: orderid otherfield1 otherfield2 I want to get the data from table 2 based on a matching orderid first pulled from

RE: Is The MySQL Mailing List On Crack?

Jeremy Zawodny wrote : I'm getting duplicate messages separated by several hours. Am I alone in this, or are others seeing it too? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408)

Granting Privileges

Hey there! Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic

User/database permissions

This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it

many connection errors

MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in

Re: many connection errors

. It is prob caused by more of my users having php forums. What i need to find out is root of the cause Mark - Original Message - From: [EMAIL PROTECTED] To: Support [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 3:50 PM Subject: Re: many connection errors Support wrote

New flavor of Got an error reading communication packets

Greetings - I believe I have a new flavor of this error. I am running mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) on Red Hat Linux release 7.0 (Guinness) Kernel 2.4.2-2smp on an i686 (the database host) I have two machines running mysql Ver 11.12 Distrib 3.23.32, for

3.23 and 3.22 API incompatibles?

I'm using Free Pascal 1.0.4 and MySQL 3.22.32 System is RedHat 7.2 (but the same is on RH 6.2) The Free Pascal package contains mysql unit which makes able to pipe sql queryes from pascal to mysql. All worked fine until 3.22.32. But in 3.23.xx (tested on 3.23.38 and 3.23.44),the error with

Problem with the Installation of MySql 3.23 on Linux 7.1

a message that the package is not installed. at this point i tried to reinstall the MySql and i got a message that Mysql 3.23 is already installed. it would be helpful if anyone could throw some light on this.. regards Support

Changement de l adresse du support Technique.

Madame, Monsieur, Suite à notre rachat par VERIO Leader Mondial de l'hébergement cette adresse n'est plus valide. Pour joindre notre support vous devrez désormais suivre cette procédure : 1/ envoyez vos emails à l'adresse suivante : « [EMAIL PROTECTED] » 2/ Le sujet devra être libellé de

RE: Unknown column in 'where clause' error

Hello, Your field(column) is a CHAR and therefore the parameter to it should be in single quotes: Change your query to: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' * * Visit http://www.computerstaff.net -

RE: Unknown column in 'where clause' error

You are using PHP. Well PHP is not ASP :-) clever and you can enclose your variable in single quotes as in: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Hope this helps. * * Visit

MySQL 4 and WINDOWS

Hello, Has anyone managed to compile the BETA version of MySQL 4 for Windows? I have downloaded the source however, it appears to be for LINUX or UNIX. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *

Pound (£) Symbol and MySQL

Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? *

RE: Pound (£) Symbol and MySQL

Hello All, I have tried the settings as suggested in this FORUM like using htmlentities etc... however, my pound sign in the database is displayed as: ú Any more tips help etc... -Original Message- From: technical Support [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 21:53

Oracle 2 MySQL

Hello, Does anyone know of any tool that will take an ORACLE database and port it to mySQL? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *

RE: Fulltext Strange Results...

Golubchik [mailto:[EMAIL PROTECTED]] Sent: 20 May 2001 22:44 To: technical Support Subject: Re: Fulltext Strange Results... Hi! On May 20, technical Support wrote: I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic

Fulltext Strange Results...

Hello, I did the following query against my indexed table: select * from indexed_table where match(indexed_col) against ('oracle +sybase +london') It returned 16 rows of which only 4 rows included all words. I then did: select * from indexed_table where match(indexed_col) against ('+oracle

Fulltext and phrases

I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise.

Fulltext and 2 to 3 character words...

Hello, I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len = 0. However, my a query like select * from table_name where match(col) against('asp') returns nothing, when a similar like query returns several rows of data. Also a query like select * from table_name where

TheCasino.com: Registration Confirmation

Jackpot' link at the top of the screen. And then select 'Real Money Games'. Go for the US$13662.57 Jackpot now!! Please do let us know if we can ever be of assistance! Regards, The Support Staff TheCasino.com Corporation http://www.TheCasino.com [EMAIL PROTECTED] TheCasino.com - Better Than Life

TheCasino.com: You have been removed!

heCasino.com Monhtly Prize Drawings. Please let us know if we can be of further assistance. The Support Staff TheCasino.com, Corp. [EMAIL PROTECTED] http://www.theCasino.com - Before posting, please check: http://www.

TheCasino.com: You have been removed!

heCasino.com Monhtly Prize Drawings. Please let us know if we can be of further assistance. The Support Staff TheCasino.com, Corp. [EMAIL PROTECTED] http://www.theCasino.com - Before posting, please check: http://www.

[ANN] MySQL Studio v0.7 Released.

** After months of development We are proud to announce the first public version of MySQL Studio. http://dba-tools.com/ MySQL Studio provides an extremely easy to use interface to MySQL servers. A